Table Repair

Barry441 · 8-14-09, 02: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.

Quote:

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, 02: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, 02:40 PM

Got it. Followed the steps on the site below and I'm back in business.

http://php.about.com/od/mysqladminis...pair_mysql.htm

Doc C · 8-14-09, 02:47 PM

Glad to see you resolved your own problem and posted the fix.

8-14-09, 02:35 PM	#2
Barry441 Join Date: Mar 2002 Location: Colrain, Massachusetts Posts: 152 Reputation: 36	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. __________________ There is always something new to learn!

8-14-09, 02:40 PM	#3
Barry441 Join Date: Mar 2002 Location: Colrain, Massachusetts Posts: 152 Reputation: 36	Got it. Followed the steps on the site below and I'm back in business. http://php.about.com/od/mysqladminis...pair_mysql.htm __________________ There is always something new to learn!

8-14-09, 02:47 PM	#4
Doc C Just another mook Join Date: Mar 2006 Location: Southern CA Posts: 5,100 Reputation: 310	Glad to see you resolved your own problem and posted the fix. __________________ "You don't really understand human nature unless you know why a child on a merry-go-round will wave at his parents every time around -- and why his parents will always wave back." -William D. Tammeus