After last system update - the forum SEARCH feature is GARBAGE - did up I mess up? I just did the Automated system upgrade to

[Zardoz43]

XF\Db\Exception: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 162
6. XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 293
7. XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 185
8. XF\Search\Search->XF\Search\{closure}() in src/XF/Search/Search.php at line 214
9. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
10. XF\Search\Search->search() in src/XF/Repository/Search.php at line 33
11. XF\Repository\Search->runSearch() in src/XF/Pub/Controller/Search.php at line 437
12. XF\Pub\Controller\Search->runSearch() in src/XF/Pub/Controller/Search.php at line 119
13. XF\Pub\Controller\Search->actionSearch() in src/XF/Mvc/Dispatcher.php at line 352
14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
18. XF\App->run() in src/XF.php at line 524
19. XF::runApp() in index.php at line 20

​

Server error log​

Clear

MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired 16 minutes ago src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired 43 minutes ago src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired 51 minutes ago src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired 55 minutes ago src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:57 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:56 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:56 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:55 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:55 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:55 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:55 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:54 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:54 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:53 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:53 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:52 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:52 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:52 PM src/XF/Db/AbstractStatement.php:230
MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:52 PM src/XF/Db/AbstractStatement.php:230
Job XF:SearchIndex: MySQL statement prepare error [145]: Table './whitebea_new/xf_search_index' is marked as crashed and should be repaired Today at 1:51 PM src/XF/Db/AbstractStatement.php:230

Showing 20 of 184 items

Well I guess I will just work through the 184 bug items..... JUST CURIOUS did anybody else suffer a similar BUGs-AFTER-AUTO-UPGRADE? DID I MISS THE PREVIOUS AUTO UPDATE???

I WILL HAVE TO SEE IF A HAVE A BACKUP OF THE FORUM SOFTWARE BEFORE THIS LAST UPDATE, I guess....

suppose I should start with the SEARCH INDEX - see if any of the automatic PHPMYADMIN fix-tools fix 'whatever'.

(crash and burn - who has the marshmellows?

 

[webbouk]

The database table: 'xf_search_index' is marked as crashed and should be repaired

 

[Paul B]

If the table can't be repaired, empty it and rebuild the search index.

You should speak to your host concerning server instability.

Tables should never crash.

 

[Zardoz43]

Thanks very much for your comments and suggestions.

I will follow up on this.


[I had asked and given permission for the host technical support to delete some 'duplicate backup files'
which coincidentally happened about the same time this database problem did]