| Author |
 Topic Search  Topic Options
|
dsonson23 
Newbie
Joined: 04 June 2005
Location: United States
Status: Offline
Points: 13
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Cannot find query tblSetupOptions after upgrading
Posted: 26 September 2011 at 3:24pm |
I am using this old version http://forumssolution.com/ - http://forumssolution.comI 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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
dsonson23
Newbie
Joined: 04 June 2005
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
dsonson23
Newbie
Joined: 04 June 2005
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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
|
|
dsonson23
Newbie
Joined: 04 June 2005
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
dsonson23
Newbie
Joined: 04 June 2005
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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
|
|
