CiviCRM Community Forums (archive)

I'm getting the following error when I'm trying to make a contribution. Any ideas?

DB Error: already exists

Database Error Code: Duplicate entry 'live_00000001' for key 2, 1062
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_financial_trxn (trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 20101119160325 , 'Debit' ,  5 ,  5 , 'USD' , 'Dummy' , 'live_00000001' )  [nativecode=1062 ** Duplicate entry 'live_00000001' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_financial_trxn (trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 20101119160325 , 'Debit' ,  5 ,  5 , 'USD' , 'Dummy' , 'live_00000001' )  [nativecode=1062 ** Duplicate entry 'live_00000001' 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 (trxn_date , trxn_type , total_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 20101119160325 , 'Debit' ,  5 ,  5 , 'USD' , 'Dummy' , 'live_00000001' )  [nativecode=1062 ** Duplicate entry 'live_00000001' for key 2]"]
)


Gah, after being able to reliably duplicate the bug, it's no longer happening!

But I am having another problem/question. It doesn't seem to be using the payment processor I've chosen. I selected the Auth.net as the payment processor in the Contribution Page settings but the payments don't show up in Authorize.net. Then I tried modifying the Auth keys, making them invalid, to see if it was even contacting the server. It still went through "successfully", despite the invalid Auth.net credentials.

Any ideas?