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

[SeaDog]

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).

 

[Paul B]

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

 

[SeaDog]

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.

 

[SeaDog]

What should we do? Create a support ticket?

 

[Paul B]

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.

 

[SeaDog]

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?

 

[Paul B]

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