Orders being created with no products (500 error at checkout)

[jaimeweb]

Hi,

I have a major issue with a clients site which started out of the blue this morning.

The site generally gets around 50-80 online orders a day and has over 40k order and 40k customers.

 

Suddenly, this morning, orders have been coming through with no products attached to them. Payment is taken via PayPal and Sagepay Uk. Both options are doing the same thing.

 

I have noticed when being redirecting back from PayPal or Sagepay (as a customer) a 500 error page is shown....

 

Order is created, payment is taken. Just no items on the order (which isn't great!). The order comes through with no order status also, just "--". The cart also doesn't exist so can't see what the customer has ordered. Customers have also noted that they aren't received email confirmations.

 

No changes have been made on the site at all. No new modules, no code changes nothing. Every single online order since 9am this morning.

 

Placing a manual prestashop order is working fine via the control panel.

 

Any ideas or suggestions would be great.

The ps version is 1.5.3.

 

Please help!

 

Thanks

Jamie

[jaimeweb]

Update: when looking at the "orders" table, I can see the orders are being recorded. However, the "orders_detail" table, there is no reference to the orders at all. 

[jaimeweb]

Fixed it. 

Basically I have this module installed http://addons.prestashop.com/en/16835-froggy-history.html. Been working fine for months.

Disabled it and all working fine again.....

 

How, why....i have no idea. 

[musicmaster]

When orders don't have products it means that something has gone wrong transforming the shopping cart into an order. In that case you can find the contents of the order in a shopping cart - just look for the right amount.

[Fabien Serny]

Hi,

 

I'm one of the developer of this module.
Your error is very odd. (you said on the support request that you got the error "Property FroggyHistoryLog->id_shop is empty")

 

You should not be able to get "FroggyHistoryLog->id_shop is empty" since we retrieve "id_shop" from the context.

Do you have still shop in your table ps_shop ?

Best regards,
Fabien of Froggy Commerce