View Single Post
  #1  
Old 03-02-2017, 08:10 PM
Fredatitulip Fredatitulip is offline
 
Join Date: Mar 2007
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default S.O.S. Database Error: vb_session table has mysteriously disappeared!

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?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02533 seconds
  • Memory Usage 1,760KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete