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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MDreamer
    New Member
    • Jul 2008
    • 24

    [Forum] 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
  • MDreamer
    New Member
    • Jul 2008
    • 24

    #2
    solved:

    Comment

    • Paul M
      Former Lead Developer
      vB.Com & vB.Org
      • Sep 2004
      • 9886

      #3
      Just recreate it ;

      Code:
      CREATE TABLE session (
      	sessionhash CHAR(32) NOT NULL DEFAULT '',
      	userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
      	host CHAR(15) NOT NULL DEFAULT '',
      	idhash CHAR(32) NOT NULL DEFAULT '',
      	lastactivity INT(10) UNSIGNED NOT NULL DEFAULT '0',
      	location CHAR(255) NOT NULL DEFAULT '',
      	useragent CHAR(100) NOT NULL DEFAULT '',
      	styleid SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	languageid SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	loggedin SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	inforum SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	inthread INT(10) UNSIGNED NOT NULL DEFAULT '0',
      	incalendar SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	badlocation SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	bypass TINYINT(4) NOT NULL DEFAULT '0',
      	profileupdate SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      	apiclientid INT(10) UNSIGNED NOT NULL DEFAULT '0',
      	apiaccesstoken VARCHAR(32) NOT NULL DEFAULT '',
      	isbot TINYINT(4) NOT NULL DEFAULT '0',
      	PRIMARY KEY (sessionhash),
      	INDEX last_activity (lastactivity) USING BTREE,
      	INDEX user_activity (userid, lastactivity) USING BTREE,
      	INDEX guest_lookup (idhash, host, userid),
      	INDEX apiaccesstoken (apiaccesstoken)
      )
      ENGINE=MEMORY
      ROW_FORMAT=DEFAULT
      Baby, I was born this way

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...