Tickets Fixed Unknown column 'execution_order'

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:35 AM
Stack Trace
#0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n \t SELEC...')
#1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n \t SELEC...')
#2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n \t SELEC...')
#3 /library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n \t SELEC...', Array, 2)
#4 /library/NixFifty/Tickets/Model/Escalation.php(30): XenForo_Model->fetchAllKeyed('\n \t SELEC...', 'escalation_id')
#5 /library/NixFifty/Tickets/CronEntry/Escalation.php(12): NixFifty_Tickets_Model_Escalation->getAllActiveEscalations()
#6 /library/XenForo/Model/Cron.php(356): NixFifty_Tickets_CronEntry_Escalation::run(Array)
#7 /library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999980926514, '')
#9 /library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999980926514, '', false)
#10 /library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#11 /deferred.php(23): XenForo_Model_Deferred->run(false)
#12 {main}
Request State
array(3) {
["url"] => string(36) "https://forum.com/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(3) {
["_xfRequestUri"] => string(8) "/forums/"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 
Should be sorted. Run this:
Code:
ALTER TABLE `xf_nixfifty_ticket_escalation` ADD COLUMN `execution_order` int(10) unsigned NOT NULL DEFAULT '0'
 
Back
Top