Author Topic: Database Error Code: Duplicate entry '0-1' for key 2, 1062 (Read 1212 times)

crayon · February 18, 2008, 01:09:20 pm

I get the following error message when I try to allow my "new users" (me with different names and emails) to make a donation or become a member. I fill in the form, cc info and sumbit and get this and I have no idea what it means or what to do:

Sorry. A non-recoverable error has occurred.

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

Return to home page.

Error Details:

Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contribution (domain_id , contact_id , contribution_type_id , contribution_page_id , payment_instrument_id , receive_date , non_deductible_amount , total_amount , net_amount , trxn_id , invoice_id , currency , source , amount_level , contribution_status_id ) VALUES ( 1 ,  17478 ,  2 ,  2 ,  1 ,  20080218160418 ,  50.00 ,  50.00 ,  50.00 , '0' , 'c8620db1455f60d6265df46c90b742e9' , 'USD' , 'Online Contribution: EarthSave Membership' ,  NULL ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contribution (domain_id , contact_id , contribution_type_id , contribution_page_id , payment_instrument_id , receive_date , non_deductible_amount , total_amount , net_amount , trxn_id , invoice_id , currency , source , amount_level , contribution_status_id ) VALUES ( 1 ,  17478 ,  2 ,  2 ,  1 ,  20080218160418 ,  50.00 ,  50.00 ,  50.00 , '0' , 'c8620db1455f60d6265df46c90b742e9' , 'USD' , 'Online Contribution: EarthSave Membership' ,  NULL ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' 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_contribution (domain_id , contact_id , contribution_type_id , contribution_page_id , payment_instrument_id , receive_date , non_deductible_amount , total_amount , net_amount , trxn_id , invoice_id , currency , source , amount_level , contribution_status_id ) VALUES ( 1 ,  17478 ,  2 ,  2 ,  1 ,  20080218160418 ,  50.00 ,  50.00 ,  50.00 , '0' , 'c8620db1455f60d6265df46c90b742e9' , 'USD' , 'Online Contribution: EarthSave Membership' ,  NULL ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' for key 2]"]
)

Dave Greenberg · February 18, 2008, 05:07:24 pm

What version of CiviCRM are you using. There was a problem with Authorize.net "test mode" transactions returning this error in earlier versions of CiviCRM. But it shoudl be fixed as of current stable release (1.9) except for test mode w/ Event Registration which was fixed in 2.0:

http://issues.civicrm.org/jira/browse/CRM-2566

The basic issue is that Authorize.net returns a "transaction ID" of 0 for all test transactions... however this value is supposed to be unique in the CiviCRM contribution table. The fix was to re-write the returned transaction ID to make it a unique value.

CiviCRM Community Forums (archive)

News:

Author Topic: Database Error Code: Duplicate entry '0-1' for key 2, 1062 (Read 1212 times)

crayon

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

Dave Greenberg

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