CiviCRM Community Forums (archive)

We are testing payment processing with a new client using a test authorize.net account.

Whenever we enter a 2nd credit card transaction there is an error.

The specific error is:

Database Error Code: Field 'amount' doesn't have a default value, 1364
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_entity_financial_trxn (entity_table , entity_id , financial_trxn_id , currency ) VALUES ('civicrm_contribution' ,  34 ,  14 , 'USD' )  [nativecode=1364 ** Field 'amount' doesn't have a default value]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_entity_financial_trxn (entity_table , entity_id , financial_trxn_id , currency ) VALUES ('civicrm_contribution' ,  34 ,  14 , 'USD' )  [nativecode=1364 ** Field 'amount' doesn't have a default value]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_entity_financial_trxn (entity_table , entity_id , financial_trxn_id , currency ) VALUES ('civicrm_contribution' ,  34 ,  14 , 'USD' )  [nativecode=1364 ** Field 'amount' doesn't have a default value]"]
)

It appears that for some reason the amount is not being generated.