| Author |
 Topic Search  Topic Options
|
adrock5150 
Newbie
Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: error after upgrading from 7.8 access
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 ApplicationAn 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 and click on any topic. I would appreciate any help!!! Thanks in advance, adam
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by -boRg- - 20 July 2006 at 9:32am
|
|
|
|
adrock5150
Newbie
Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
adrock5150
Newbie
Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
adrock5150
Newbie
Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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
|
|
adrock5150
Newbie
Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
adrock5150
Newbie
Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
