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 :
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 :