Reason why backend Invoice is not working(Using authorize.net payment)
when we place an order using this method:
the transaction table "sales_payment_transaction" updated by txn_id = 0
On the backend invoice:
Unable to save the invoice.
Error: SQLSTATE23000: Integrity constraint violation: 1062 Duplicate entry '61-61-0' for key 'UNQ_SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID', query was: INSERT INTO `sales_payment_transaction` (`order_id`, `payment_id`, `txn_id`, `txn_type`, `is_closed`, `additional_information`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, '2017-07-04 07:23:00')
because try to updated the table with txn_id=0 for the same order(Duplicate)
Here the Authorize transaction ID alway "0"
