Upgrade from 7.9 to 9.06 problems

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

Hi,

I tried to upgrade my 7.x db (MS-SQL version) to 9.06 but it returned a lot of errors.

Error Updating the Table tblForum 
Column names in each table must be unique. Column name 'Sub_ID' in table 'DBO.tblForum' is specified more than once.

Error Updating the Table tblTopic 
Could not allocate space for object 'tblTopic' in database 'forum' because the 'PRIMARY' filegroup is full.

Error Update the Table tblThread 
Column names in each table must be unique. Column name 'Hide' in table 'DBO.tblThread' is specified more than once.

Error Updating the Table tblPermissions 
Column names in each table must be unique. Column name 'View_Forum' in table 'DBO.tblPermissions' is specified more than once.

Error Dropping Contraints in Table tblPermissions 
ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.

Error Altering the Table tblAuthor 
Could not allocate space for object 'tblAuthor' in database 'forum' because the 'PRIMARY' filegroup is full.

Error Altering the Table tblConfiguration 
Column names in each table must be unique. Column name 'ID' in table 'DBO.tblConfiguration' is specified more than once.

Error Altering the Table tblDateTimeFormat 
Column names in each table must be unique. Column name 'ID' in table 'DBO.tblDateTimeFormat' is specified more than once.

Error Altering the Table tblGroup 
Column names in each table must be unique. Column name 'Image_uploads' in table 'DBO.tblGroup' is specified more than once.

Error Creating the Table tblPollVote 
There is already an object named 'tblPollVote' in the database.

Error Creating the Table tblSession 
There is already an object named 'tblSession' in the database.

Complete

Stage 3: Creating Index's on database..... 
Error Creating one or more Index's 
There is already an index on table 'tblSession' named 'Session_ID'.

This error produced with the current status of the db because with an older (two months ago) backup it worked like a charm..

(In both cases I restored the backup locally via Enterprise Manager to test the upgrade)

Any ideas??

I have already paid the fees for the license..

Thanks

Dimosthenis

Edited by dimoss - 29 December 2007 at 11:47pm