The Arcive of Official vBulletin Modifications Site.

Fredatitulip · #1 03-02-2017, 08:10 PM

Hi everyone,

We current use vBulletin 4.2.2 (Patch level 4) for our forums at iTulip, and is considering to upgrade to VB 5.

However, sadly to report that after our hosting company Media Temple's MySQL upgrade, we are having database error ->
"Warning: mysqli_query(): (42S02/1146): Table '.vb_session' doesn't exist in ..../includes/class_core.php on line 1393"

Somehow vb_session table has mysteriously disappeared from our database about a week ago. We are unable to run VB at our site without vb_session table.

I suspect vb_session table (and there might be more set of tables?) was corrupted, or some aspect of vb 4.2.2 is not compatible with the upgrade version of MySQL that is running on our hosting server.

And worse, Media Temple does not have database backup for us that go back to a week ago! And that means we cannot restore the content of our forum and run VB at all!!

So, I'm writing and desperately need all the expertise and help I can get at this forum to help advise -

1. What can we do to recreate vb_session table, as well as to restore our database back to the point before vb_session table was corrupted?

2. Can upgrade to VB 5 solve the problem and 'restore' our database back to the point before vb_session table was corrupted?

A fyi, our vb 4.2.2. was using PHP 5.3.29 before Media Templeb MySQL upgrade and using PHP 5.6.21 after upgrade.

Can anyone help?

Dave · #2 03-02-2017, 08:55 PM

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.

Paul M · #3 03-02-2017, 09:36 PM

Quote:

We current use vBulletin 4.2.2 (Patch level 4) for our forums at iTulip, and is considering to upgrade to VB 5.

Might I ask why ?

Fredatitulip · #4 03-02-2017, 10:13 PM

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.

Quote:

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.

Lynne · #5 03-03-2017, 02:14 AM

For your vb_cpsession table:

PHP Code:


			
CREATE TABLE vb_cpsession (
userid INT UNSIGNED NOT NULL DEFAULT '0',
hash VARCHAR(32) NOT NULL DEFAULT '',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (userid, hash)
)    ENGINE = MEMORY

Fredatitulip · #6 03-03-2017, 10:46 AM

Thank you so much Lynne! - able to access Admin CP now.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04205 seconds Memory Usage 2,251KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (3)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (2)post_thanks_box_bit (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (2)post_thanks_postbit (6)post_thanks_postbit_info (6)postbit (6)postbit_onlinestatus (6)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
MarkFL

Благодарность от:
MarkFL

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!