Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Forum 7.6
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum 7.6
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
brandoni View Drop Down
Newbie
Newbie
Avatar

Joined: 06 December 2003
Location: Italy
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote brandoni Quote  Post ReplyReply Direct Link To This Post Topic: Forum 7.6
    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 ?
Back to Top
Nigelo View Drop Down
Groupie
Groupie


Joined: 11 October 2002
Location: United Kingdom
Status: Offline
Points: 67 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Nigelo Quote  Post ReplyReply Direct Link To This Post Posted: 06 December 2003 at 4:15pm
Sounds like database corruption - Try Compacting / Repairing the Database offline with MS Access and reupload

Edited by Nigelo
Hope this helps
Nigel
Back to Top
brandoni View Drop Down
Newbie
Newbie
Avatar

Joined: 06 December 2003
Location: Italy
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote brandoni Quote  Post ReplyReply Direct Link To This Post 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 !!!!
Back to Top
india View Drop Down
Senior Member
Senior Member


Joined: 21 November 2003
Status: Offline
Points: 499 		Post Options Post Options   Thanks (0) Thanks(0)   Quote india Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
brandoni View Drop Down
Newbie
Newbie
Avatar

Joined: 06 December 2003
Location: Italy
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote brandoni Quote  Post ReplyReply Direct Link To This Post 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 ?

 
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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



Edited by AnthraX
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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..
Back to Top
brandoni View Drop Down
Newbie
Newbie
Avatar

Joined: 06 December 2003
Location: Italy
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote brandoni Quote  Post ReplyReply Direct Link To This Post 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!!!

 
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.