I have a Magento website. Checkout works with paypal and via Purchase Order. But it returns an error message on checkout with credit card. I am using authorize.net.
The error mesage to the user is:
"Payment authorization has been declined" (if not in Test mode)
"There was an error processing your order. Please contact us or try again later." (if in Test mode)
The detailed error message from magento is:
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`bcsindus_magento/sales_payment_transaction`, CONSTRAINT `FK_SALES_PAYMENT_TRANSACTION_ORDER` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCAD)
I am looking for someone who is proficient in Magento and in [url removed, login to view] who can fix this right away. I don't suspect it is a detailed problem to fix, but I am short on time.