Database error

[thewolf]

Hey all I tried to upgrade 3.6.8 to 3.7.0 b4 but it didn't work out very good but I backed up everything before I did this and reinstalled all back the way it was now I am getting a database error

Database error in vBulletin 3.6.8:

Invalid SQL:

DELETE FROM visitormessage_hash
WHERE dateline < 1202275958;

MySQL Error : Table 'twpf.visitormessage_hash' doesn't exist
Error Number : 1146
Date : Tuesday, February 5th 2008 @ 09:37:38 PM
Script : cron.php?&rand=106262
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database

does anybody know what mod it would it be or how to fix it??

 

[Controller]

actually... youŕe supposed to upgrade version per version.

vB 3.8 PH2 --> 3.7 B1 --> 3.7 B2 --> 3.7 B3 --> 3.7 B4

PH2 to B2 can work, but B4 too much changes. Youŕe gonna have to reinstall a vB B4 or go back to vB 3.6.8 PH 2

 

[thewolf]

thats what it did but was having errors. But I backed up the whole board and database before I upgrade and then I put everything back how it was.

 

[JD45]

You can try going in to SQL and creating a table named: visitormessage_hash

I don't know how many fields its supposed to have though. I'd try one for now and see how that works.

 

[LaaTINO]

Delete your current database, create a new one and upload ur backed database there. Once this done run the upgrade.php file.

Good Luck !