Where are payment details stored?

[Osirion]

Hi Guys,

I've recently found a bug (reported, see: http://forge.prestashop.com/browse/PSCSX-4685) and now I'm trying to clean up the mess that its causing.

Basically its duplicating payments/invoices and so I want to delete the duplicates.

 

I've had this issue with my two recent orders. One was a bank wire payment and the other a PayFast payment (similar to PayPal - its a payment gateway).

On the bank wire order, I deleted the corresponding duplicate entry in order_payment and now the backend reflects properly.

However, with the PayFast paid order, I did the same but its still showing a duplicate in the backend. Its not cache - I've cleared cache (browser and Prestashop) as well as tried an alternative browser. Where else is payment details stored other than order, order_payment, order_invoice, order_invoice_payment tables?

[El Patron]

would just cancelling the duplicate be better than trying to delete orders?  This can cause issue as there are several things linked to an order, cart, etc.

[Osirion]

Theres no way for me to delete 'payments' otherwise I would.

[El Patron]

I wrote 'cancel' order, not delete it.

[Osirion]

I dont want to cancel the order? Its a valid order - its just (due to a bug) - it got 2 payments assigned to it instead of 1. Im just trying to delete the second payment so that it doesnt have the warning message:

Warning R 7,200.00 paid instead of R 3,600.00

I've gone as far as doing a db dump and searching for the timestamp of the second (duplicate) payment and it doesnt exist in the database (other than 1 instance on "order_history" which was when I changed the status of the order from "payment accepted" to "preparation in progress").

How is Prestashop pulling this information when it doesnt exist anymore and Ive deleted all visible traces of it???