Page 1 of 1

Phpbb_posts is marked as crashed and should be repaired.

Posted: Wed Jan 28, 2009 3:11 pm
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?

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

Posted: Wed Jan 28, 2009 3:14 pm
by Erik Frèrejean
Run the following query direct on your database through phpMyAdmin:

Code: Select all

REPAIR phpbb_posts

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

Posted: Wed Jan 28, 2009 3:17 pm
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"

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

Posted: Wed Jan 28, 2009 3:18 pm
by JimA
Yes, you need to run this query, that would fix it.

Code: Select all

REPAIR TABLE phpbb_posts;

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

Posted: Wed Jan 28, 2009 3:18 pm
by Erik Frèrejean
My mistake

Code: Select all

REPAIR TABLE phpbb_posts

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

Posted: Wed Jan 28, 2009 3:20 pm
by Lawofthesnake
Thanks it worked :D

Do you know what could of caused this though?

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

Posted: Wed Jan 28, 2009 3:27 pm
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.

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

Posted: Sun Sep 19, 2010 3:05 pm
by lovelysummer
Bookmark this topic cause it solve my problem too.
Tks a lot.

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

Posted: Mon Jul 16, 2012 3:19 am
by alin0s
this needs a STICKY