URGENT: SQL Error after backup restore

[Arkidas]

I just deleted my database to restore a backup. After restoring the backup I receive this error when trying to access the site. Note that all vBulletin PHP files are 3.7 files since I was planning on upgrading to 3.7. I'm quite sure that's not the problem though but you tell me.

Database error in vBulletin 3.6.8:

Invalid SQL:

                               SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid

                               FROM forum AS forum;

MySQL Error   : Unknown column 'lastprefixid' in 'field list'
Error Number  : 1054

[Dismounted]

Originally Posted by Arkidas

Note that all vBulletin PHP files are 3.7 files since I was planning on upgrading to 3.7.

That's probably your problem, run the upgrade script.

[Arkidas]

Ok, I started upgrading and am now at the original problem. In the 3rd step of the whole upgrade procedure ( Step 3) Misc Table Alterations, I think it's upgrading to 3.7 beta 2 ) I receive the following error:

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER  TABLE  userlist ADD friend ENUM('yes', 'no', 'pending', 'denied') NOT NULL DEFAULT 'no';

MySQL Error   : Table 'blizzard_vbulletin.userlist' doesn't exist
Error Number  : 1146
Request Date  : Friday, May 16th 2008 @ 11:51:55 AM
Error Date    : Friday, May 16th 2008 @ 11:52:06 AM
Script        : http://www.blizzard.cd/install/upgrade_370b2.php?step=3
Referrer      : http://www.blizzard.cd/install/upgrade_370b2.php?step=2
IP Address    : 213.190.120.146
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.45-community

[Marco van Herwaarden]

Did you make any changes to your config.php? Are you using table prefixes?

If not then this is a strange error, as the userlist already exists in 3.6.8.

I suggest you open a support ticket.

[Arkidas]

Is this table important? I just grabbed a fresh one form a 3.7 install and I could upgrade fine.