Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-10032

Pending from incomplete transaction - Retry fails

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Blocker
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.1.1
    • Fix Version/s: 4.2.0
    • Component/s: CiviEvent
    • Labels:

      Description

      Drupal 7
      CiviCRM 4.1.1

      I have an event setup for registration via Paypal Website Standard.
      I have a bunch of registrations Pending from incomplete transaction

      Users are saying that if they click cancel at Paypal, they are redirected to the registration page where if they try register again, they encounter an error to do with record already existing.

      I've recreated the steps below:

      1. Go to Event
      2. Click Register
      3. Clickthrough all the way to paypal
      4. At paypal, click "cancel and return to.. site"
      5. I'm redirected back to the registration page (NOT THE EVENT PAGE)
      Here, a "Pending from incomplete transaction" status is created for the user"

      6. Without going anywhere else, (I'm at the registration form), I click continue (all profile fields filled from previous attempt).
      7. I make it to the confirmation page. Click on continue.
      8. I then get below Error:

      DB Error: already exists

      With the following detail:

      Database Error Code: Duplicate entry 'civicrm_participant-82-12-6' for key 'UI_line_item_value', 1062
      Additional Details:
      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -5
      [message] => DB Error: already exists
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id ) VALUES ('civicrm_participant' , 82 , 6 , 'Up to $20,000 a Year -' , 1 , 254.50 , 254.5 , 0 , 12 ) [nativecode=1062 ** Duplicate entry 'civicrm_participant-82-12-6' for key 'UI_line_item_value']
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id ) VALUES ('civicrm_participant' , 82 , 6 , 'Up to $20,000 a Year -' , 1 , 254.50 , 254.5 , 0 , 12 ) [nativecode=1062 ** Duplicate entry 'civicrm_participant-82-12-6' 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="INSERT INTO civicrm_line_item (entity_table , entity_id , price_field_id , label , qty , unit_price , line_total , participant_count , price_field_value_id ) VALUES ('civicrm_participant' , 82 , 6 , 'Up to $20,000 a Year -' , 1 , 254.50 , 254.5 , 0 , 12 ) [nativecode=1062 ** Duplicate entry 'civicrm_participant-82-12-6' for key 'UI_line_item_value']"]
      )

      IF, I now proceed to the event page, I can go through the whole process all the way to cancel at paypal.
      It seems I am unable to complete the form immediately I return to the registration page from paypal and need to go to the event page itself (event page refresh?)

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              drewpal andrew sang
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: