BV Commerce Forum
»
BV Commerce Support
»
General Support
»
68: FIXED - URGENT: WishList does not work
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. |
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC) Posts: 1,142
|
|
Justin Etheredge Senior Software Engineer BVSoftware |
|
|
|
Rank: Member
Joined: 8/17/2006(UTC) Posts: 681
|
|
|
|
|
|
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.