https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 09:00:14 +0000 Mon, 24 Jul 2006 11:05:48 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20749 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111347.html#111347 Author: WebWiz-Bruce
Subject: 20749
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.]]> Mon, 24 Jul 2006 11:05:48 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111347.html#111347 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111252.html#111252 Author: adrock5150
Subject: 20749
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.]]> Fri, 21 Jul 2006 02:28:34 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111252.html#111252 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111249.html#111249 Author: adrock5150
Subject: 20749
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?
]]> Fri, 21 Jul 2006 01:02:07 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111249.html#111249 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111247.html#111247 Author: adrock5150
Subject: 20749
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.
]]> Thu, 20 Jul 2006 22:26:55 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111247.html#111247 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111244.html#111244 Author: adrock5150
Subject: 20749
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
]]> Thu, 20 Jul 2006 22:06:33 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111244.html#111244 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111241.html#111241 Author: WebWiz-Bruce
Subject: 20749
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.
]]> Thu, 20 Jul 2006 20:44:15 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111241.html#111241 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111239.html#111239 Author: adrock5150
Subject: 20749
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.

 
]]> Thu, 20 Jul 2006 19:53:25 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111239.html#111239 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111234.html#111234 Author: adrock5150
Subject: 20749
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?


]]> Thu, 20 Jul 2006 18:50:23 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111234.html#111234 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111194.html#111194 Author: WebWiz-Bruce
Subject: 20749
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]]> Thu, 20 Jul 2006 09:31:22 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111194.html#111194 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111180.html#111180 Author: adrock5150
Subject: 20749
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
and click on any topic.


      I would appreciate any help!!!

 Thanks in advance,

adam
]]> Thu, 20 Jul 2006 00:01:33 +0000 https://forums.webwiz.net/error-after-upgrading-from-7-8-access_topic20749_post111180.html#111180