XF 1.2Unknown column 'forum.node_id' in 'where clause'

Go to page

Active member

Since today, I can't access to my forum due I see the following error:

Code:

Server Error
Mysqli prepare error: Unknown column 'forum.node_id' in 'where 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 XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Forum.php at line 133
XenForo_Model_Forum->getExtraForumDataForNodes() in XenForo/NodeHandler/Forum.php at line 85
XenForo_NodeHandler_Forum->getExtraDataForNodes() in XenForo/Model/Node.php at line 571
XenForo_Model_Node->mergeExtraNodeDataIntoNodeList() in XenForo/Model/Node.php at line 760
XenForo_Model_Node->getNodeDataForListDisplay() in XenForo/ControllerPublic/Forum.php at line 40
XenForo_ControllerPublic_Forum->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home3/nomuscle/public_html/community/index.php at line 13

I've disabled all add-ons (through config.php file) but the error still there and I can't figure how to resolve it. I've a backup so please let me know if I need to restore a specific table (not the entire database) in order to fix this.

Member

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 XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Forum.php at line 133
XenForo_Model_Forum->getExtraForumDataForNodes() in XenForo/NodeHandler/Forum.php at line 85
XenForo_NodeHandler_Forum->getExtraDataForNodes() in XenForo/Model/Node.php at line 565
XenForo_Model_Node->mergeExtraNodeDataIntoNodeList() in XenForo/Model/Node.php at line 754
XenForo_Model_Node->getNodeDataForListDisplay() in XenForo/ControllerPublic/Index.php at line 12
XenForo_ControllerPublic_Index->actionIndex() in XenForo/FrontController.php at line 313
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /data01/c9272808/public_html/index.php at line 13

Member

Active member

I was able to restore that table from an old backup and my forum went online again. Today it was broken again, I restored the backup I made yesterday (which was executed after restore the table) and 3 hours ago the error happened again.

Now, I've disabled all add-ons and will check it this happens again. I checked the file integrity and everything is okay. I'm tired of this error and the worst thing is that I don't know what might be causing it! A table can't be deleted by none reason :S

Active member

This is Misty now... am trying to reach Ivan as we speak. He uninstalled the "nodes as tabs" add-on (to the best of my knowledge) but turned all the other add-ons back on. Worked fine for about 3-4 hours, and now... I was creating a thread, hit "create new thread" when I was done and got an error pop-up saying "forum doesn't exist" or something like that. I saved my thread I was working on, and refreshed my screen, and now my forum base is SHOWING, but with NO FORUMS in it! Argh!!! I am getting really upset now. There is no error code to report this time or anything.