September 13, 2018 at 8:16 am #4391
An user wrote me this:
Hi, when I withdraw ETH, i withdraw the while balance I had at 0.016 ETH. But after receiving the eth to my walletinus the tx fee, I still have 0.0013 eth balance. How can I fully withdraw a balance and not have any remaining after. Same issue with doge as well.
I have checked his transactions and they do not match. He received ETH 0.0253871 and has withdrawn ETH 0.02669152!!! And now he has ETH 0.00136250 in his wallet.
Help please!September 13, 2018 at 8:30 am #4393
Normally this is not possible.
However, it is probably the case that the deposit happened with a version of the wallet prior to
3.6.5a fix was added to count deposit fees, that were previously introduced in the CoinPayments adapter. In other words, this must be related to: https://www.dashed-slug.net/forums/topic/negative-balance-request-for-a-pending-balance-feature/#post-4285
If your users use the latest version of both the parent plugin and the coin adapter extension, they can be assured that this will not happen again.
kind regardsSeptember 13, 2018 at 9:08 am #4394
No, both deposits and withdrawals have been made after the last update.
I wrote this to the user:
Please tell me what are the amounts of Ethereum that have finally reached your wallet in all Ethereum withdrawals
And he wrote me this:
1st payment received was 0.0092 eth and my balance on bycryp after showed as 0.0013eth available
2nd was 0.15 eth payment received and agaiinshows now as 0.0013 eth available on bycry even though I though I withdrew all eth.
Thanks!!!September 13, 2018 at 12:11 pm #4400
Yes, this looks important, as you say! Thank you for reporting, and for the additional info you sent to my email.
I will investigate and get back to you once I have a fix.
regardsSeptember 13, 2018 at 12:14 pm #4401
Thanks Alex!!! For the moment I have stopped withdrawals on my website.September 13, 2018 at 2:37 pm #4406
OK I have investigated at length the problem you reported, and have provided a fix in version
3.6.7of the parent plugin.
Thanks again for spotting this. There was another bug in the algorithm that sums fees for the balances. This was introduced in
3.6.5while attempting to fix another bug. The algorithm now correctly sums fees for all kinds of transactions, i.e. deposits, withdrawals, internal transfers and exchange trades.
Due to the bug being fixed now, you or your client may notice more negative balances. This is because withdrawal fees were not subtracted from user balances during the time between
3.6.7. My sincerest apologies for this.September 13, 2018 at 3:12 pm #4407
Great Alex!!! Thank you!!!
A greeting!!!September 13, 2018 at 6:45 pm #4408
Is there any way to know which users have their accounts in negative? I would like to add coins so that your balance reaches 0.September 14, 2018 at 8:24 am #4412
Assuming the table prefix is
wp_, and if the installation is not multisite, then the following query would show you the user ids, coins and balances that are negative:
SELECT account, symbol, SUM( IF( amount > 0, amount - fee, amount ) ) AS balance FROM wp_wallets_txs WHERE status = 'done' GROUP BY account, symbol HAVING balance < 0;
If you are on a multisite installation with multiple blogs, you should also group by blog_id:
SELECT blog_id, account, symbol, SUM( IF( amount > 0, amount - fee, amount ) ) AS balance FROM wp_wallets_txs WHERE status = 'done' GROUP BY blog_id, account, symbol HAVING balance < 0;
You must be logged in to reply to this topic.