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

XF 1.4 Server went offline, now New Posts doesn't work

Discussion in 'Troubleshooting and Problems' started by SeaDog, Nov 9, 2015.

  1. SeaDog

    SeaDog Active Member

    Server went offline for about 24 hours due to a hardware issue with our host.

    It's all back online now and following a table repair of the MySQL database powering our XF everything seems to be working - new posts are being made, threads can be opened, etc. etc.

    The only thing that's broken is when you click on "New Posts" you get this error (slightly edited for anonymity):

    An exception occurred: Mysqli prepare error: MySQL server has gone away in /var/www/vhosts/xxxx.co.uk/httpdocs/library/Zend/Db/Statement/Mysqli.php on line 77
    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 808
    Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Template/Public.php at line 130
    XenForo_Template_Public->_getTemplatesFromDataSource() in XenForo/Template/Abstract.php at line 572
    XenForo_Template_Abstract->_loadTemplates() in XenForo/Template/Abstract.php at line 556
    XenForo_Template_Abstract->_loadTemplate() in XenForo/Template/Abstract.php at line 180
    XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 139
    XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 618
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /var/www/vhosts/xxxx.co.uk/httpdocs/index.php at line 13
    This seems to be a cached error as MySQL server is no longer away (everything else continues to work fine as mentioned above).
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It appears there is still an issue with the MySQL server as search is returning the same error.
  3. SeaDog

    SeaDog Active Member

    As explained, the site is working fine and continues to work fine - only this one feature (search) is broken. Is there a tool we need to run to rebuild it or something? All tables are in the same MySQL and, as mentioned, browsing the rest of the site works fine - which it obviously wouldn't if MySQL had actually gone away. Also this server runs 1 x vB and 1 x IPB which are working ok.
    Last edited: Nov 9, 2015
  4. SeaDog

    SeaDog Active Member

    What should we do? Create a support ticket?
  5. Brogan

    Brogan XenForo Moderator Staff Member

    As the problem occurred after a server outage, it is going to be linked to that.
    All search operations are returning the same error.

    You can try uploading the files from a new upgrade zip archive again, to rule out any file issues.
    Then try running a master rebuild from the /install path to ensure the master templates are OK.

    Other than that though, I don't see how it can be anything other than a server issue.
    You mention a table repair.
    Which tables specifically were repaired?
    Are you sure there is no database corruption?

    Try disabling all add-ons aswell, to rule out any third party factors.
  6. SeaDog

    SeaDog Active Member

    I don't believe we have any add-ons. In terms of the MySQL repair, it was just the standard one we did with phpMyAdmin to see if the site would come back up - it did apart from search.

    To be it would seem a MySQL issue rather than a file issue - the server outage wouldn't have had the ability edit or modify files as they're never written to?

    Is there a way to rebuild the search index, that would seem the most logical starting place?
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, in the ACP -> Tools -> Rebuild Caches

Share This Page