1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Resolved Bug Reports' started by Tom Howard, Oct 8, 2017.

  1. Tom Howard

    Tom Howard 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"
      }
    }
     
  2. NixFifty

    NixFifty 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'
     
    Tom Howard likes this.