Tickets Fixed Clean Install of Latest Beta

[MattW]

Mysqli prepare error: Unknown column 'ticket.discussion_state' in 'where clause'

[LIST=1]
[*]Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
[*]Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
[*]Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
[*]Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
[*]XenForo_Model->fetchAllKeyed() in NixFifty/Tickets/Model/Ticket.php at line 126
[*]NixFifty_Tickets_Model_Ticket->getTickets() in NixFifty/Tickets/ControllerPublic/Ticket.php at line 240
[*]NixFifty_Tickets_ControllerPublic_Ticket->actionQueue() in XenForo/FrontController.php at line 351
[*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
[*]XenForo_FrontController->run() in /home/nginx/domains/mattwservices.co.uk/public/index.php at line 13

[/LIST]

 

[Naz]

Cheers, someone reported this before. Fixed this for next release but run this query for now.

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