Article ID: 252701
Article Last Modified on 6/24/2004
APPLIES TO
- Microsoft Site Server 3.0 Standard Edition
- Microsoft Site Server 3.0 Commerce Edition
This article was previously published under Q252701
SYMPTOMS
Each unique shopper to a Commerce site should have only one MSCSSID (for example UJ7G7DQDGLNW9H55G7K5F1B50E500439). The basket table contains the baskets for each shopper and the MSCSSID of each shopper is stored in the Shopper_id column of this table.
Each shopper should be listed only once in the basket table, in that each shopper should have only one basket assigned to their MSCSSID.
If a condition occurs where a given MSCSSID (for example UJ7G7DQDGLNW9H55G7K5F1B50E500439) has more than one basket associated with it, then each time that shopper attempts to add an item to their basket, an entirely new basket is created in the basket table, and the customer receives the following error message:
CAUSE
During the development of a Site Server 3.0 Commerce site, if the basket table is not created with a primary key on the Shopper_id column, it is possible for a given MSCSSID to be listed multiple times in the <Sitename>_basket table, where <Sitename> is the short-name used for your Commerce site.
RESOLUTION
Remove all rows in the basket table that contain duplicate shopper_id numbers and create a primary key on the Shopper_id column in the database.
Keywords: kbfix kbprb KB252701