Web Wiz Forums - problem upgrading 7.01->7.6

Print Page | Close Window

problem upgrading 7.01->7.6

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=7643
Printed Date: 06 April 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem upgrading 7.01->7.6

Posted By: psycotik
Subject: problem upgrading 7.01->7.6
Date Posted: 27 November 2003 at 4:54am

Hi,

Im in the process of updating a 7.01 forum to 7.6. As far as i can see the only database change is the activeusers "browser" field, from length 15-20.

I have a clean version of 7.6 running, pointing to the old database and i get the following error whilst trying to create a post:

Microsoft JET Database Engine error '80040e21'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

/forum/post_message.asp, line 756

I've tried a few times and cant seem to work out what is causing this error. Would anyone else have an idea?

Thanks.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 27 November 2003 at 12:26pm

Could be a corrupted database use the compact and repair feature in the admin area of the MS Access version.

-------------
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: psycotik
Date Posted: 27 November 2003 at 11:52pm

The repair compact didnt fix the problem.

I might try running it off a clean version of 7.01 see what happens

. might have to write an sql-transfer script which does an insert/select between databases.. But thats a bit of effort.

Posted By: psycotik
Date Posted: 02 December 2003 at 3:51am

I tried running a new install of 7.01. I get the same error.

Could it be that users are accessing the database whilst im downloading it? Would that cause any problems? Because normally there are 10-12 users posting regularly at any time.

Posted By: psycotik
Date Posted: 02 December 2003 at 4:20am

Solved the problem. I did an online copy of the database to another name then downloaded that isntead of the live version. Which solved the issue.

Thanks for your help.