HELP!! Please! My 'session' table just disappeared.
 

Hi,

I need urgent help. 12 hours ago my 'session' table just disappeared. for no apparent reason, I didn't upgrade anything or change It looks like the rest of the DB is ok but i won't know for sure until everything will be online again with no DB errors.

I have a back up of 2 weeks ago that I really don't want to use.. it means to lose a lot of info.

Here is the error:

Database error in vBulletin 4.1.10:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '66.249.68.99'
AND idhash = 'c827199bec48e24e5059338869b06bed'
LIMIT 1;

MySQL Error : Table 'MyDB.session' doesn't exist
Error Number : 1146
Request Date : Sunday, February 26th 2012 @ 01:01:13 PM
Error Date : Sunday, February 26th 2012 @ 01:01:13 PM
Script :
Referrer :
IP Address : 66.249.68.99
Username :
Classname : vB_Database
MySQL Version :

i
What can cause that? Is this table contains temporary data? What can I do?

Please help me

I don't know what would cause that. I think you should just be able to recreate that table since it is temporary information. The SQL to create it is in install/mysql-schema.php, the only thing is that there's a function to decide what the engine should be, so you have to figure that out. It looks like the same engine is used for cpsession, so maybe you can look at your database and see what the cpsession table is set to.

Hi,

Thank you for replying. I will do that. Where can i see the engine? I am using MyPHPAdmin. I looked at the cpsession table and I don't see ant engine definition...

Thanks :)
Maayan

If you click on the link for your database, there's a "type" column. I think it will either say "MyISAM" or "Memory".

Ok got it..
seems it worked!

--------------- Added [DATE]1330295310[/DATE] at [TIME]1330295310[/TIME] ---------------

It was MEMORY