PayPal IPN broken in 4.3

[aglozier]

PayPal Instant Payment Notification (IPN) does not work with the PayPal Standard payment processor in version 4.3.0.  Payment are processed by PayPal and IPN messages are sent.  However, the contribution in CiviCRM have a Pending status.

Prior to the upgrade (version 4.2.9), IPN messages were received from PayPal and contributions were updated in CiviCRM with the PayPal information.  I reverted to version 4.2.9 and IPN worked again.

I filed a bug report for this: http://issues.civicrm.org/jira/browse/CRM-12361

[Donald Lobo]

can you do the following:

1. Resend the IPN from paypal

2. Check your CiviCRM.*.log files to see what is being recorded there including any error messages

in general, we need help from you debugging and narrowing the cause of the issue in addition to more generic "ipn not working" issue. As an open source project we do rely on folks helping in trouble shooting and fixing issues

lobo

[aglozier]

Since I reverted back to 4.2.9, I can't view the logs. However, I had previously resent the IPN and it did not update the contribution from Pending.

I duplicated this bug on the CiviCRM Wordpress sandbox.  I setup my Paypal sandbox payment processor on the CiviCRM sandbox and configured the "Fall Fundraiser Dinner" to use it.  I registered the Demo User using my processor.  I got the same results as on my server; the event registration doesn't get updated to Complete.  I resent the IPN to no avail.  I can't access the logs on CiviCRM Wordpress sandbox so I can't report on them.  You can see the 'Pending from incomplete transaction' registration in the Events Dashboard.

Early today after reverting to 4.2.9, I tested a similar online contribution and it work flawlessly using the same processor settings.  To test IPN on 4.3 I would have to upgrade my production server again since my test server is on my LAN behind a router and can't receive IPN messages.  Online contribution traffic is nil now but in a month we launch a large event and I must have a functional online registration system.

I'm unfamiliar with the CiviCRM log files but I would be willing to learn about them.  Are they located in the "wp-content/plugins/files/civicrm/ConfigAndLog" directory?  Where is documentation on how to read them?

[Eileen]

That sounds like the right location! If you can copy the files locally you can read them in a text editor - I'd try searching for 'ipn' or 'IPN' or 'Paypal' (preferably case insensitive search)

[aglozier]

I just realized my test on the CiviCRM WordPress sandbox was flawed.  I didn't change the IPN Notification URL to point to the CiviCRM sandbox.

I changed it and resent the IPN.  However I now can't log in to it with Username: demo & Password: demo for some reason.  Thus I can't check the results.

[aglozier]

I setup up a test subdomain on my production server with a fresh install of WordPress 3.5.1 and CiviCRM 4.2.9 with the sample data.  I setup a payment processor for my PalPay Sandbox and submitted a online contribution.  It processed correctly.

I then upgraded to CiviCRM 4.3.0 and submitted a online contribution.  It failed as before.  I examined the logs and found what looks to be an SQL syntax error (see below).  I attached the log which contains three such error (2 donations and a IPN resend).

Code: [Select]

Apr 17 10:53:21  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT  account_relationship, financial_account_id 
 FROM civicrm_entity_financial_account
 
 WHERE (  entity_id =   ) 
 
 
 ORDER BY financial_account_id 
 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
 
 
 ORDER BY financial_account_id' at line 4]
    [type] => DB_Error
    [user_info] => SELECT  account_relationship, financial_account_id 
 FROM civicrm_entity_financial_account
 
 WHERE (  entity_id =   ) 
 
 
 ORDER BY financial_account_id 
 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
 
 
 ORDER BY financial_account_id' at line 4]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  account_relationship, financial_account_id 
 FROM civicrm_entity_financial_account
 
 WHERE (  entity_id =   ) 
 
 
 ORDER BY financial_account_id 
 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
 
 
 ORDER BY financial_account_id' at line 4]"]
)


[Yashodha Chaku]

aglozier :

I have filed/fixed this issue for 4.3.1
For reference : http://issues.civicrm.org/jira/browse/CRM-12374

Can you try out the patch below and see if it fixes for you :
https://github.com/yashodha/civicrm-core/commit/a1f5ffccd198e035b01bb1ab5d41c91906c4baa3

Do let us know!

Thanks
-Yashodha

[aglozier]

That fixed it! 

Thank you very much Yashodha.

[Yashodha Chaku]

Thanks for catching this!

-Yashodha