dashed-slug.net › Forums › General discussion › Delete an user with a positive balance › Reply To: Delete an user with a positive balance
October 23, 2018 at 8:48 am
#4896
alexg
Keymaster
OK, after investigating:
- If you use “Tools” -> “Erase personal data”, then the user’s transactions will also be deleted.
- If you go to “Users” -> “Delete”, then the user’s transactions will not be deleted.
If you still have the user’s ID, you can delete the transactions manually (after you do a DB backup) with the following SQL:
DELETE FROM wp_wallets_txs WHERE account = ?
where ? is the user’s numeric ID.
I will change the code in the next patch so that transactions will also be deleted if you use “Users” -> “Delete”.
Thank you!