XF 1.3 Server Error - XF1.3.1

[Falkor]

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

 

[Jeremy]

Did you recently remove any add-ons?

 

[Falkor]

I did a few days back

 

[Paul B]

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.

 

[Falkor]

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

 

[Falkor]

Looks like it is still where it should be

 

[Paul B]

Run this query and select show full texts:

show create table xf_thread_read;

Paste the output here.

 

[Mike]

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]

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]

Ok fixed.

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

So, ultimately, this was bypassing the registration assertion.

 

[Falkor]

Ah thanks Chris