The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
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 |
#2
|
|||
|
|||
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.
|
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
If you click on the link for your database, there's a "type" column. I think it will either say "MyISAM" or "Memory".
|
#5
|
||||
|
||||
Ok got it..
seems it worked! --------------- Added [DATE]1330295310[/DATE] at [TIME]1330295310[/TIME] --------------- It was MEMORY |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|