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?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03126 seconds Memory Usage 2,188KB 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)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)showthread_list (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_threadedmode.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_threaded showthread_threaded_construct_link 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 tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

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