• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

CorneliuTusnea
#1 Posted : Friday, October 6, 2006 8:50:01 AM(UTC)
CorneliuTusnea

Rank: Member

Joined: 8/17/2006(UTC)
Posts: 681

Guys,
Wishlist does not seem to work. I can add the first item to the wish list but not a second one.

The error logged is "2627 1 Violation of PRIMARY KEY constraint 'PK_bvc_WishList'. Cannot insert duplicate key in object 'dbo.bvc_WishList'."

The problem seems to be the fact that the WishList table has the primary key set only on the bvin which is the id of the user, thus makeing it impossible for a user to have more than one item in his wishlist:

[...]
CREATE TABLE [dbo].[bvc_WishList](
[bvin] [varchar](36) NOT NULL,
[ProductBvin] [varchar](36) NOT NULL,
CONSTRAINT [PK_bvc_WishList] PRIMARY KEY CLUSTERED
(
[bvin] ASC
) WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]


Please release a public fix for this problem.



Regards,

Corneliu.
http://www.bestgames.com.au
http://www.bestchess.com.au



BV Product Links, Details and Signatures: Improve your customer experience:

http://www.acorns.com.au/projects/bv/quicklink/

jetheredge
#2 Posted : Monday, October 9, 2006 8:05:41 AM(UTC)
jetheredge

Rank: Member

Joined: 3/1/2006(UTC)
Posts: 1,142

Justin Etheredge
Senior Software Engineer
BVSoftware
CorneliuTusnea
#3 Posted : Monday, October 9, 2006 8:54:41 AM(UTC)
CorneliuTusnea

Rank: Member

Joined: 8/17/2006(UTC)
Posts: 681

Nice :)
http://www.bestgames.com.au
http://www.bestchess.com.au



BV Product Links, Details and Signatures: Improve your customer experience:

http://www.acorns.com.au/projects/bv/quicklink/

Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012