Tickets Fixed Unknown column 'ticket.discussion_state' in 'where clause'

[Alpha1]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'ticket.discussion_state' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Alfa, 1 minute ago

Stack Trace
#0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n SE...')
#1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n SE...')
#2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n SE...')
#3 /library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n SE...', Array, 2)
#4 /library/NixFifty/Tickets/Model/Ticket.php(126): XenForo_Model->fetchAllKeyed('\n SE...', 'ticket_id')
#5 /library/NixFifty/Tickets/ControllerPublic/Ticket.php(240): NixFifty_Tickets_Model_Ticket->getTickets(Array, Array)
#6 /library/XenForo/FrontController.php(351): NixFifty_Tickets_ControllerPublic_Ticket->actionQueue()
#7 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(37) "https://forum.com/tickets/queue"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Naz]

Thanks, this is fixed now. You can run this SQL query to fix it:

ALTER TABLE xf_nixfifty_ticket ADD COLUMN discussion_state ENUM('visible','moderated','deleted') NOT NULL DEFAULT 'visible' AFTER `ticket_locked`

 

[Alpha1]

Thanks!