Missing products in order, paypal IPN stopping after BP 5

Hi,

I have a copy of ZenCart 1.3.8 that was downloaded as a complete install from a Linux box. Our servers are Windows boxes, so we knew there would be issues.

We've configured ZenCart and we switched to Paypal payments Standard. Now, when an order is placed, there are no product lines on the order.

I can see that the system should generate a Paypal header log, and a paypal history log etc. before it generates the product list, however none of this info is being logged.

The last debug email received was the one sent from valid_payment, which was successful.

I don't know why this would go wrong, but we've already had to address issues where ZenCart tries to store empty string into numeric MySql fields.

Is it likely that the IPN handler is bailing out because of badly formed data inputs?

Any help would be appreciated.

Best Regards,

Mark Rabjohn

mrabjohn:

I don't know why this would go wrong, but we've already had to address issues where ZenCart tries to store empty string into numeric MySql fields.
Zen Cart v1.3.8 was written for compatibility with PHP4 and MySQL 4, and it sounds like you're using MySQL 5 which has much stricter data-typing (unless the stricter mode is turned off).

In the case of your PayPal IPN concerns, you might try the following: http://www.zen-cart.com/forum/showpost.php?p=635003&postcount=17
I thought that was fixed as part of v1.3.8a, but I might be wrong.

Hi,

Yes, I am indeed running on MySql 5 - this is because our MySql 4 branch installation isn't actually new enough (and we're not upgrading). I haven't seen any instruction that says that MySql 5 couldn't be used.

In any case, the only thing required to fix the IPN issue is to find the various hash building functions and recode to allow for appropriate defaults.

e.g. in ipn_create_order_array in paypal_functions, I changed 'num_cart_items' as follows:

From:

'num_cart_items' => $_POST['num_cart_items']

To:

'num_cart_items' => ($_POST['num_cart_items'] || 'null')

This has to be done wherever a numeric field is involved and the value could conceivably be an empty string (I probably haven't tracked them all down).

I'm not a PHP programmer, but I presume that my syntax works due to the way I have seen PHP programmers handle errors i.e. "or die()".

My client has not reported any problems which could potentially arise due to NULL values, is anybody aware of any issues that could arise with these numeric fields set to null?

Best Regards,

Mark

If you use the suggestions made in the post I linked to earlier, you should be fine.