dashed-slug.net › Forums › Exchange extension support › bad orders issue › Reply To: bad orders issue
Hello,
By “bad” I assume that you mean the amount is zero.
I believe this is due to a previous version that had allowed this type of order to be inserted. I am not certain if the amounts are zero or if they are simply less than one satoshi, there is no way to tell from the screenshot.
In any case, the user who entered the orders should be able to cancel them, from the [wallets_exchange_orders]
UI. This should be the easiest way.
Another way would be to directly delete them from the database:
1. Backup your database.
2. Assuming that your table DB prefix is wp_
, you can do this in your SQL console:
DELETE FROM wp_wallets_orders WHERE amount < 0.000000001;
(That’s eight zeroes after the decimal, followed by a 1) This will delete all orders with amounts less than one Satoshi.