Log in

View Full Version : Database error


kyrenator
07-04-2009, 09:01 AM
My site since yesterday is down because of a database error!
The db error is this:
Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM post;

MySQL Error : Table './trelad_forum/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Saturday, July 4th 2009 @ 03:21:16 PM
Error Date : Saturday, July 4th 2009 @ 03:21:16 PM
Script : http://treladiko.info/
Referrer :
IP Address : 94.68.120.190
Username : kyrenator
Classname : vB_Database
MySQL Version : 5.0.81-community


What should I do? Please answer me as soon as possible!!! Thanks in advance!

puertoblack2003
07-04-2009, 09:19 AM
run the repair in mysql.

kyrenator
07-04-2009, 09:22 AM
how can i do this?

puertoblack2003
07-04-2009, 09:25 AM
how can i do this?


http://www.whoismadhur.com/2008/02/04/how-to-repair-mysql-tables/

kyrenator
07-04-2009, 09:31 AM
in phpmyadmin my database trelad_forum does not exist!!!! :S
there is only one database called information_schema!!!
why is this happening?

Paul M
07-04-2009, 01:16 PM
You can run repairs from the ACP.

Maintenance > Repair / Optimize Tables

Tick the Post table and choose the repair option. You may need to do it more than once.