Cannot upgrade from 9.7.2 to 10.0.3
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=30197
Printed Date: 31 March 2026 at 4:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Cannot upgrade from 9.7.2 to 10.0.3
Posted By: kschmechel
Subject: Cannot upgrade from 9.7.2 to 10.0.3
Date Posted: 29 February 2012 at 2:40pm
|
I'm following the SQL upgrade instructions from http://www.webwiz.net/web-wiz-forums/kb/sql--upgrade.htm - http://www.webwiz.net/web-wiz-forums/kb/sql-server-upgrade.htm However, when I get to step 6 I receive the following error:
Server Error in Forum Application
An 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.03 Error details:- Microsoft OLE DB Provider for SQL Server Invalid object name 'tblSetupOptions'. |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 01 March 2012 at 9:03am
I think you are not following step 3 correctly:-
You need to replace ALL files except those in the 'upload' directory and if using Access the Access database, with those from the latest version. If you do not the Install/Upgrade wizard will not run to upgrade the database. I suspect that you are not following this step and retaining certain key files which is why the Upgrade/Install Wizard is not running to upgrade your 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 |
step3 wrote:Posted By: kschmechel
Date Posted: 01 March 2012 at 12:11pm
What are the "certain key files" that I need to retain? Your instructions say to delete "all the old files and images" just leaving the uploads folder and I've done that.
Can you be more specific?
|
Posted By: WebWiz-Bruce
Date Posted: 01 March 2012 at 5:50pm
|
It needs to be all the files, as the install/upgrade wizard is failing to run it means that you are trying to retain some of your old files. You need to also include uploading the new files in the 'database' folder, you can not keep your old database settings files as the install/upgrade wizard will ask you for your database connection details when upgrading your database and will write these settings to the new setting files. ------------- 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: kschmechel
Date Posted: 05 March 2012 at 11:29am
|
I have deleted every single file and folder and I still get that same SQL error when I upload the new files.
What else should I try?
|
Posted By: WebWiz-Bruce
Date Posted: 05 March 2012 at 11:44am
|
Is the install/upgrade wizard not running at all? ------------- 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: kschmechel
Date Posted: 05 March 2012 at 11:47am
| No, not at all. It doesn't get beyond the SQL error. |
Posted By: WebWiz-Bruce
Date Posted: 05 March 2012 at 11:50am
|
The only time the install/upgrade wizard will not run is if you are trying to rte-use your database settings files in the 'database' folder. These need to be replaced with unmodified files from the latest version. The install/upgrade wizard will write your database settings to these files when your forum is updated. ------------- 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: kschmechel
Date Posted: 05 March 2012 at 12:02pm
|
The upgrade worked. The key was to upload an un-modified database file to the server.
Thanks for your assistance.
|