dashed-slug.net › Forums › Monero Wallet Adapter extension support › Moved: Negative balance after withdrawal › Reply To: Moved: Negative balance after withdrawal
I think I see what’s going on here.
You have two transactions with the same triplet of (TXID, symbol, and address).
Normally there is a unique constraint on these columns on the DB. The constraint’s name is uq_tx_idx.
It’s possible that you are missing this constraint, if you transferred the database via export/import.
What I find strange is that normally the plugin would warn you about this in the admin screens. Did you ever see such a notice in the admin screens?
Can you please go to your MySQL console and type the following?
SHOW CREATE TABLE wp_wallets_txs;
The indices on the table should look like this:
PRIMARY KEY (id),
UNIQUE KEY uq_tx_idx (txid,address,symbol),
KEY account_idx (account),
KEY blogid_idx (blog_id)
Let me know. Thank you.
