I have a Opencart shop that I'm testing in the sandbox environment. My test environment has stopped working I think it might have something to do with deleting the data in DELETE FROM oc_paypal_order; DELETE FROM oc_paypal_order_transaction; At the beginning, I started off with everything working, I was testing my Opencart shop in the sandbox environment and things were going OK. I would do some testing and then delete data in the tables DELETE FROM oc_order; DELETE FROM oc_order_history; DELETE FROM oc_order_option; DELETE FROM oc_order_product; DELETE FROM oc_order_recurring; DELETE FROM oc_order_recurring_transaction; DELETE FROM db_shoes.shoes_order_shipment; DELETE FROM db_shoes.shoes_order_total; DELETE FROM db_shoes.shoes_order_voucher; As well as setting the AUTO_INCREMENT of these tables to 1 and running REPAIR TABLE commands for each table. And everything kept working and so I did more testing and then deleting and more testing, over and over again and it worked. Then I changed my innodb_autoinc_lock_mode = 0 to stop the order number skipping values at the same time as I deleted... DELETE FROM oc_paypal_order; DELETE FROM oc_paypal_order_transaction; Now I can't process transactions in the sandbox environment and I get an error "Duplicate Invoice ID detected. To avoid a potential duplicate transaction your account setting requires that Invoice Id be unique for each transaction." So I'm guessing it might be because I deleted the data in oc_paypal_order and oc_paypal_order_transaction, but this is just a guess. Is PayPal comparing the newest auto_increment values from the oc_paypal_order and oc_paypal_order_transaction tables with the data in the sandbox environment. Can I delete my sandbox environment and start again? Is that easy to do? And will that mean that the Sandbox will forget previous transactions, or will those transactions follow me around even if I delete the sandbox environment? Or could it be something else? Any ideas?
... View more