Print Page | Close Window

Errors during upgrade

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=29476
Printed Date: 01 April 2026 at 7:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Errors during upgrade
Posted By: RadioActiveLamb
Subject: Errors during upgrade
Date Posted: 30 June 2011 at 4:52am
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:

Quote 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:
Quote 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.


Replies:
Posted By: WebWiz-Bruce
Date Posted: 30 June 2011 at 9:39am
The upgrade process is not able to upgrade your database the error is:-

Cannot find the object "table-name" because it does not exist or you do not have permissions.

This is the same for all the tables that the upgrade tries to update. This suggests that the problem is that you either connecting to the wrong database on the SQL Server or the user that you are connecting to the database with does not have permission to update the database.

Make sure that you are connecting to the correct database and that the user you are connecting to the database with has DBO (database owner) rights on that 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


Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net