ABCDHost

One of my domains on Pass14 is running phpBB2 and is getting a MySQL table error:
"SQL Error : 145 Table './xxxxx/phpbb_search_wordlist' is marked as crashed and should be repaired"

phpMyAdmin is showing the table phpbb_search_wordlist "in use" in the database structure view, and when you try to view the table, phpMyAdmin gives this error:

Error
SQL query:
SHOW INDEX FROM `phpbb_search_wordlist` ;
MySQL said:
#145 - Table './xxxxx/phpbb_search_wordlist' is marked as crashed and should be repaired

Trying to Repair DB from cPanel's MySQL Databases page does not fix this problem.

Does anyone here know how to repair a MySQL table with this error from within cPanel or phpMyAdmin ???? (I submitted a support ticket asking them to repair the DB table, but would like to know how to fix this myself.)

__________________
Pass14: | Saprus:

Roxy

In PHPMyAdmin click on the DB name on the left hand menu. The next page that shows will be the list of all the tables in that database. Select the one that is having problems and scroll to the bottom of the page. There is a drop down menu, click on it and select where it says Repair DB, then press the GO button in the bottom right hand corner. Hopefully this should work.

__________________
Roxanne


Urban Roxy -Personal Blog
SH63 - the best darn shared server!

ABCDHost

The 'phpbb_search_wordlist' table was repaired and the MySQL and phpBB errors went away. That's the good news. Unfortunately, searching for keywords in phpBB now doesn't work - it always returns "No topics or posts met your search criteria."

__________________
Pass14: | Saprus: