CiviCRM Community Forums (archive)

This has me completely stumped.  I'm getting the following errors when trying to submit our CiviEvent online registration forms.  The first confirmation page appears and then on the 2nd one I'm getting this error.  It was working yesterday.  I have the correct SMTP settings configured - in both civicrm.settings.php (both files).  Any other suggestions?


 Sorry. A non-recoverable error has occurred.

    Database Error Code: Duplicate entry 'test00000007-1' 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_financial_trxn (domain_id , entity_table , entity_id , trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 1 , 'civicrm_contribution' ,  98 ,  20080513151556 , 'Debit' ,  310 ,  310 , 'USD' , 'AuthNet_AIM' , 'test00000007' )  [nativecode=1062 ** Duplicate entry 'test00000007-1' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_financial_trxn (domain_id , entity_table , entity_id , trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 1 , 'civicrm_contribution' ,  98 ,  20080513151556 , 'Debit' ,  310 ,  310 , 'USD' , 'AuthNet_AIM' , 'test00000007' )  [nativecode=1062 ** Duplicate entry 'test00000007-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_financial_trxn (domain_id , entity_table , entity_id , trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 1 , 'civicrm_contribution' ,  98 ,  20080513151556 , 'Debit' ,  310 ,  310 , 'USD' , 'AuthNet_AIM' , 'test00000007' )  [nativecode=1062 ** Duplicate entry 'test00000007-1' for key 2]"]
)


the error is being thrown because of the unique constraint on trxn_id (test00000007).  the payment processor code generates this for authorize.net, so it is potentially a bug there

you might want to take a look at the code and/or contact the authors

lobo