icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.

» Surpass Web Hosting Forums » Discussions » PHP, MySQL » MySQL table error

PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >>

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
Old May 21st, 2008, 5:18 PM   #1 (permalink)
Registered User
Seasoned Poster
 
Joined in Dec 2007
70 posts
Gave thanks: 1
Thanked 3 times
MySQL table error

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:
ABCDHost is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old May 21st, 2008, 5:58 PM   #2 (permalink)
URB4N 5K1LLZ
Super #1
 
Roxy's Avatar
 
Joined in Sep 2005
Lives in Orlando, FL
Hosted on SH63
2,653 posts
Gave thanks: 81
Thanked 128 times
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!
Roxy is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old May 21st, 2008, 6:19 PM   #3 (permalink)
Registered User
Seasoned Poster
 
Joined in Dec 2007
70 posts
Gave thanks: 1
Thanked 3 times
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:
ABCDHost is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On