Orders get filled incompletely on database, any ideas ?

[aalamaki]

Hi All,

We have been facing a strange issue on our site (zencart 1.3.8), it seems that when a customer makes an order, the order itself with the order total price gets added to the database but the products themselves never appear in the order itself.

It appears that the products belonging to the specific order never appear on the orders_products table in the database, only data that comes in the database is in the orders and orders_total databases, nothing else. Also, emails regarding the order do not get sent to the customer so apparently the code dies somewhere in between, strangely enough no errors whatsoever in server logs or on screen though.

Could anyone point me into where the webshop actually does the adding of the order into the database? Could not find it with the developer toolkit, some of the order handling apparently is done in /includes/classes/order.php but this is not where the actual order is inserted into the database.

Any help would be appreciated

Best regards, Antti Alamäki

[DrByte]

While /includes/modules/checkout_process.php does some of the driving of the process, /includes/classes/order.php handles actual insertion of order data into the database.

What addons/contributions have you installed?
What customizations have you made that makes your store different from a brand new uncustomized install?

[aalamaki]

Hi

Well, the only mod we have on that installation is that "group discount per item". It now appears that products which were marked as "free" get correctly added into the order. This leads me to believe that the problem might be the PayPal IPN module which we use for the online payments.

We also tested with a completely clean installation of the zen 1.3.8 and same issue on that, this happens at least when running the shop in the paypal sandbox mode. We have tried to check all the settings on the paypal account and they all appear correct. Any ideas are welcome :)

/Antti

[aalamaki]

Hi,

We came to notice also another issue, most likely a bug. If a product is added as "free", by default it tries to add a value "f" into a column (called "value") in the orders_total table, this column has been created as the type decimal on the database.

The system gave error on the checkout process, this happened on a completely clean install with no modifications (just the payment methods had been changed from default). Solved the issue by changing the database column into varchar.

/Antti