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

XF 1.3 Server Error - XF1.3.1

Discussion in 'Troubleshooting and Problems' started by Falkor, May 1, 2014.

  1. Falkor

    Falkor Member

    We have the following server error coming up a few times a day

    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'thread_read.thread_read_date' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, Today at 1:29 PM
    Stack Trace
    #0 /var/www/vhosts/triumphtalk.com/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
    #1 /var/www/vhosts/triumphtalk.com/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
    #2 /var/www/vhosts/triumphtalk.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
    #3 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', 0, 2)
    #4 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/Model/ThreadWatch.php(325): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id', 0)
    #5 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/ControllerPublic/Watched.php(161): XenForo_Model_ThreadWatch->getThreadsWatchedByUser(0, true, Array)
    #6 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Watched->actionThreads()
    #7 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #8 /var/www/vhosts/triumphtalk.com/httpdocs/index.php(13): XenForo_FrontController->run()
    #9 {main}
    Request State
    array(3) {
      ["url"] => string(42) "http://www.triumphtalk.com/watched/threads"
      ["_GET"] => array(0) {
      ["_POST"] => array(0) {
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Did you recently remove any add-ons?
  3. Falkor

    Falkor Member

    I did a few days back
  4. Brogan

    Brogan XenForo Moderator Staff Member

    It's possible that one of those add-ons removed a column from a core table.

    Possibly something to do with watching threads.

    You will need to contact the developer for support.
  5. Falkor

    Falkor Member

    I have no idea what add on I may have removed as it was a good few days back and this only started coming up now
  6. Falkor

    Falkor Member

    Looks like it is still where it should be

  7. Brogan

    Brogan XenForo Moderator Staff Member

    Run this query and select show full texts:
    show create table xf_thread_read;
    Paste the output here.
  8. Mike

    Mike XenForo Developer Staff Member

    I can only guess there's an add-on involved that is adding a join or changing aliases to point to a different table. I really don't know what add-on would be doing that (or why) though.
  9. Chris D

    Chris D XenForo Developer Staff Member

    I cannot currently explain this, but this is caused by me, sadly :(

    @Falkor has a Beta copy of XMG 2.1 as he kindly tested my Photopost importer. The exact scenario is the error is thrown and logged specifically by guests attempting to view the Watched Threads page.

    I can reproduce it locally so I will get a fix to you ASAP @Falkor.
    Tracy Perry, Mike and Brogan like this.
  10. Chris D

    Chris D XenForo Developer Staff Member

    Ok fixed.

    I extended _preDispatch in the Watched controller but the parent return was commented out :whistle:

    So, ultimately, this was bypassing the registration assertion.
  11. Falkor

    Falkor Member

    Ah thanks Chris

Share This Page