"Your Basket Is Empty" Error Message Occurs after Adding Items to Basket (252701)
The information in this article applies to:
- Microsoft Site Server 3.0
- 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:
Your basket is empty
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.
| Modification Type: | Major | Last Reviewed: | 6/24/2004 |
|---|
| Keywords: | kbfix kbprb KB252701 |
|---|
|