При перестроении миниатюр вложений на xenforo 2.2 столкнулся с такой вот ошибкой. Решение данной проблемы самое простое, идем в phpMyadmin заходим в настройки и находим значение max_allowed_packet. Я поставил максимальное значение по справке.
HTML:
XF\Db\Exception: MySQL statement prepare error [1153]: Got a packet bigger than 'max_allowed_packet' bytes in src/XF/Db/AbstractStatement.php at 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/Db/AbstractAdapter.php at line 274
XF\Db\AbstractAdapter->insertBulk() in src/XF/Search/Source/MySqlFt.php at line 107
XF\Search\Source\MySqlFt->flushBulkIndexing() in src/XF/Search/Source/MySqlFt.php at line 89
XF\Search\Source\MySqlFt->index() in src/XF/Search/Search.php at line 40
XF\Search\Search->index() in src/XF/Search/Search.php at line 59
XF\Search\Search->indexEntities() in src/XF/Search/Search.php at line 85
XF\Search\Search->indexRange() in src/XF/Job/SearchRebuild.php at line 57
XF\Job\SearchRebuild->run() in src/XF/Job/Manager.php at line 258
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 200
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 84
XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 139
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
XF\App->run() in src/XF.php at line 464
XF::runApp() in admin.php at line 13