Web Wiz Forums - Cannot find query tblSetupOptions after upgrading

Print Page | Close Window

Cannot find query tblSetupOptions after upgrading

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

Topic: Cannot find query tblSetupOptions after upgrading

Posted By: dsonson23
Subject: Cannot find query tblSetupOptions after upgrading
Date Posted: 26 September 2011 at 3:24pm

I am using this old version http://forumssolution.com/ - http://forumssolution.com

I would like to update to version 10.3, after the upgrade, it showed me everything was successfully done.

It gave me a default administrator account, but when I went to the home page http://forumssolution.comew/default.asp - http://forumssolution.com/new/default.asp, I received this error message below

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

Support Error Code:- err_Access_getForumConfigurationData()_read_global_variables
File Name:- global_variables_inc.asp
Forum Version:- 10.03

Error details:-
Microsoft JET Database Engine
The Microsoft Jet database engine cannot find the input table or query 'tblSetupOptions'. Make sure it exists and that its name is spelled correctly.

Can you help me please fix that problem?

By: WebWiz-Bruce

The forum is trying to connect to an access database that does not have the table required for version 10.

Make sure you have upgraded the correct database.

Should I create the table required for version 10 manually?

If yes, can you send me the instruction?

Thanks

Peter

Replies:

Posted By: WebWiz-Bruce
Date Posted: 26 September 2011 at 3:31pm

We do not support Access in a production environment as it is a desktop database and often becomes corrupted easily.

If you are sure you are connecting to the correct database and you are getting this error after upgrading it means the upgrade has not worked correctly, most probably due to a corrupted database.

You could try going back to the backup you made of your Access database before you upgraded it and trying to compact and repair the database in Microsoft Access before trying the upgrade again. If it still doesn't work then it maybe a case that your access database can not be fixed.

-------------
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: dsonson23
Date Posted: 26 September 2011 at 3:39pm

My old access database is working fine because my old version is still running with no problem http://forumssolution.com

Any other suggestion?

Thanks for your quick answer.

Posted By: WebWiz-Bruce
Date Posted: 26 September 2011 at 4:28pm

It may appear top be running fine but the underlying data may have an issue that only comes to light when making changes to the database schema like when upgrading the database.

I have just had a quick look at your forum and see that you have over 200,000 posts running on Access!! I am surprised that the forum is still running as you are way beyond what Access can cope with and I seriously doubt an access database of this size would cope with the demands placed on it to upgrade it to version 10.

I would say you only option would be to upsize the Access database to SQL Server and then upgrade the the database.

Posted By: dsonson23
Date Posted: 26 September 2011 at 5:01pm

Ok, I am going to upgrade to SQL server, I will let you know how it goes.

Thanks

Posted By: dsonson23
Date Posted: 27 September 2011 at 7:03am

After successfully migrate my access database to mysql and I successfully upgrade to version 10.3, when I go to access my forum, I receive this error message

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

Support Error Code:- err_mySQL_getForumConfigurationData()_read_global_variables
File Name:- global_variables_inc.asp
Forum Version:- 10.03

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-5.1.56-community]Table 'forumssolution.tblsetupoptions' doesn't exist

How can I fix this?

Posted By: WebWiz-Bruce
Date Posted: 27 September 2011 at 10:18am

A forum of your size needs SQL Server, not Access or mySQL.

You may also wish to look at one of our hosted solutions where we can do all this work for you as we do offer a Web Wiz Forums migration service with our hosted solutions for £19.95 which includes the following:-

Moving your forum to our servers
Upgrading to the latest Premium Edition
If an Access database moving it to SQL Server
Checking the database for errors
Configuring your forum to work with our server/network

Our http://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting Packages also include the Premium Edition and free upgrades to the latest version.

Posted By: dsonson23
Date Posted: 28 September 2011 at 6:51am

Come on guys, just help me make this thing works instead to offer me to move to your server, why should I move to your server while I have my own dedicated server?

After adding the missing the table, here is what I got

Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the Forum Administrator.

Support Error Code:- err_mySQL_UnreadPosts()
File Name:- functions_common.asp
Forum Version:- 10.03

Posted By: dsonson23
Date Posted: 28 September 2011 at 2:31pm

Do you mean if I don't get the hosting from you? no help for me here, if that the case, sorry for wasting your time cause I am not going to get hosting anywhere.

Thank very much.

Posted By: WebWiz-Bruce
Date Posted: 28 September 2011 at 3:43pm

If you could listen to the advice given then there is no need to move your forums hosting to our network.

The problem is that I have given you advice, like the need of using SQL Server for the size of forum you have, and you then ignore this advice and use mySQL, which will certainly give errors.

The mySQL version of Web Wiz Forums uses a different schema so moving from Access to mySQL is not a simple procedure as the database needs to be modified to greatly modified to work after the migration, something which takes our engineers best part of a day to do, and we know the database inside out.

Even if you do get the database to work quite often we see mySQL getting corrupted when the database gets over 300MB in size.

These are some of the reasons for saying to use SQL Server, which is advice you choose to ignore.

You should go back to the Access database and try upsizing to SQL Server. This will hopefully work although from lots of experience from doing this it can take anything from 30 minutes to 8 hours to get a good working upsized web wiz forums database, but is the simplest option.

I can not see the issue that you have that if you have a dedicated server you can not use the services of anyone else. We host forums for companies like Microsoft here on our network and they have their own data centres throughout the world. This does not stop them from using us as it takes the hard work of installing, upgrading, managing, securing, etc. away from yourself, thus saving you time and hassle.