Phpbb_posts is marked as crashed and should be repaired.

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Lawofthesnake
Registered User
Posts: 250
Joined: Thu Jun 08, 2006 8:51 pm

Phpbb_posts is marked as crashed and should be repaired.

Post by Lawofthesnake »

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT p.post_id FROM phpbb_posts p WHERE p.topic_id = 3815 ORDER BY p.post_time ASC LIMIT 30

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: 931
CALL: dbal->sql_query_limit()
I have no option to fix this in the ACP, what should i do?

User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by Erik Frèrejean »

Run the following query direct on your database through phpMyAdmin:

Code: Select all

REPAIR phpbb_posts
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)

User avatar
Lawofthesnake
Registered User
Posts: 250
Joined: Thu Jun 08, 2006 8:51 pm

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by Lawofthesnake »

Ah another error:

Code: Select all

Error
SQL query:

REPAIR phpbb_posts

MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpbb_posts' at line 1
also when i go to php myadmin it says that phpbb_posts is 'in_use"

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7748
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by JimA »

Yes, you need to run this query, that would fix it.

Code: Select all

REPAIR TABLE phpbb_posts;
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by Erik Frèrejean »

My mistake

Code: Select all

REPAIR TABLE phpbb_posts
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)

User avatar
Lawofthesnake
Registered User
Posts: 250
Joined: Thu Jun 08, 2006 8:51 pm

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by Lawofthesnake »

Thanks it worked :D

Do you know what could of caused this though?

User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by Erik Frèrejean »

It isn't possible to say what it caused, can be an interrupt, a restart of the SQL server while writing, corrupted data, etc.
But it is something to watch if it happens often you should contact your host as than they most likely have a problem with their MySQL server.
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)

lovelysummer
Registered User
Posts: 437
Joined: Fri Mar 20, 2009 1:49 pm

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by lovelysummer »

Bookmark this topic cause it solve my problem too.
Tks a lot.

User avatar
alin0s
Registered User
Posts: 61
Joined: Tue Jan 22, 2008 7:44 pm
Location: Illinois, USA
Contact:

Re: Phpbb_posts is marked as crashed and should be repaired.

Post by alin0s »

this needs a STICKY

Locked

Return to “[3.0.x] Support Forum”