PDA

View Full Version : Site down due to database error????


TradingApples
05-19-2010, 09:48 AM
Hi,

My forum just stopped working a few hours ago and I'm getting 600 emails an hour all of them vb database errors. I have no idea how to fix this or if my site is just fubar. Before my whole site went down some spammer posted over 3,000 porn posts as a guest that went into the moderation queue (FHL). When I tried to delete them all I started to get database errors saying a table was broken try to fix it. Now my whole site doesn't even load and the errors now say so and so marked as crashed and needs repair. Here is what the errors say:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 57582;

MySQL Error : Table './trading1_database/thread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, May 19th 2010 @ 05:38:18 AM
Error Date : Wednesday, May 19th 2010 @ 05:38:18 AM
Script : http://www.TradingApples.com/showthread.php?t=57582
Referrer :
IP Address : 142.166.170.103
Username : Unregistered
Classname : vB_Database
MySQL Version :

borbole
05-19-2010, 09:53 AM
Try to repair the thread table.

legacy123
05-19-2010, 09:53 AM
You should go to the database level and delete those spam posts and then repair your database this is very simple also you might want to think upgrading your server.

If you could provide more server specs that would be helpful