Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2011, 10:59 AM
PimvanJ PimvanJ is offline
 
Join Date: Jan 2006
Location: Netherlands
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Update to wrong DB

Hi,

I have two forums vBulletin 3.7.3 as main forum and Vb 4.1.3 for testing purpose.

Of course both forum's have different database.

Yesterday I planned a upgrade for the testing forum software from 4.1.3 to 4.1.6 but by mistake I set the wrong db in the config file. (the one for the main forum)

the upgrade for 4.1.6 didn't complete and the the main forum is now useless I get only db error's.

Is there a way to revert this?
Unfortunately there is no (recent) back-up

Every help is welcome.

Regards,
Reply With Quote
  #2  
Old 09-19-2011, 12:00 PM
GavoTrav's Avatar
GavoTrav GavoTrav is offline
 
Join Date: Jun 2011
Location: Ireland
Posts: 113
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your going to have a very hard time fixing it.

Can you get to the admincp and go to the optimization/repair then use mysql schema option at the bottom try repair the database. I recomend backing it up first incase that does worse and someone else finds a fix.

You might also want to look at backing it up atleast once a week if not once a day!
Reply With Quote
  #3  
Old 09-19-2011, 12:55 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PimvanJ View Post
Hi,

I have two forums vBulletin 3.7.3 as main forum and Vb 4.1.3 for testing purpose.

Of course both forum's have different database.

Yesterday I planned a upgrade for the testing forum software from 4.1.3 to 4.1.6 but by mistake I set the wrong db in the config file. (the one for the main forum)

the upgrade for 4.1.6 didn't complete and the the main forum is now useless I get only db error's.

Is there a way to revert this?
Unfortunately there is no (recent) back-up

Every help is welcome.

Regards,

Can you post here what db errors are you getting?
Reply With Quote
  #4  
Old 09-19-2011, 01:48 PM
PimvanJ PimvanJ is offline
 
Join Date: Jan 2006
Location: Netherlands
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I see that all errors are from the test forum only, I fix this already by upgrade to the right DB.

The main forum DB does not create anything the screen stay blank.

I cant go to the admincp after login the screen stay blank.

The VBadvanced does load but when I follow a thread I get this;

Warning: Invalid argument supplied for foreach() in [path]/includes/functions_editor.php on line 93
Warning: Invalid argument supplied for foreach() in [path]/includes/functions_editor.php on line 93

I try to fix the main forum with upgrade but that didn't work either.

Then I get this

It is not possible to upgrade directly from vBulletin 2 to vBulletin versions 3.7.x and newer due to incompatabilities in data structures.

If you are currently running vBulletin 2 and would like to upgrade to the latest version of vBulletin, please begin by downloading a version of vBulletin 3.6 from the vBulletin Members' Area.
Reply With Quote
  #5  
Old 09-19-2011, 03:42 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This may help - https://vborg.vbsupport.ru/showthread.php?t=255104

But if you don't have a backup, there really isn't much you can do. Could you just bite the bullet and upgrade to 4.x fully?
Reply With Quote
  #6  
Old 09-19-2011, 04:14 PM
PimvanJ PimvanJ is offline
 
Join Date: Jan 2006
Location: Netherlands
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The latest backup I have is from 1 September - I can live with that.
Upgrading fully to 4.16 is a lot of work and I have far to little time to rebuild the lay-out and all the hacks.

It was a good lesson for backing up every time.

Thank you all for the fast respond.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:12 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03838 seconds
  • Memory Usage 2,207KB
  • Queries Executed 13 (?)
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
  • (1)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
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (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_postinfo_query
  • fetch_postinfo
  • 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
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete