• 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

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

Code:
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) {
  }
}
 

Brogan

XenForo moderator
Staff member
#4
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.
 

Brogan

XenForo moderator
Staff member
#7
Run this query and select show full texts:
Code:
show create table xf_thread_read;
Paste the output here.
 

Mike

XenForo developer
Staff member
#8
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.
 

Chris D

XenForo developer
Staff member
#9
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.
 

Chris D

XenForo developer
Staff member
#10
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.