Crash. Any idea how to fix?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
network23
Registered User
Posts: 127
Joined: Tue Jun 11, 2002 5:26 pm

Crash. Any idea how to fix?

Post by network23 »

My site appears to be fine until you try to read an individual thread, then you get this:

Code: Select all

SQL ERROR [ mysql4 ]

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

SQL

SELECT post_id, topic_id, forum_id FROM phpbb_posts WHERE topic_id = 4293 AND post_time > 1265076123 ORDER BY post_time ASC LIMIT 1

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: 86
CALL: dbal->sql_query_limit()
What should I do? Thanks!
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5470
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: Crash. Any idea how to fix?

Post by Marc »

network23
Registered User
Posts: 127
Joined: Tue Jun 11, 2002 5:26 pm

Re: Crash. Any idea how to fix?

Post by network23 »

Well, unfortunately that didn't work.
User avatar
d1m0
Registered User
Posts: 127
Joined: Wed Nov 25, 2009 9:20 am

Re: Crash. Any idea how to fix?

Post by d1m0 »

If you have access to the mysqlcheck tool, you can run:

Code: Select all

mysqlcheck -r <your_forum_database>
This should repair your database.
SiteGround Technical Support Team Member
Check out our special phpBB hosting package
Locked

Return to “[3.0.x] Support Forum”