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

Not a bug Error when trying to view forum node

Rudy

Well-known member
#1
Just got this after 1.2 Beta 1:

Code:
Mysqli prepare error: Unknown column 'forum_watch.node_id' in 'on clause'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/Forum.php at line 29
XenForo_Model_Forum->getForumById() in XenForo/ControllerHelper/ForumThreadPost.php at line 177
XenForo_ControllerHelper_ForumThreadPost->getForumOrError() in XenForo/ControllerHelper/ForumThreadPost.php at line 38
XenForo_ControllerHelper_ForumThreadPost->assertForumValidAndViewable() in XenForo/ControllerPublic/Forum.php at line 88
XenForo_ControllerPublic_Forum->actionForum() in XenForo/FrontController.php at line 335
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /usr/www/users/xxxxxxx/index.php at line 13
Going to start disabling plugins first, and will report progress here.

EDIT: plugins disabled, still get error.
 

Jeremy

Well-known member
#3
You have had [bd] Forum Watch installed. You need to run queries to get your table to match what XenForo expects.
 

Rudy

Well-known member
#4
You have had [bd] Forum Watch installed. You need to run queries to get your table to match what XenForo expects.
Aaah OK, that's it--I'll uninstall that add-on completely and fix the table up.

Now I'm wondering if other add-ons in the future will mess with XF upgrades. Thankfully this is our "sandbox" staff forum where we test things out. I run few if any add-ons in our production forum.
 

Jeremy

Well-known member
#5
As of the current release, the add-on doesn't drop the table. You have to do it manually.

If developers use proper prefixing within their add-ons (names, code, etc.), conflicts such as these shouldn't be an issue.
 

Wulfspider

Active member
#6
Aaah OK, that's it--I'll uninstall that add-on completely and fix the table up.

Now I'm wondering if other add-ons in the future will mess with XF upgrades. Thankfully this is our "sandbox" staff forum where we test things out. I run few if any add-ons in our production forum.
See my reply above the other reply, it links to fixes. ;)
 

Rudy

Well-known member
#8
If developers use proper prefixing within their add-ons (names, code, etc.), conflicts such as these shouldn't be an issue.
Exactly! This is why I'm hesitant to install add-ons, especially after this fiasco. Thankfully it was minor, and didn't affect our production forum.