Log in

View Full Version : logging in Database error


mannaraja
08-03-2008, 10:45 AM
Help Me Sir
logging in:www.muthumobiles.org/forums

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT COUNT(post.dateline) AS pcount
FROM post AS post FORCE INDEX (dateline)
INNER JOIN thread AS thread USING (threadid)
WHERE post.dateline > 1217747679
AND thread.forumid IN (01,2,155,3,5,6,78,7,8,48,56,47,50,10,51,57,63,68, 11,52,58,64,69,12,53,59,65,70,13,54,60,66,71,14,55 ,61,67,72,132,133,134,135,136,137,15,16,17,19,18,1 49,144,145,146,147,148,20,21,22,23,24,91,79,80,81, 82,150,25,26,97,98,99,27,100,101,102,28,103,104,10 5,77,111,112,113,128,129,130,131,106,107,108,109,1 10,114,115,156,29,30,31,73,74,75,76,32,33,34,35,36 ,37,151,38,39,40,41,83,84,87,85,86,88,90,89,117,11 8,119,120,123,121,122,124,125,126,127,43,44,45,92) ;

MySQL Error : Table './mannaraja2/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Sunday, August 3rd 2008 @ 11:39:50 AM
Error Date : Sunday, August 3rd 2008 @ 11:39:51 AM
Script : http://muthumobiles.org/forums/
Referrer :
IP Address : 122.164.171.22
Username : MannaRaja
Classname : vB_Database
MySQL Version : 5.0.51a

Marco van Herwaarden
08-03-2008, 10:48 AM
To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

mannaraja
08-04-2008, 02:12 PM
Thank you sir...:up: