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

Zardoz43

Member
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? :)
 
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.
 
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]
 
Top Bottom