Tickets Fixed Another MySQL error

[MattW]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'execution_order' in 'order clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 1:30 AM
Stack Trace
#0 /home/nginx/domains/mattwservices.co.uk/public/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n    \t    SELEC...')
#1 /home/nginx/domains/mattwservices.co.uk/public/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n    \t    SELEC...')
#2 /home/nginx/domains/mattwservices.co.uk/public/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n    \t    SELEC...')
#3 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n    \t    SELEC...', Array, 2)
#4 /home/nginx/domains/mattwservices.co.uk/public/library/NixFifty/Tickets/Model/Escalation.php(30): XenForo_Model->fetchAllKeyed('\n    \t    SELEC...', 'escalation_id')
#5 /home/nginx/domains/mattwservices.co.uk/public/library/NixFifty/Tickets/CronEntry/Escalation.php(12): NixFifty_Tickets_Model_Escalation->getAllActiveEscalations()
#6 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Model/Cron.php(356): NixFifty_Tickets_CronEntry_Escalation::run(Array)
#7 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999990463257, '')
#9 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999990463257, '', false)
#10 /home/nginx/domains/mattwservices.co.uk/public/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#11 /home/nginx/domains/mattwservices.co.uk/public/deferred.php(23): XenForo_Model_Deferred->run(false)
#12 {main}

 

[Naz]

Already sorted but run this:

ALTER TABLE `xf_nixfifty_ticket_escalation` ADD COLUMN `execution_order` int(10) unsigned NOT NULL DEFAULT '0'

 

[MattW]

Thank you