Support Error while trying to rebuil Search Index.

[duppy]

I am getting the following error when I try to rebuild the Search index.

An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in src\XF\Db\AbstractStatement.php on line 228

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/UpgradeCheck.php at line 33
XF\Repository\UpgradeCheck->getLatestUpgradeCheck() in src/XF/Admin/App.php at line 239
XF\Admin\App->renderPageHtml() in src/XF/App.php at line 2131
XF\App->renderPage() in src/XF/Admin/App.php at line 123
XF\Admin\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
XF\App->run() in src/XF.php at line 488
XF::runApp() in admin.php at line 13

Thank you,
EDIT: It's only happening when I use the "posts" option from the dropdown menu.All the other queries seem to run ok.
Duppy

 

[En1gma]

Usually when you get this statement in the first line " MySQL server has gone away " it normally means that your host is doing their daily backups while your trying to run your script or querry...
Glad your sorted tho...

 

[duppy]

Usually when you get this statement in the first line " MySQL server has gone away " it normally means that your host is doing their daily backups while your trying to run your script or querry...
Glad your sorted tho...

My setup is still local on Widows 10 with WAMP.

 

[duppy]

UPDATE: I fixed the issue by changing the following setting in the my.ini file: max_allowed_packet=128M.

 

[XenForo]

These are usually the recommended values in shared hosts
generally indicates MySQL server connectivity issues or timeouts

wait_timeout = 28800
max_allowed_packet = 8M