Paypal Refund Callback Problem after server move

[djdavedawson]

So the debug logs aren't where i'd thought they'd be.

I thought they would be at includes/modules/payment/paypal/logs but the folder was empty.

I set it for email too and here are a few things I found:



IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create
session as PayPal IPN transaction.

IPN FATAL ERROR :: No saved IPN session data available. Must be an Express
Checkout or Direct Pay transaction.



Interesting though I saw where it asks for the status update but no other message after.

IPN NOTICE :: Updating order #49459 to status: 1 (txn_type: parent)

[djdavedawson]

OK Getting Closer :


PHP Fatal error: 1366:Incorrect integer value: '' for column 'customer_notified' at row 1 :: INSERT INTO zen_orders_status_history (orders_id, orders_status_id, date_added, comments, customer_notified) VALUES ('49459', '1', now(), 'PayPal status: Refunded @ 17:08:29 Feb 13, 2017 PST\n Parent Trans ID:7W349436LG777561N\n Trans ID:2A3958908J8132115\n Amount: -11.55 USD', '') in /home/account/public_html/includes/classes/db/mysql/query_factory.php on line 98

Line 98

function show_error() {
    if ($this->error_number == 0 && $this->error_text == DB_ERROR_NOT_CONNECTED && !headers_sent() && file_exists('nddbc.html') ) include('nddbc.html');
    echo '<div class="systemError">';
    if (defined('STRICT_ERROR_REPORTING') && STRICT_ERROR_REPORTING == true) 
    {
      echo $this->error_number . ' ' . $this->error_text;
      echo '<br />in:<br />[' . (strstr($this->zf_sql, 'db_cache') ? 'db_cache table' : $this->zf_sql) . ']<br />';
    } else {
      echo 'WARNING: An Error occurred, please refresh the page and try again.';    
    }
    trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);
    if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
    echo '</div>';
  } 

[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

[sdelaney]

I have this exact same issue after upgrading my site to 1.5.5f ... partial refund initiated in ZC is processed by PayPal, but the refund is not showing up in ZC as it used to do before the upgrade. We are on the same server, etc ... the "only" change is the upgrade.

Please advise, did this fix discussed above work?

>>>>>>>>>>> Just checked my code for the php file, and the recommended change is already in place. So there must be some other issue.