Error on event registration

[rjb]

Hello,

I've just started noticing an error which sometimes occurs when a registered user (with a drupal account) registers for an event. It's not happening if an anon user does so, as far as I can tell. UPDATE: I have just experienced this when registering anonymously, however this was solved by clearing my browser cache.

It's also something I never noticed on 3.3.1, so it may be new in 3.3.2. I can't upgrade to 3.3.3 until Wednesday, unfortunately, so I can't check and see whether this is now fixed.

Here's the error message I get, which happens on the confirm screen after the registration has been checked by the user who then clicks continue / processing...

Sorry. A non-recoverable error has occurred.
DB Error: already exists
Error Details:

Database Error Code: Duplicate entry 'civicrm_participant-24-1-1' for key 'UI_line_item_value', 1062
Additional Details:
 

Code: [Select]

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    => -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' ,  24 ,  1 , 'Gold Member Admission' ,  1 ,  100 ,  100 ,  0 ,  1 )  [nativecode=1062 ** Duplicate entry 'civicrm_participant-24-1-1' 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' ,  24 ,  1 , 'Gold Member Admission' ,  1 ,  100 ,  100 ,  0 ,  1 )  [nativecode=1062 ** Duplicate entry 'civicrm_participant-24-1-1' 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' ,  24 ,  1 , 'Gold Member Admission' ,  1 ,  100 ,  100 ,  0 ,  1 )  [nativecode=1062 ** Duplicate entry 'civicrm_participant-24-1-1' for key 'UI_line_item_value']"]
)

NB: this doesn't seem to happen all the time, which is making it very hard to identify and solve. Anyone have any ideas? I THINK it might be because my strict email=10/threshold=10 dedupe rule isn't kicking in and so, rather than merging contact, it's trying to create a new one with the same details... ?

Best,

Robin

[xavier]

Do you have price/priceset ?

[rjb]

Hi, Xavier

Yes, there's a price set on this page - it's actually an event produced from an event template, and there's a price set called in the template.

Best,

Robin

[ES.Bill]

Hi Robin,

I'm having the same problem.  Did you find a solution?

..........Bill

[rjb]

I'm afraid not, Bill - the problem just went away for me. I wish I could nail it though...

[sonicthoughts]

I can reproduce this error.  I'm using PayPal Standard.  Event uses a price set.
Workflow Scenario (quite common actually):
User Registers for event
Confirms
Goes to paypal and hits Back Button

This is pretty ugly.

[sonicthoughts]

Details:
Database Error Code: Duplicate entry 'civicrm_participant-29-17-8' for key 'UI_line_item_value', 1062
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -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' ,  29 ,  8 , 'Other Amount' ,  1 ,  1.00 ,  1 ,  0 ,  17 )  [nativecode=1062 ** Duplicate entry 'civicrm_participant-29-17-8' 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' ,  29 ,  8 , 'Other Amount' ,  1 ,  1.00 ,  1 ,  0 ,  17 )  [nativecode=1062 ** Duplicate entry 'civicrm_participant-29-17-8' 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' ,  29 ,  8 , 'Other Amount' ,  1 ,  1.00 ,  1 ,  0 ,  17 )  [nativecode=1062 ** Duplicate entry 'civicrm_participant-29-17-8' for key 'UI_line_item_value']"]
)

[Osvaldo]

Hi there,

We're experiencing this issue on version 4.1.5. What was the solution?