Tickets Not a Bug Mysqli prepare error: Unknown column 'last_status_change_date' in 'field list'

Fellowsfilm

Well-Known Member
Stack Trace:
Code:
#0 /home/afellows/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_nixf...')
#1 /home/afellows/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_nixf...')
#2 /home/afellows/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_nixf...')
#3 /home/afellows/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_nixf...', Array)
#4 /home/afellows/public_html/internal_data/proxy_classes/XenForo_DataWriter__1506781796.php(1654): Zend_Db_Adapter_Abstract->update('xf_nixfifty_tic...', Array, 'ticket_id = 27')
#5 /home/afellows/public_html/internal_data/proxy_classes/XenForo_DataWriter__1506781796.php(1623): XFProxy_XenForo_DataWriter->_update()
#6 /home/afellows/public_html/internal_data/proxy_classes/XenForo_DataWriter__1506781796.php(1419): XFProxy_XenForo_DataWriter->_save()
#7 /home/afellows/public_html/library/NixFifty/Tickets/DataWriter/TicketMessage.php(944): XFProxy_XenForo_DataWriter->save()
#8 /home/afellows/public_html/library/NixFifty/Tickets/DataWriter/TicketMessage.php(504): NixFifty_Tickets_DataWriter_TicketMessage->_saveDiscussionDataWriter()
#9 /home/afellows/public_html/internal_data/proxy_classes/XenForo_DataWriter__1506781796.php(1423): NixFifty_Tickets_DataWriter_TicketMessage->_postSave()
#10 /home/afellows/public_html/library/NixFifty/Tickets/ControllerPublic/Ticket.php(2251): XFProxy_XenForo_DataWriter->save()
#11 /home/afellows/public_html/library/XenForo/FrontController.php(351): NixFifty_Tickets_ControllerPublic_Ticket->actionInsertReply()
#12 /home/afellows/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /home/afellows/public_html/index.php(13): XenForo_FrontController->run()
#14 {main}

Request State
Code:
array(3) {
  ["url"] => string(72) "https://fellowsfilm.co.uk/tickets/my-addons-dont-install.27/insert-reply"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["message_html"] => string(172) "<p>My problem is that it doesn't install and there's so many folders, I think you might need to give me some instructions how to install buses and maps in the future.</p>
"
    ["_xfRelativeResolver"] => string(60) "https://fellowsfilm.co.uk/tickets/my-addons-dont-install.27/"
    ["attachment_hash"] => string(32) "06a6faa2a562aa7c004f0f219d756055"
    ["last_date"] => string(10) "1501505074"
    ["last_known_date"] => string(0) ""
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(35) "/tickets/my-addons-dont-install.27/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

Nix

Administrator
Staff member
For some reason, one of the queries wasn't executed. Run this:

Code:
alter table xf_nixfifty_ticket add column last_status_change_date INT(10) UNSIGNED NOT NULL DEFAULT '0'
 
Top