upgrading from 373 to 384

[ampersand]

I get this error when making a new topic

Database error in vBulletin 3.7.3:

Invalid SQL:

            SELECT prefix.*, prefixpermission.usergroupid AS restriction
            FROM vb3_forumprefixset AS forumprefixset
            INNER JOIN vb3_prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
            INNER JOIN vb3_prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
            LEFT JOIN vb3_prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
            WHERE forumprefixset.forumid = 34
            ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error   : Table 'database_name.vb3_prefixpermission' doesn't exist
Error Number  : 1146
Request Date  : Friday, January 15th 2010 @ 04:54:20 PM
Error Date    : Friday, January 15th 2010 @ 04:54:20 PM
Script        : http://xxxxxxxx.com/newthread.php?do=newthread&f=34
Referrer      : http://xxxxxxxx.com/forumdisplay.php?f=34
IP Address    : xxx.xxx.xxx.xxx
Username      : username
Classname     : vB_Database
MySQL Version : 5.0.85-community-log

[Trevor Hannant]

This was after you'd upgraded? How exactly did you upgrade as that error's from 3.7.3 (see top line).

[ampersand]

i uploaded the files then run the upgrade script

[Trevor Hannant]

Something's gone wrong during the upgrade then as that table hasn't been added.

Can you:

- download a new copy of the vBulletin package from the members area
- delete all vB files from your server
- upload the new copy of the files
- rename config.php.new to config.php and edit it to point to your database
- run install/upgrade.php again