Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 26 Feb 2012, 20:48
mdreamer's Avatar
mdreamer mdreamer is offline
 
Join Date: Aug 2008
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
Reply With Quote
  #2  
Old 26 Feb 2012, 20:57
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.
Reply With Quote
  #3  
Old 26 Feb 2012, 21:12
mdreamer's Avatar
mdreamer mdreamer is offline
 
Join Date: Aug 2008
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
Reply With Quote
  #4  
Old 26 Feb 2012, 21:16
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
If you click on the link for your database, there's a "type" column. I think it will either say "MyISAM" or "Memory".
Reply With Quote
  #5  
Old 26 Feb 2012, 21:22
mdreamer's Avatar
mdreamer mdreamer is offline
 
Join Date: Aug 2008
Ok got it..
seems it worked!

--------------- Added 26 Feb 2012 at 21:28 ---------------

It was MEMORY
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:54.

Layout Options | Width: Wide Color: