CiviCRM Community Forums (archive)

I am having a problem after upgrading from ver 1.8 to ver 2.0.4.  Upgrade went to plan with no obvious problems, however, when I try to make a membership payment (Civicontribute) and paypal standard.  I get the error below.  This is an intermittent problem, occuring for some members and not others

Any suggestions?




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

Database Error Code: Duplicate entry '1-2186' for key 2, 1062

Return to home page.

Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_1_sigs  SET `sigs` = '', domain_id = 1, entity_id = 2186  [nativecode=1062 ** Duplicate entry '1-2186' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_1_sigs  SET `sigs` = '', domain_id = 1, entity_id = 2186  [nativecode=1062 ** Duplicate entry '1-2186' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_1_sigs  SET `sigs` = '', domain_id = 1, entity_id = 2186  [nativecode=1062 ** Duplicate entry '1-2186' for key 2]"]


Thanks, disabling the custom field solves the problem.  Its interesting that the issue affects all my custom fields, so I had to disable them all to solve the problem. 

I will investigate what is happening with these fields and post my findings back to this issue.

Thanks for the assistance

Brendan