PDA

View Full Version : Table Repair


Barry441
8-14-09, 03:28 PM
Anyone here familiar with repairing a table? Just this afternoon I started having an issue with my phpBB forum. When I try to view a post I get the following error and I have no idea how to do a repair.
General Error
SQL ERROR [ mysql4 ]

Table './XXXXXXXXXXXX/phpbb_posts' is marked as crashed and should be repaired [145]

SQL

SELECT p.post_id FROM phpbb_posts p WHERE p.topic_id = 10392 ORDER BY p.post_time ASC LIMIT 20

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: viewtopic.php
LINE: 896
CALL: dbal->sql_query_limit()

Barry441
8-14-09, 03:35 PM
After doing some web searches I am getting the feeling I will have to contact support and have them do this. I don't think I have access.

Barry441
8-14-09, 03:40 PM
Got it. Followed the steps on the site below and I'm back in business.

http://php.about.com/od/mysqladministration/qt/repair_mysql.htm

Doc C
8-14-09, 03:47 PM
Glad to see you resolved your own problem and posted the fix.