Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Sep 2011, 12:59
PimvanJ PimvanJ is offline
 
Join Date: Jan 2006
Real name: Pim
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 19 Sep 2011, 14:00
GavoTrav's Avatar
GavoTrav GavoTrav is offline
 
Join Date: Jun 2011
Real name: Gav
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 19 Sep 2011, 14:55
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
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?
__________________
My mods.
Reply With Quote
  #4  
Old 19 Sep 2011, 15:48
PimvanJ PimvanJ is offline
 
Join Date: Jan 2006
Real name: Pim
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 19 Sep 2011, 17:42
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
This may help - http://www.vbulletin.org/forum/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?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 19 Sep 2011, 18:14
PimvanJ PimvanJ is offline
 
Join Date: Jan 2006
Real name: Pim
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Release - MiniHack] Make update user info update post counts DarkReaper vBulletin 2.x Full Releases 5 19 Jan 2002 06:47



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 21:40.

Layout Options | Width: Wide Color: