CiviCRM Community Forums (archive)

After upgrading to CiviCRM 2.2.5 from 2.2.2, I have found that CiviEvent is no longer recording completed registrations correctly. The registration is passed off to the payment gateway (Paymex in NZ) which successfully completes the transaction and hands the user back to the site. All appears to be well as CiviEvent displays to the user a successful registration message. However, in the database the registration is still recorded as "Pending (Incomplete Transaction)". Regreattably, I only tested as far as the successful registration message on my dev server and didn't realise this bug until it was deployed live. Have attempted a downgrade on the dev server to see if that would be possible but that didn't seem to resolve this issue. Restore from backups not an option due to additional registrations etc that have happened in the interim.

I will set up a test account with a different gateway and see if that results in a different outcome, but because the user is displayed the successful registration message it seems somewhat unlikely that the gateway is at fault. Can anyone suggest any other lines of investigation?

Thanks for looking at this lobo. You are of course correct it was a problem in the IPN file and it was a coincidence that this problem appeared when I upgraded to 2.2.5. Turns out it was the resurfacing of an issue with the Paymex IPN (which Paymex developed themselves, based heavily on the Paypal one) that xur1z had helped me resolve previously. Apparently I'd only corrected it on the live site and I'd accidentally overwritten the corrected IPN file with the standard one alongside the upgrade to 2.2.5.

I'd already submitted other patches to Paymex but this one got missed. I've now sent Paymex information on how to fix their IPN file but in case anyone needs to do it themselves in the meantime, the file to be changed is:
civicrm/CRM/core/payment/PaymexIPN.php

You need to modify one of the final lines of the file from:
$input['amount'] = self::retrieve( 'amount', 'Money', 'POST', false );to read:
$input['amount'] = str_replace("$","",self::retrieve( 'amount', 'String', 'POST', false ));