Two questions pertaining to cart / checkout process

[0be1]

I have a two part question to the cart building / checkout process. When a cart is being built by the customer where is the data being stored in the table(s) until they checkout?

We had a customer somehow lodge an error by overriding the qty min max levels. We have a product that was setup as 3 3 and somehow she managed to get 11 in her cart instead of 9 or 12, not quite sure what qty she was trying to order.

I did find her error in the zen_sessions table (looked at the hyperlink status when my mouse the shopping cart link) and in her session I found this:

customers_host_address|s:11:"xxx.xxx.x.x";prev_request_type|s:3:"SSL";cartID|s:
0:"";cart|O:12:"shoppingcart":9:{s:9:"observers";a:0:{}s:8:"contents";a:20:
{i:4851;a:1:{s:3:"qty";s:1:"6";}i:4856;a:1:{s:3:"qty";s:2:"12";}i:4910;a:1:
{s:3:"qty";s:1:"1";}i:952;a:1:{s:3:"qty";s:1:"1";}i:4126;a:1:{s:3:"qty";s:1:"1"; }
i:3842;a:1:{s:3:"qty";s:1:"6";}i:4904;a:1:{s:3:"qty";s:1:"6";}i:3920;a:1:
{s:3:"qty";s:1:"6";}i:1123;a:1:{s:3:"qty";s:1:"1";}i:1134;a:1:
{s:3:"qty";s:1:"1";}i:5024;a:1:{s:3:"qty";s:1:"1";}i:190;a:1:
{s:3:"qty";s:1:"6";}i:192;a:1:{s:3:"qty";s:1:"6";}i:227;a:1:{s:3:"qty";s:1:"6";}
i:186;a:1:{s:3:"qty";s:1:"6";}i:199;a:1:{s:3:"qty";s:1:"6";}i:4696;a:1:
{s:3:"qty";s:2:"12";}i:3052;a:1:{s:3:"qty";s:1:"6";}i:3357;a:1:
{s:3:"qty";s:2:"26";}i:3056;a:1:{s:3:"qty";s:1:"3";}}s:5:
"total";d:341.8100000000000591171556152403354644775390625;s:6:
"weight";d:13.320000000000003836930773104541003704071044921875;
s:6:"cartID";N;s:12:"content_type";b:0;s:18:"free_shipping_item";i:0;s:20:
"free_shipping_weight";i:0;s:19:"free_shipping_price";i:0;}navigation|O:17
:"navigationhistory":3:{s:9:"observers";a:0:{}s:4:"path";a:3:{i:0;a:4:
{s:4:"page";s:6:"logoff";s:4:"mode";s:3:"SSL";s:3:"get";s:0:"";s:4:"post";a:0:
{}}i:1;a:4:{s:4:"page";s:5:"login";s:4:"mode";s:3:"SSL";s:3:"get";a:1:
{s:6:"action";s:7:"process";}s:4:"post";a:0:{}}i:2;a:4:
{s:4:"page";s:5:"index";s:4:"mode";s:3:"SSL";s:3:"get";s:0:"";s:4:"post";a:0:
{}}}s:8:"snapshot";a:0:{}}check_valid|s:4:"true";language|s:7:"english";language s_id|
s:1:"1";languages_code|s:2:"en";currency|s:3:"USD";updateExpirations|b:1
;session_counter|b:1;customers_ip_address|s:11:"xxx.xxx.x.x";customer_id|
etc.etc.etc... ;valid_to_checkout|b:0;cart_errors|s:163:"Product Name: JR. USHER BADGE - PK 3 ... Quantity Units errors - <br /> You ordered a total of: 26 <span class="alertBlack">Min:&nbsp;3 Units:&nbsp;3</span> <br />";

Any ideas on how to fix this, PLUS be able to delete her built cart since she cannot checkout or view / remove any items from her cart.

This problem is preventing this customer from doing any transactions on our site. All other customers are working fine.

tia...

0be1

[Ajeh]

The cart itself is stored in the customers_basket and customers_basket_attributes ...

Delete the records that match the customers_id in both of these tables and the cart is empty ...

[0be1]

Thank Linda :o) I can now log in as the customer. Now the fun part to see why that happened. My theory is with the customer putting in the wrong qty and with the php errors turned off we could not trap what was going on.

Thanks again...

0be1