Tickets Fixed Unknown column 'message_from_username' in 'field list'

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'message_from_username' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Alfa, A moment ago

Stack Trace
#0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_nixfifty_tic...', Array)
#5 /library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#6 /library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#7 /library/NixFifty/Tickets/ControllerAdmin/Escalation.php(137): XenForo_DataWriter->save()
#8 /library/XenForo/FrontController.php(351): NixFifty_Tickets_ControllerAdmin_Escalation->actionSave()
#9 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(59) "https://forum.com/admin.php?ticket-escalations/0/save"
["_GET"] => array(1) {
["ticket-escalations/0/save"] => string(0) ""
}
["_POST"] => array(12) {
["escalation_title"] => string(25) "Pending after staff reply"
["escalation_description"] => string(0) ""
["execution_order"] => string(2) "10"
["enabled"] => string(1) "1"
["actions"] => array(2) {
["category_id"] => string(1) "0"
["ticket_status"] => string(7) "pending"
}
["message_body"] => string(0) ""
["message_from_username"] => string(0) ""
["ticket_criteria"] => array(2) {
["last_reply_is_staff"] => array(1) {
["rule"] => string(19) "last_reply_is_staff"
}
["ticket_state"] => array(2) {
["rule"] => string(12) "ticket_state"
["data"] => array(1) {
["state"] => string(4) "open"
}
}
}
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(33) "/admin.php?ticket-escalations/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 
Run this query:
Code:
ALTER TABLE `xf_nixfifty_ticket_escalation` ADD COLUMN `message_from_username` VARCHAR(50) NOT NULL DEFAULT ''
 
Back
Top