Paypal Refund Callback Problem after server move

[djdavedawson]

Something on the new server is not treating false as 0.

 'customer_notified' => false 

The sql input statement is created here in paypal_functions.php:

$sql_data_array = array('orders_id' => (int)$ordersID,
                            'orders_status_id' => (int)$new_status,
                            'date_added' => 'now()',
                            'comments' => 'PayPal status: ' . $_POST['payment_status'] . ' ' . ' @ ' . $_POST['payment_date'] . (($_POST['parent_txn_id'] !='') ? "\n" . ' Parent Trans ID:' . $_POST['parent_txn_id'] : '') . "\n" . ' Trans ID:' . $_POST['txn_id'] . "\n" . ' Amount: ' . $_POST['mc_gross'] . ' ' . $_POST['mc_currency'],
                            'customer_notified' => false 

[DrByte]

You're probably using a version of MySQL newer than what your version of Zen Cart was originally designed for.
I imagine you need the following change to deal with that last error message: https://github.com/zencart/zencart/pull/1320/files

... and will probably benefit from other upgrades to support the stricter implementation of newer versions of MySQL.

[djdavedawson]

Looks like the mysql version on the new server is 5.6 vs 5.5 and the sql mode of the new server is

-> STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

I will implement the fix and post if any other issues occur.

Thanks Dr B and MC