customer broke their cart -- how do we fix it?

[jgold723]

ZC 1.3.9h

A customer tells us when she tries to checkout, she gets a blank page after entering her username and password.

We confirm this, by logging in as her (successful) then trying to "view cart" -- we get a blank page.

The customer tells us this happened after she placed 10,000 items of a particular product in her cart (why, I don't know, don't ask).

The "view cart" function works for fine for others, so I'm guessing there's something about her cart (maybe the 10,000 items) that is causing the problem. At least I know if I went to Walmart and put 10,000 bottles of detergent in the cart, it would probably break too.

All kidding aside, could this be the problem and if so, how would be go about fixing it?

Thanks,

John

[jgold723]

Just a quick update -- If I tunnel into the actual database and look at customer_baskets I can indeed see the customer's basket with 50,000 items in it. Can I just delete that basket via phpMyAdmin? I know this isn't always a safe thing to do, so I'm asking before I do something even stupider than putting 50,000 items in the basket.

[DrByte]

A customer tells us when she tries to checkout, she gets a blank page after entering her username and password.

We confirm this, by logging in as her (successful) then trying to "view cart" -- we get a blank page.

http://www.zen-cart.com/content.php?124-blank-page

[Ajeh]

You should delete both customers_basket and customers_basket_attributes for the customers_id to keep them clean ...

If you want to do just one product be sure to delete the correlating records in both tables ...

[jgold723]

Thanks for that link. When I check the DEBUG files, I see several files that all have the same error:

[24-Apr-2014 09:26:48 America/Los_Angeles] PHP Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 44 bytes) in /nfs/c06/h04/mnt/92537/domains/quinceandco.com/html/store/includes/modules/order_total/ot_combination_discounts.php on line 213

I haven't made any changes to the file referenced and this problem only seems to be affecting the customer who dumped all the items in her cart, so I'm guessing it has something to do with her account. Or is there something else I should be looking at?

[jgold723]

Thanks Ajeh.

Would it be safer to just reduce the number of products in the basket to 1 (in phpMyAdmin) and then remove the items via the ZC cart?

[Ajeh]

If you are messing with the customers basket in phpMyAdmin, it is best to just clean out both tables for the customer ...

NOTE: It would be best if that customer is not logged in while you are doing this ...

[DrByte]

Thanks for that link. When I check the DEBUG files, I see several files that all have the same error:

[24-Apr-2014 09:26:48 America/Los_Angeles] PHP Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 44 bytes) in /nfs/c06/h04/mnt/92537/domains/quinceandco.com/html/store/includes/modules/order_total/ot_combination_discounts.php on line 213

That looks like your ot_combination_discounts module has an error in its logic for doing database queries (probably missing a $db->moveNext() call), and is engaging an endless loop ... which could explain having thousands of products added to the cart in one click.

[jgold723]

Thanks for the help Ajeh and Dr. Byte. I was able to delete the offending basket items (in both customer_baskets and customer_baskets_attributes) and the customer's cart returned.

Dr. Byte -- I'll pass along your observation about the combination discounts module to the developer so he can fix.

Greatly appreciate the help.

[swguy]

That looks like your ot_combination_discounts module has an error in its logic for doing database queries (probably missing a $db->moveNext() call), and is engaging an endless loop ... which could explain having thousands of products added to the cart in one click.

No, the issue was just that their server memory was not adequate to handle 10,000 items in the cart at one time, which the user added themselves.