Print Page | Close Window

Forum 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=7906
Printed Date: 12 April 2026 at 2:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Forum 7.6
Posted By: brandoni
Subject: Forum 7.6
Date Posted: 06 December 2003 at 2:43pm

I've upgrade from forum 6.5 to forum 7.6 . I've converted database but when I try t register a new user i receive this message:

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.

/forum7/register.asp, line 953

Why ?




Replies:
Posted By: Nigelo
Date Posted: 06 December 2003 at 4:15pm
Sounds like database corruption - Try Compacting / Repairing the Database offline with MS Access and reupload

-------------
Hope this helps
Nigel


Posted By: brandoni
Date Posted: 07 December 2003 at 2:53am

thank you for the help, but I tried to Compacting / Repairing the database but I have the same error.

I've installed on my computer Access 2003 ,  is this the problem ?

Help , I can't start the new forum !!!!



Posted By: india
Date Posted: 07 December 2003 at 4:26am

Hi,

How did u upgrade the database ?

Go to admin menu -> then Compact & Repair Db -> then try.

if id does not work, check whether ur webhost has access 2k or earlier version. it must be 2k



Posted By: brandoni
Date Posted: 07 December 2003 at 7:09am

I downloaded full forum version 7.6 from web site. Afterwards I used  "webwiz forum db migrator" to upgrade my old DB to new ( from 6.32 version to 7.6). I compacted offline (on my desktop) and online using  the admin function.

I can see all old messages and all  old users, I can modify their profiles but I can't register a new user.

there must be something wrong ! but where ?

 



Posted By: Semikolon
Date Posted: 07 December 2003 at 8:50am

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

try unset as primary key in the user table or something



Posted By: Semikolon
Date Posted: 07 December 2003 at 8:57am
no screw that.. open the user table in the database in design mode and unset the primary key. updatae the database and set the first field as primary key again..


Posted By: brandoni
Date Posted: 07 December 2003 at 10:27am

I tried to unset the primary key of table TblAuthor, but this is impossible because this key has a lot of relationships with other tables!!!

 



Posted By: DHiNSaNE
Date Posted: 07 December 2003 at 9:33pm

hi, if u are using windows 2k3 or 2k, I think I know the problem,
well, it happened to me as well, not in this forum but in my own application I built I'm well known with this error,
the error could appear when you don't have a write/read or the IUSER_ account is not have the permission to the wwwroot or to your application main folder or sub folders that needs to interact with the database file, check if you have a read/write premissions on your main also sub folders! 
second the really important thing you should do is to add the user account "Internet Guest Account" (IUSER_) to your application folder and all his sub folder,
My Computer >> go to the folder you want to add the account right click then properties >> security >> add >>
advanced >> find now >> search for the user (IUSER_) >> OK >>
OK >> select the user (IUSER_) and allow him the permissions of:
Modify, Read & Execute, List Folder Contents, Read Write
deny the permission of Full control >> Advanced >>
check the box that says "Replace permission entries on all child objects with entries shown here that apply to child objects" >>
OK >> OK >> that's it!  it should work!
(My recommendation is to do it once on your IIS website directory default site direcotry for the IIS is wwwroot so u won't have a problem with other sites in the future).



Posted By: brandoni
Date Posted: 08 December 2003 at 2:57am

If I use original db all is ok, when I upload the DB converted from 6.5 version I have this problem just during registration, otherwise when I modify the user profile all is ok.

is there counter that I must upgrade ?



Posted By: MOWS
Date Posted: 05 January 2005 at 12:51am

Just for the record I've got what appears to be the same issue.

Upgraded the database using the migration tool and get the same Jet error.
 
Looking forward to the final solution


Posted By: WebWiz-Bruce
Date Posted: 05 January 2005 at 4:40am
The error sounds like that for some reason the database is trying to insert a value that already exists in one of the tables (probably tblAuther)

Make sure that the ID primary key field for all tables, but especially tblAuther, is set to auto-number and that the value that the database is trying to insert increments the previous number.


-------------
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: MOWS
Date Posted: 05 January 2005 at 10:45pm

Hey thinked I've worked this one out.

The error message referenced line 756 in post_messgage.asp
 
This indicated the issue was with the table tblThread
 
I manually attempted to insert a record into tblThread via Access and got a similar error. On inspection I found that the p-key index for the table was stuff.
 
I fixed the key by changing from incremental to random, saving the table then changing back to incremental.
 


Posted By: WebWiz-Bruce
Date Posted: 06 January 2005 at 4:31am
Sounds like your database may have become corrupted then.

Compacting and repairing the database may have also solved the problem, but glad you managed to resolve it.


-------------
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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net