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) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
Pages: [1]

Author Topic: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed  (Read 3546 times)

hakanuner

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: WordPress 3.7.1
  • MySQL version: 5.5.30
  • PHP version: 5.4
4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
April 30, 2013, 09:06:38 pm
Hi Guys,

I just realised after a few more tests that the following disclaimer:

Quote
IMPORTANT: Payment notifications back to CiviCRM do not work properly for PayPal Website Standard transactions in 4.3.0 (this means the contributions will display as "Pending - Incomplete Transaction' even though the payment has been completed at PayPal). If your organization uses this payment method AND you've already upgraded to 4.3.0 - you should upgrade to 4.3.1 immedately.

Has only been fixed for cases when the "Multiple Registration Allowed" feature is not selected. I just did a registration where I registered two people with the same email the PayPal receipt came in through, yet the status of the contribution/event registration is still "Pending from incomplete transaction".

FYI

Regards,

Hakan

planetwebb

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 2
  • CiviCRM version: 4.5.8
  • CMS version: Joomla 2.5.28 / Drupal 7.34
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.22
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 01, 2013, 03:23:10 pm
Just to note, I'm using "Multiple Registration Allowed" and my IPN is working.

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: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 01, 2013, 04:51:51 pm

planetwebb: thanx for reporting that it is working for u

hakan: i'd try resending the IPN from paypal website and try and trace what happens

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

hakanuner

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: WordPress 3.7.1
  • MySQL version: 5.5.30
  • PHP version: 5.4
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 02, 2013, 04:01:51 pm
planetwebb,

I see that you are using two versions of CiviCRM, does this work on both versions or just 4.2.9?

Donald,

Here is what I can gather. When I register a single person it always works... But when I register multiple people it remains pending. The CiviCRM.log file displays the following:

Code: [Select]
May 02 16:52:25  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_id = 39 , price_field_id = 5 , label = 'includes Accomodation, Transport from Melbourne, Healthy Food & Camp Kit' , qty = 1 , unit_price = 0.01 , line_total = 0.01 , participant_count = 0 , price_field_value_id = 5 , financial_type_id = 4   WHERE (  civicrm_line_item.id = 40 )   [nativecode=1062 ** Duplicate entry 'civicrm_participant-39-5-5' for key 'UI_line_item_value']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_id = 39 , price_field_id = 5 , label = 'includes Accomodation, Transport from Melbourne, Healthy Food & Camp Kit' , qty = 1 , unit_price = 0.01 , line_total = 0.01 , participant_count = 0 , price_field_value_id = 5 , financial_type_id = 4   WHERE (  civicrm_line_item.id = 40 )   [nativecode=1062 ** Duplicate entry 'civicrm_participant-39-5-5' for key 'UI_line_item_value']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_id = 39 , price_field_id = 5 , label = 'includes Accomodation, Transport from Melbourne, Healthy Food & Camp Kit' , qty = 1 , unit_price = 0.01 , line_total = 0.01 , participant_count = 0 , price_field_value_id = 5 , financial_type_id = 4   WHERE (  civicrm_line_item.id = 40 )   [nativecode=1062 ** Duplicate entry 'civicrm_participant-39-5-5' for key 'UI_line_item_value']"]
)


May 02 16:52:25  [info] $backTrace = #0 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: already exists", -5, 16, (Array:2), "UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_...")
#4 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-5, 16, (Array:2), "UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_...")
#5 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -5, NULL, NULL, "UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_...", "DB_Error", TRUE)
#6 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-5, NULL, NULL, NULL, "1062 ** Duplicate entry 'civicrm_participant-39-5-5' for key 'UI_line_item_va...")
#7 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_...")
#9 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_...")
#10 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1324): DB_DataObject->_query("UPDATE  civicrm_line_item  SET entity_table = 'civicrm_participant' , entity_...")
#11 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(284): DB_DataObject->update()
#12 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Price/BAO/LineItem.php(65): CRM_Core_DAO->save()
#13 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Price/BAO/LineItem.php(292): CRM_Price_BAO_LineItem::create((Array:16))
#14 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(2784): CRM_Price_BAO_LineItem::processPriceSet("39", (Array:1), Object(CRM_Contribute_BAO_Contribution), "civicrm_participant", TRUE)
#15 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Core/Payment/BaseIPN.php(499): CRM_Contribute_BAO_Contribution::recordFinancialAccounts((Array:28), NULL)
#16 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Core/Payment/PayPalIPN.php(256): CRM_Core_Payment_BaseIPN->completeTransaction((Array:28), (Array:6), (Array:8), Object(CRM_Core_Transaction), FALSE)
#17 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/CRM/Core/Payment/PayPalIPN.php(309): CRM_Core_Payment_PayPalIPN->single((Array:28), (Array:6), (Array:8), FALSE, FALSE)
#18 /home4/ymacamps/public_html/register/wp-content/plugins/civicrm/civicrm/extern/ipn.php(64): CRM_Core_Payment_PayPalIPN->main("event")
#19 {main}

With the attached IPN retry information (keeps retrying for multiple registrations).

Can anyone guess what is going on?

Regards,

Hakan

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 03, 2013, 05:21:31 pm

I have filed http://issues.civicrm.org/jira/browse/CRM-12522 for the same

Thanks for catching this!
Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

planetwebb

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 2
  • CiviCRM version: 4.5.8
  • CMS version: Joomla 2.5.28 / Drupal 7.34
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.22
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 03, 2013, 06:16:35 pm
Quote from: hakanuner on May 02, 2013, 04:01:51 pm
planetwebb,

I see that you are using two versions of CiviCRM, does this work on both versions or just 4.2.9?

On my 4.3.1 installation, I have "allow multiple registrations" checked but so far only single registrations have been made so I could have same issue.  I thought that having it checked caused all of your transactions to hang...I could have same issue but not presented yet.

hakanuner

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: WordPress 3.7.1
  • MySQL version: 5.5.30
  • PHP version: 5.4
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 04, 2013, 12:04:42 am
Thanks Yashodha! Looking forward to the update.

planetwebb, I anticipate this scenario with our system, as we expect parents registering multiple children to events, etc. That's why I always test it with all of our events. I would assume it would happen on your 4.3.1 system as well. I haven't used 4.2.9 so I can't say. I skipped from 4.1.x to 4.3.1 directly.

Regards,

Hakan

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 06, 2013, 12:32:10 pm
This has been fixed for 4.3.3

You might wanna test patch :
https://github.com/yashodha/civicrm-core/commit/0ba0addfd6ed7fee847ca41fb1bf071a248861d6.patch

I couldn't replicate the bug in 4.2.9

HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

hakanuner

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: WordPress 3.7.1
  • MySQL version: 5.5.30
  • PHP version: 5.4
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 07, 2013, 12:34:51 am
Yashodha,

I've applied the patch and things are back to normal.

Thanks!

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
May 07, 2013, 11:42:50 am
Cool, Thanks for catching this! :)
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

andrewhunt

  • I post occasionally
  • **
  • Posts: 80
  • Karma: 13
    • AGH Strategies
  • CiviCRM version: all of 'em
  • CMS version: Drupal, Joomla, and WordPress
Re: 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed
June 10, 2013, 03:08:29 pm
I'm getting a similar problem for a client who's having the original participant go through and the second one go through, but participants 3, 4, etc. are still pending.  Is anyone else having the same problem?  I'll do some further testing later this week.
You can find me at AGH Strategies.
Need help now?  Civi911 is your go-to for CiviCRM support.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • 4.3.1 Bug Fix for "Pending from incomplete transaction" is not really fixed

This forum was archived on 2017-11-26.