S.O.S. Database Error: vb_session table has mysteriously disappeared!

[Fredatitulip]

Much obliged Dave!

Run the Query and our vb is up running at the moment. Haven't yet to investigate what else may have corrupted but it shows a warning ->
"Warning: gmmktime(): You should be using the time() function instead in ..../includes/functions_notice.php on line 284"

Any idea about this warning?

Just discovered another problem -

1. After logged in as Admin to forums webpage and clicked 'Admin' tab on the bottom of forums webpage, I got: HTP404 error at http://www.itulip.com/forums/admincp/index.php

2. Attempted to login as admin from my booked vb admin url (http://www.itulip.com/forums/advp/index.php?) - I got this:

"Warning: mysqli_query(): (42S02/1146): Table '.vb_cpsession' doesn't exist in ..../includes/class_core.php on line 1393"

Very strange, eitherway, I'm unable to access vb admin cp. What should I do?

Thanks millions for your help Dave. I'll have serious talk with Media Temple once I got our forum back and running.

Originally Posted by Dave

1. You can't restore it to a point in history without backups I'm afraid. As for the session table, if this is the only missing table then you're lucky because it only stores (non-critical) data temporarily. Execute the following query in a MySQL console, through PHPMyAdmin or ask your host to execute it against your database:

PHP Code:

CREATE TABLE vb_session (
    sessionhash CHAR(32) NOT NULL DEFAULT '',
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    host CHAR(15) NOT NULL DEFAULT '',
    idhash CHAR(32) NOT NULL DEFAULT '',
    lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
    location VARCHAR(255) NOT NULL DEFAULT '',
    useragent VARCHAR(255) NOT NULL DEFAULT '',
    styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    languageid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    loggedin SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    inforum SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    inthread INT UNSIGNED NOT NULL DEFAULT '0',
    incalendar SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    badlocation SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    bypass TINYINT NOT NULL DEFAULT '0',
    profileupdate SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    apiclientid INT UNSIGNED NOT NULL DEFAULT '0',
    apiaccesstoken VARCHAR(32) NOT NULL DEFAULT '',
    isbot TINYINT NOT NULL DEFAULT '0',
    PRIMARY KEY (sessionhash),
    KEY last_activity USING BTREE (lastactivity),
    KEY user_activity USING BTREE (userid, lastactivity),
    KEY guest_lookup (idhash, host, userid),
    KEY apiaccesstoken (apiaccesstoken)
) ENGINE = MEMORY 


It's entirely possible that more tables are missing, but just execute this first to find out if it's the only table that's missing.

2. I wouldn't do that. I would first fix it so your current vBulletin 4 forum is working and then upgrade to vBulletin 5.

---

I don't see how a MySQL upgrade could cause this though, your host did something very wrong. If this happened to me, I would move host right away.

Also just a tip: keep offline backups, on your own computer or on a different server so you will not have such issues in the future.