error after upgrading from 7.8 access
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=20749
Printed Date: 09 April 2026 at 8:57am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: error after upgrading from 7.8 access
Posted By: adrock5150
Subject: error after upgrading from 7.8 access
Date Posted: 20 July 2006 at 12:01am
Hello,
I am getting the following error message when I click on any topic.
Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.
Support Error Code:- err_Access_get_topics_data
File Name:- forum_topics.asp
Error details:-
Microsoft JET Database Engine
No value given for one or more required parameters.
go to http://hookahforum.com/forum8/default.asp - http://hookahforum.com/forum8/default.asp
and click on any topic.
I would appreciate any help!!!
Thanks in advance,
adam
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 July 2006 at 9:31am
Looks like your Access database has become corrupted.
You need to download the Access database, open it in MS Access, and choose, 'compact and repair database' from the tools menu, the reupload to the server.
However, with the amount of posts and users you have you should not be using Access as Access is a flat desktop file and not up to the job of handling forums over 2,000 posts and 1 active user. This warning is on the download page.
You need to be using the mySQL or SQL Server versions, as these are real database systems and can handle many 1000's of active users.
-------------
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: adrock5150
Date Posted: 20 July 2006 at 6:50pm
Borg,
thanks for your reply. I am upgrading from 7.8 to 8.x so I can then move from access to sql.
Would the compact and repair function in wwf accomplish the same thing?
|
Posted By: adrock5150
Date Posted: 20 July 2006 at 7:53pm
I downloaded the database and compact/repaired it in access 2003 and reuploaded it. I am getting the same error.
|
Posted By: WebWiz-Bruce
Date Posted: 20 July 2006 at 8:44pm
Have you upgraded your 7.x database to an 8.x database?
If not this is why you get the error.
Version 8 uses a new database schema that is not compatible with version 7.x
You need to use the database upgrade tool to upgrade your database to a version 8 database, but watch out as you can not use a version 8 database on an older version 7.x forum or you will mess up the data stored in the 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: adrock5150
Date Posted: 20 July 2006 at 10:06pm
I thought I used the upgrade tool, which converts everything. The rest of the forum seems to work.
Is there a way to see if my database has been converted?
http://hookahforum.com/forum8/default.asp
|
Posted By: adrock5150
Date Posted: 20 July 2006 at 10:26pm
I just checked, I used the upgrade tool from the forum download page.
I also noticed that I can view posts by clicking on the rss link.
|
Posted By: adrock5150
Date Posted: 21 July 2006 at 1:02am
I just tried upgrading my 7.8 database againg to check where the process errors. I am getting the following error
Stage 2: Creating New Database Tables and Fields.....
Error Updating the Table tblTopic
Field 'Hide' already exists in table 'tblTopic'.
Error Update the Table tblThread
Field 'Hide' already exists in table 'tblThread'.
Does anybody know what this means?
|
Posted By: adrock5150
Date Posted: 21 July 2006 at 2:28am
|
I fixed the problem. I had to delete the hide field in the topic and thread table before using upgrade tool.
|
Posted By: WebWiz-Bruce
Date Posted: 24 July 2006 at 11:05am
It sounds like you may have been using a modified database, if so you need to remove any modifications from your 7.x database before using the upgrade tool.
-------------
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
|
|