Cart Empties

[lynnetted]

Hi!

 

For no obvious reason the cart will suddenly not maintain orders. In other words - I order an item, do something else (look at another item or go to checkout or go to the cart etc..) and the cart empties.

 

Twice this has happened. I need to know why because I do not want it to happen when we go live.

 

The first time I thought I had made an error when importing data from another database, I re-imported the data and suddenly the problem was fixed.

 

But the second time, no import had been made. However I was able to get the shop going again by insert a new record in the PS_ORDERS table with an ID # greater than the last order placed. This was a suggestion I found for this problem back in version 1.0x, I am using 1.4.4.1. This occurs in all browsers I have used (Firefox 7.0.1, Safari 5.1.1 and Opera 11.52).

 

In my efforts to debug this problem I found that sometimes I can cause this problem if I delete the SECURE_key for the last record in the PS_CART table and then try to place an order.

 

I also found that sometimes I can fix this problem if I delete all records in PS_CART and PS_ORDERS which have blank SECURE_KEY fields.

 

But not always.

 

Can anyone explain how the cart/order process works - for example "When the user adds a product to the cart a record is created in [fill-in-the-blank]-table using [fill-in-the-blank]-data which is then...." - so that I can try and track down this problem? Or even better - I haven't found a fix, but if anyone knows what causes this problem and how to fix it, I would love to know!

 

Thanks!

Lynnette