Microsoft KB Archive/252701

= "Your Basket Is Empty" Error Message Occurs after Adding Items to Basket =

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:

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 _basket table, where  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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.