Log in

View Full Version : cant log in


jkcerda
09-17-2009, 11:14 PM
getting DB errors



Database error in vBulletin 3.8.3:

Invalid SQL:
DELETE FROM strikes WHERE striketime < 1253229045;

MySQL Error : Can't open file: 'strikes.MYI' (errno: 145)
Error Number : 1016
Request Date : Friday, September 18th 2009 @ 12:10:45 AM
Error Date : Friday, September 18th 2009 @ 12:10:45 AM
Script : *********************/login.php?do=login
Referrer : ***********
IP Address : *******
Username : ***
Classname : vb_database
MySQL Version : 4.1.14






Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT thread.threadid
FROM thread AS thread

WHERE thread.forumid IN(1, 2, 4, 3, 18, 5, 6, 16, 19, 7, 8, 9, 20, 15, 17, 12, 13, 21, 22, 14, 10, 11)
AND thread.lastpost >= 1253199064
AND thread.visible IN (0,1,2)
AND thread.sticky IN (0,1)
AND thread.open <> 10
ORDER BY thread.lastpost DESC
LIMIT 500;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Request Date : Friday, September 18th 2009 @ 12:14:46 AM
Error Date : Friday, September 18th 2009 @ 12:14:46 AM
Script : ***************?do=getnew
Referrer : ***************5
IP Address : *****
Username : ******
Classname : vb_database
MySQL Version : 4.1.14



--------------- Added 1253233081 at 1253233081 ---------------

I have no access to admin CP:mad:

Lynne
09-18-2009, 12:54 AM
Looks like you've got at least one crashed table. Run repair/optimize on it. see this thread for help - 3 ways to repair a database (http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909)