Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [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

  • #2
    solved:
    http://www.vbulletin.org/forum/showt...02#post2303702

    Comment


    • #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...
      X