Not a bug SQL Error

[Brent W]

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum_watch.node_id' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: NateG, A moment ago
Stack Trace
#0 /home/forum/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('????SELECT node...')
#1 /home/forum/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '????SELECT node...')
#2 /home/forum/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('????SELECT node...')
#3 /home/forum/public_html/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('????SELECT node...', 3)
#4 /home/forum/public_html/library/XenForo/Model/Forum.php(29): Zend_Db_Adapter_Abstract->fetchRow('????SELECT node...', 3)
#5 /home/forum/public_html/library/XenForo/ControllerHelper/ForumThreadPost.php(177): XenForo_Model_Forum->getForumById(3, Array)
#6 /home/forum/public_html/library/XenForo/ControllerHelper/ForumThreadPost.php(38): XenForo_ControllerHelper_ForumThreadPost->getForumOrError(3, Array)
#7 /home/forum/public_html/library/XenForo/ControllerPublic/Forum.php(88): XenForo_ControllerHelper_ForumThreadPost->assertForumValidAndViewable(3, Array)
#8 /home/forum/public_html/library/XenForo/FrontController.php(335): XenForo_ControllerPublic_Forum->actionForum()
#9 /home/forum/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/forum/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
  ["url"] => string(55) "http://www.forumadminsource.com/forums/announcements.3/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Jeremy]

Did you ever have [BD] Forum Watch installed? You still have that old table in there. I'll find the thread discussing this.

Edit: Here's the thread (with a solution):
http://xenforo.com/community/threads/forum-watch-error.52860

 

[Paul B]

Do you have the forum watch add-on installed?

http://xenforo.com/community/threads/forum-watch-error.52860/

 

[Brent W]

I had it installed. I removed the addon before upgrading however.

 

[xf_phantom]

http://xenforo.com/community/threads/forum-watch-error.52860/

 

[xf_phantom]

you'll have to drop the table and create it yourself ( http://xenforo.com/community/threads/forum-watch-error.52860/ )

 

[Brent W]

Thanks