Open extra topbar

Balances not showing in user accounts

If you are new here, please see some information on how to ask for support. Thank you!

Balances not showing in user accounts

dashed-slug.net Forums CoinPayments.net Coin Adapter extension support Balances not showing in user accounts

This topic contains 5 replies, has 2 voices, and was last updated by  clickforafrica 1 year, 6 months ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #2878

    clickforafrica
    Participant

    [ moved from https://wordpress.org/support/topic/balances-dissapeared-after-update ]

    I had a transfer of BTC to my wallet address on the lottofaucet.com site. The confirmation came from coinpayments.net and the balance shows on the adapters page:
    adapters
    However, the balance did not get credited to my account in WP… I checked all users and it is not in any user account. I also noticed that it doesn’t appear under sum of user balances either, which was working previously as you can see the original LTCT transaction is listed there.

    I requested another 10 LTCT and the same thing happened with that.

    Following the troubleshooting section of the dashed-slug site, I checked the IPN in my browser,
    ipn
    and the IPN history in my account
    ipn_history

    After doing the LTCT transfer I checked again the balances in the adapters list…
    adapters_list
    — the new LTCT transaction also did not appear in the sum of user balances, nor in any user account, though it does show in the wallet balance.

    Plugin version 3.1.2
    Git SHA 704e4ce
    Web Server Apache
    PHP version 5.5.38
    WordPress version 4.9.5
    MySQL version 5.6.39-cll-lve
    DB prefix wpk4_
    Is multisite false
    Is network activated false
    PHP max execution time 0
    Constant ‘WP_DEBUG’ false
    Constant ‘WP_DEBUG_LOG’ false
    Constant ‘WP_DEBUG_DISPLAY’ true
    Constant ‘DISABLE_WP_CRON’ n/a
    Constant ‘DSWALLETS_FILE’ /home/lottofaucet/public_html/wp-content/plugins/wallets/wallets.php
    PHP Extension ‘curl’ Loaded
    PHP Extension ‘mbstring’ Loaded
    PHP Extension ‘zlib’ Loaded
    Active wallets extensions wallets-faucet, wallets-woo, wallets-cp
    Network-active wallets extensions n/a

    #2879

    alexg
    Keymaster

    Hello,

    Thank you for the very detailed description of this issue.

    According to your IPN history, the IPN message did indeed arrive to your plugin instance.

    Since the message did arrive, the only other reason why it would not appear in your transactions list would be if the deposit address was not bound to your user.

    Can you please hit the following query into your SQL console?

    
    SELECT
    	*
    FROM
    	wpk4_wallets_adds a
    WHERE
    	symbol = 'LTCT' AND
    	address = 'YOUR_DEPOSIT_ADDRESS'
    ORDER BY
    	created_time DESC;

    Please replace YOUR_DEPOSIT_ADDRESS with the actual address you used for this transaction.

    This will confirm whether this address is indeed bound to a user.

    Please let me know what you find.

    regards

    #2880

    clickforafrica
    Participant

    Hi again, thanks!
    I tried the query with BTC and LTCT because the LTCT transfer was initiated in the coinpayments interface so I am not sure how they choose an address to send to (i.e.they have no way of knowing which addresses are associated with my WP account). Both returned no result. The BTC one was sent by someone else to the address generated by my site for my user.
    btc result:
    sql1
    LTCT result:
    sql2

    If it would make things go quicker I could send you cpanel login and make you an admin on the site. Also admin on clickforafrica.org so you can send LTCT back and forth.

    #2881

    clickforafrica
    Participant

    I think this is all the addresses in the site
    https://sites.google.com/site/nimnowiki/temp-page

    #2882

    alexg
    Keymaster

    OK thank you for the additional info.

    It doesn’t make sense for you to expect a deposit to go through if the transaction was initiated via the CoinPayments interface. What needs to happen is this:

    1. The user visits a page with the [wallets_deposit]. The plugin then requests a new address from the wallet (in this case CoinPayments) and assigns it to the user. The mapping is stored into the addresses table.

    2. The user then sends funds to that address. The wallet receives the funds, then informs the plugin. In the case of the CoinPayments adapter, this is done via the IPN message. The plugin then creates a deposit transaction for that user.

    3. Next time the user views their balance, the plugin sums all the transactions including the new deposit and this new amount is reflected in the total balance for that coin.

    Unless the address was stored in the addresses table and mapped to the user’s WordPress user id, the deposit will not go through.

    Here’s what you can do to rectify this:

    1. Figure out the user’s WordPress ID. This is an integer number that you can find via Admin -> Users.
    2. Insert the mapping manually (you would not have to do this under normal circumstances). Here’s how you could do this:
    INSERT INTO wpk4_wallets_adds(account,symbol,address,created_time) VALUES(5,'LTCT','A_DEPOSIT_ADDRESS',NOW());
    This would associate user with user_id=5 with the LTCT address A_DEPOSIT_ADDRESS.
    3. Go to your CoinPayments IPN history, and click the button to resend the IPN message.

    This should resolve your current issue. In the future, never allow your users to use the CoinPayments platform directly. They should not even have access to that, since it is your site’s wallet.

    Hope this helps.

    #2883

    clickforafrica
    Participant

    Thanks, I’ll go through and hopefully understand all that and act on it. The problem was not just the LTCT though, I had a transaction sent to the address generated in my user account page, with the shortcodes for deposit address etc. I sent it to someone and he sent BTC to that address. This only shows up in the admin.php?page=wallets-menu-adapters under wallet balance.

    It is not showing in the user balance, nor in the sum of user balances on admin.php?page=wallets-menu-adapters

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.