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

[joommaster]

I am getting this error when I do a test contribution. The contribution goes through fine but we get this page after we click "make contribution":

Sorry. A non-recoverable error has occurred.

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

Return to CiviCRM menu.

Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

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 , fee_amount , net_amount , trxn_id , invoice_id , currency , receipt_date , source , amount_level , contribution_status_id ) VALUES ( 1 ,  18 ,  2 ,  1 ,  1 ,  20070623114122 ,  1.00 ,  1.00 ,  NULL ,  1.00 , '0' , 'b6c6fbe3df3c098fe2e67f07235067b4' , 'USD' ,  20070623114122 , 'Online Contribution' ,  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 , fee_amount , net_amount , trxn_id , invoice_id , currency , receipt_date , source , amount_level , contribution_status_id ) VALUES ( 1 ,  18 ,  2 ,  1 ,  1 ,  20070623114122 ,  1.00 ,  1.00 ,  NULL ,  1.00 , '0' , 'b6c6fbe3df3c098fe2e67f07235067b4' , 'USD' ,  20070623114122 , 'Online Contribution' ,  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 , fee_amount , net_amount , trxn_id , invoice_id , currency , receipt_date , source , amount_level , contribution_status_id ) VALUES ( 1 ,  18 ,  2 ,  1 ,  1 ,  20070623114122 ,  1.00 ,  1.00 ,  NULL ,  1.00 , '0' , 'b6c6fbe3df3c098fe2e67f07235067b4' , 'USD' ,  20070623114122 , 'Online Contribution',  NULL ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' for key 2]"]
)

[Dave Greenberg]

Pretty sure the error is happening because (for some reason) the trxn_id value is '0'  on the insert. This is unexpected - there is a unique key on domain + trxn_id in the DB so we expect a unique value (from the payment processor). What processor are you using?

[joommaster]

We are using Authorize.net.

[idealso]

In test mode, Authorize.Net returns a transaction ID of 0.  CiviCRM therefore is supposed to ignore the returned transaction id of 0, and instead generate a transaction id of "testX".  Which version of CiviCRM are you using?

[Jerry]

I have experienced the same issue but have found it only shows up when the same individual registers for the same event twice.

[Andy Laken]

I was getting the same error a few days ago when attempting to set up Authorize.net for test transactions. I'm using 1.7 and it says "CiviCRM 9753" at the bottom of every page.

[senojeel]

Just curious,

Was there ever a resolution to this post?

Shawn

[idealso]

This should be fixed.  In 1.8, the generation of the test id is also improved.  I think it may still possible to get a duplicate (usually test10) in 1.7.

[senojeel]

I am using a build of 1.8 from last week and I was still getting the error.  I am updating to today's release and will report back.

[idealso]

When you do a test transaction, is that with Authorize.Net in test mode, and/or from a CiviCRM test page?

If it's from a CiviCRM test page, then the trxn_id of 0 is replaced with a test number.  If it's from a live page with Authorize.Net in test mode, then CiviCRM does not check for this, and trusts the number returned from Authorize.Net.  Since the response fields don't give any indication of if it was a test request or not, probably the only thing to really do is to check for trxn_id is 0 in live mode, and if so, display an error.  The error message would ask if you meant to submit the transaction as a test.

[Laryn]

I am getting the same error with Authorize.net when I've turned the Authorize.net account to Test Mode. Using the live page link from CiviCRM and have upgraded earlier today to 1.9.

Do I read correctly that this is just a test mode problem ... and so if I turn it live it'll work? I'll probably test this tomorrow, but if anyone's already done it I'd love to know beforehand.

Peace,
Laryn

[Laryn]

Okay, I've turned the account to live mode, and now the error is as follows:

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

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

    [ code] =>
    [message] => Invalid response code received from server
    [mode] => 16
    [debug_info] =>
    [type] => PEAR_Error
    [user_info] =>
    [to_string] => [pear_error: message="Invalid response code received from server" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info=""]
)

Anyone have advice?
Peace,
Laryn

[Dave Greenberg]

That error usually indicates a problem with your outbound mail (SMTP) configuration - AND happens at the end of a contribution sequence because CiviContribute is trying to mail out the receipt to the donor.

Try using "Send Email to a Contact" from a contact summary page - and see if you get the same error. If so, check your Global Settings >> SMTP Settings and search on this forum for that error message for solutions.

[Laryn]

That error usually indicates a problem with your outbound mail (SMTP) configuration

Bingo! Thanks for that... I think we're up and running now with the ability to take a donation/payment online.

[Kurund Jalmi]

There was another issue related to Authorize.Net.
Please check http://issues.civicrm.org/jira/browse/CRM-2566

kurund