You can always start over if you empty the two tables:
TRUNCATE wp_wallets_orders;
TRUNCATE wp_wallets_trades;
To be clear, this will remove all exchange data. Don’t do this unless you really want to delete everything!!!
If you also need to reverse the trades that have been already executed, so that the funds are returned to the users as if the trades never happened:
DELETE FROM wp_wallets_txs WHERE category='trade';
Before you do anything else, could you please run this query? I’d like to understand if these orders are still open due to some sub-satoshi amount not having been filled.
SELECT amount,filled,status FROM wp_wallets_orders WHERE ( amount - filled ) < 0.00000001 AND amount > filled;
If you can email or post me the output, it will be very helpful for me to see what’s going on.
Thanks again
with regards