CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.3 Release Testing (Moderator: pdelbar) »
  • PayPal IPN broken in 4.3
Pages: [1]

Author Topic: PayPal IPN broken in 4.3  (Read 6094 times)

aglozier

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
PayPal IPN broken in 4.3
April 16, 2013, 10:34:38 am
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
« Last Edit: April 16, 2013, 10:53:02 am by aglozier »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: PayPal IPN broken in 4.3
April 16, 2013, 01:32:14 pm

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

aglozier

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
Re: PayPal IPN broken in 4.3
April 16, 2013, 06:14:06 pm
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

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: PayPal IPN broken in 4.3
April 16, 2013, 06:51:59 pm
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)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

aglozier

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
Re: PayPal IPN broken in 4.3
April 16, 2013, 08:02:00 pm
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 post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
Re: PayPal IPN broken in 4.3
April 17, 2013, 08:57:53 am
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

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: PayPal IPN broken in 4.3
April 17, 2013, 07:28:51 pm
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
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

aglozier

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
Re: PayPal IPN broken in 4.3
April 18, 2013, 02:13:18 am
That fixed it! 

Thank you very much Yashodha. :D

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: PayPal IPN broken in 4.3
April 18, 2013, 10:16:59 am
Thanks for catching this!

-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.3 Release Testing (Moderator: pdelbar) »
  • PayPal IPN broken in 4.3

This forum was archived on 2017-11-26.