Upgrade from 7.9 to 9.06 problems
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25076
Printed Date: 03 April 2026 at 12:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrade from 7.9 to 9.06 problems
Posted By: dimoss
Subject: Upgrade from 7.9 to 9.06 problems
Date Posted: 29 December 2007 at 11:16pm
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
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 30 December 2007 at 3:38pm
The errors suggest that the upgrade tool has already been run on this database as they say that the new fields, tables, and indexs have already been created in this database.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: dimoss
Date Posted: 30 December 2007 at 4:11pm
Posted By: DoctorB
Date Posted: 29 December 2008 at 2:28pm
|