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

XF 1.4 Mysqli prepare error: Unknown column 'forum.node_id' in 'where clause'

Discussion in 'Troubleshooting and Problems' started by Chris Radford, Mar 15, 2015.

  1. Chris Radford

    Chris Radford Member

    Hi,

    Yesterday I posted about an issue with our forum, we had to restore a prior backup to fix the issue. Please see here; https://xenforo.com/community/threads/a-server-error-occurred-please-try-again-later.94735/

    Today, we have the following error;

    Server Error
    Mysqli prepare error: Unknown column 'forum.node_id' in 'where clause'

    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
    5. XenForo_Model->fetchAllKeyed() in XenForo/Model/Forum.php at line 133
    6. XenForo_Model_Forum->getExtraForumDataForNodes() in XenForo/NodeHandler/Forum.php at line 85
    7. XenForo_NodeHandler_Forum->getExtraDataForNodes() in XenForo/Model/Node.php at line 571
    8. XenForo_Model_Node->mergeExtraNodeDataIntoNodeList() in XenForo/Model/Node.php at line 773
    9. XenForo_Model_Node->getNodeListDisplayData() in XenForo/Model/Node.php at line 745
    10. XenForo_Model_Node->getNodeDataForListDisplay() in XenForo/ControllerPublic/Forum.php at line 81
    11. XenForo_ControllerPublic_Forum->actionIndex() in WidgetFramework/XenForo/ControllerPublic/Forum.php at line 13
    12. WidgetFramework_XenForo_ControllerPublic_Forum->actionIndex() in Borbole/RecentThreads/ControllerPublic.php at line 8
    13. Borbole_RecentThreads_ControllerPublic->actionIndex() in XenForo/FrontController.php at line 347
    14. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    15. XenForo_FrontController->run() in /home/onefootb/onefootballforum.co.uk/index.php at line 13

    I do have access to the AdminCP, can anybody please advise?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    That would suggest the backup is also corrupt as a column appears to be missing.

    Can you run this query in phpMyAdmin and paste the full text output?
    Code:
    show create table xf_forum;
     
  3. Chris Radford

    Chris Radford Member

    Thanks for the quick reply. The backup was working for 24 hours before seemingly breaking again.

    How I have done the query correctly, here you go;

     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Unfortunately the node_id column is missing.

    I can only suggest restoring from an older, viable backup.

    You may want to check whether any add-ons you have installed are responsible for the disappearing columns.
    Or whether it is someone manually doing it (you can check the server logs).
     
  5. Chris Radford

    Chris Radford Member

    Thanks for the quick response.

    You may want to check whether any add-ons you have installed are responsible for the disappearing columns.
    Do you have a method for doing this, other than uninstalling them all and seeing if that solves the issue?
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    In this case it may just be easier to contact the developers and ask them, unless you know what you're looking for in the code.
     
  7. Market1234

    Market1234 Member

    I'm having the same issue... Not sure why it is just dropping
     
  8. Chris Radford

    Chris Radford Member

    How often has is happened for you?
     
  9. Tracy Perry

    Tracy Perry Well-Known Member

    The two of you may want to get together in a convo and compare add-ons that both are using, and see if you can eliminate them. One of the first ones I'd be looking at for commonality would be Borbole's Recent threads.. then widget framework. Also look at another other add-ons that both of you use that deal with the nodes in any way.

    I use Widget Framework with no problems - but that doesn't preclude it may be interacting with another add-on.

    Also, are both of you using the same hosting provider?
     
    Chris Radford likes this.
  10. Chris Radford

    Chris Radford Member

    Thanks for the response Tracy, just stepping out for the night but wanted to thank you for the guidance. @Market1234 , feel free to drop me a PM or let me know your Skype.
     

Share This Page