Errors during upgrade

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'm trying to upgrade from v9 to v10. I've backed-up the SQL data and restored it to a new database for testing. I've unzipped the new forum into a test URL on IIS6. I assigned "modify" rights to the database folder and ran through the upgrade process. I entered the copied database, the sql user name, password and sql server. The test went fine. Clicking next, I get this:

 Your Database is being updated. Please be patient as this may take a few minutes to complete.

Stage 1: Creating New Database Tables and Fields..... 

Error Altering the Table tblGroup 
Cannot find the object "tblAuthor" because it does not exist or you do not have permissions..

Error Altering the Table tblForum 
Cannot find the object "tblForum" because it does not exist or you do not have permissions..

Error Altering the Table tblTopic 
Cannot find the object "tblTopic" because it does not exist or you do not have permissions..

Error Altering the Table tblGroup 
Cannot find the object "tblGroup" because it does not exist or you do not have permissions..

Error Altering the Table tblPMMessage 
Cannot find the object "tblPMMessage" because it does not exist or you do not have permissions..

Error Altering the Table tblBanList 
Cannot find the object "tblBanList" because it does not exist or you do not have permissions..

Error Altering the Table tblThread 
Cannot find the object "tblThread" because it does not exist or you do not have permissions..Complete

Stage 2: Entering default values for new fields..... 

Error creating default configuration
The requested properties cannot be supported..Complete

Stage 3: Migrating forum configuration settings to new format..... 

Error migrating configuration settings to new format
The requested properties cannot be supported..Complete

Stage 4: Migrate Post Count to new Point System (this may take some time to complete)..... Complete

Trying to go to the forum or admin page, I get this:

 Server Error in Forum ApplicationAn error initialising 
Global Variables from database.
Please contact the Forum 
Administrator.

Support Error Code:- 
err_SQLServer_getForumConfigurationData()_read_global_variables
File 
Name:- global_variables_inc.asp
Forum Version:- 
10

Error details:-
Microsoft OLE DB Provider for SQL 
Server
Invalid object name 'tblSetupOptions'.

The SQL server is 2008 R2, and the server is 2003 R2. This is the same server that is running my production copy of v9 successfully.

Any clues toward a successful upgrade would be appreciated.