PDA

View Full Version : Invalid SQL


alhiwarnet
04-23-2009, 01:00 PM
Hallo

Do you know how this error can be repaired

I can not also enter the control panel Forum

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '66.249.72.34'
AND idhash = 'b7a7a78a0f0ab05079e72c6a96628b62'
LIMIT 1;

MySQL Error : Table './DB17463/session' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, April 23rd 2009 @ 03:38:57 PM
Error Date : Thursday, April 23rd 2009 @ 03:38:57 PM
Script : http://www.alhiwar.net/vb/showthread.php?p=80867
Referrer :
IP Address : 66.249.72.34
Username :
Classname : vB_Database
MySQL Version :



Yours sincerely

snakes1100
04-23-2009, 01:35 PM
Run a repair thru the admincp --> maintenance --> repair/optimize and check the session table then click submit.

Lynne
04-23-2009, 02:24 PM
I'm not sure if you can repair the session table - it's a Memory/Heap table.

alhiwarnet
04-23-2009, 04:07 PM
Thank you for the help :)

But I can not even access to the control panel Forum :eek:

Lynne
04-23-2009, 04:10 PM
See this - 3 ways to repair a database (http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909)