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

 

[duppy]

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

wait_timeout = 28800
max_allowed_packet = 8M

Thanks, I'll change mine to match. However, I do not have that option "wait_timeout" in my my.ini file.

 

[XenForo]

wait_timeout

You can add this to your shared hosting if you have a problem again

 

[duppy]

You can add this to your shared hosting if you have a problem again

Thanks, I added it locally and all seems well.

Thank you once again.

 

[En1gma]

My setup is still local on Widows 10 with WAMP.

A tip from an old timer...
Get yourself a cheap Unlimited Master Reseller Hosting Account, obviously you don't need to sell any accounts just keep for private use..
Then you can host your live site and a backup/test site to test addons or scripts out before adding them to your live site.
Feel free to PM me if you want the name of a decent Host, who I use...
Regards.

 

[duppy]

@En1gma - I sent you a PM.