Web Wiz Forums - Error After upgrade

Print Page | Close Window

Error After upgrade

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=3772
Printed Date: 01 April 2026 at 11:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error After upgrade

Posted By: JakePehrson
Subject: Error After upgrade
Date Posted: 23 June 2003 at 3:41pm

I recently upgraded from 6.x to 7.0. I used the conversion tool written by Nigel. Everything seem to work well. I can reply to a post, add a new forum, etc. The only problem I am having is everytime I try to post a new topic I get this error.

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.

/test/forum/post_message.asp, line 609

any ideas.

Thanks in advanced.

Replies:

Posted By: Gullanian
Date Posted: 23 June 2003 at 4:05pm

Go to line 609 and see what table its trying to update.

Posted By: WebWiz-Bruce
Date Posted: 24 June 2003 at 1:37am

You need to make sure that you compact and repair the databases in access before and after the update.

You can find this under the tools menu in access.

-------------
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: JakePehrson
Date Posted: 24 June 2003 at 9:33am

I did compact and repair the database after the update. I will try again and see if it fixes the problem.

Posted By: CT05
Date Posted: 27 June 2003 at 12:17pm

I had the same problem but was only compacting and repairing after the update, i tried it before and after and my problems are solved.