Title: eotwallet's Replies | WordPress.org --- # eotwallet [ ](https://wordpress.org/support/users/eotwallet/) * [Profile](https://wordpress.org/support/users/eotwallet/) * [Topics Started](https://wordpress.org/support/users/eotwallet/topics/) * [Replies Created](https://wordpress.org/support/users/eotwallet/replies/) * [Reviews Written](https://wordpress.org/support/users/eotwallet/reviews/) * [Topics Replied To](https://wordpress.org/support/users/eotwallet/replied-to/) * [Engagements](https://wordpress.org/support/users/eotwallet/engagements/) * [Favorites](https://wordpress.org/support/users/eotwallet/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/users/eotwallet/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/eotwallet/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Waves and waves tokens](https://wordpress.org/support/topic/waves-and-waves-tokens/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 1 month ago](https://wordpress.org/support/topic/waves-and-waves-tokens/#post-10443962) * We would be willing to pay for this development. You can e-mail me at [redacted]. Specifically EOT Token that is on the waves platform. - This reply was modified 8 years, 1 month ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Missing deposits](https://wordpress.org/support/topic/missing-deposits/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 1 month ago](https://wordpress.org/support/topic/missing-deposits/#post-10433299) * Thanks, * One problem is that I have 785,535 transactions in history. If I run this command listtransactions “*” 100000 | grep txid | cut -d'”‘ -f4 | uniq | xargs -I %s curl -v [https://www.eotwallet.com/wallets/api2/notify/EOT/wallet/%s](https://www.eotwallet.com/wallets/api2/notify/EOT/wallet/%s) * The daemon server does not respond. I can at most do 50000. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Missing deposits](https://wordpress.org/support/topic/missing-deposits/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 1 month ago](https://wordpress.org/support/topic/missing-deposits/#post-10432929) * Hi, * 1. I have this walletnotify in the .conf file as was instructed. 2. I did run this manually and the transaction is now recovered. * So, even though I did have this walletnotify in my .conf file it did not happen automatically. The problem is that I don’t know how many other transactions is also missing. * Regards, * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Double send transactions!](https://wordpress.org/support/topic/double-send-transactions/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/double-send-transactions/#post-10378161) * Ok. It is there now. Will test this for a while and let you know. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Double send transactions!](https://wordpress.org/support/topic/double-send-transactions/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/double-send-transactions/#post-10378104) * The new update is not showing up in the WordPress backend yet? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Double send transactions!](https://wordpress.org/support/topic/double-send-transactions/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/double-send-transactions/#post-10375080) * [Thu Jun 07 14:18:23.163223 2018] [:error] [pid 14215] [client 207.154.197.212: 53068] WordPress database error Duplicate entry ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′ for key ‘uq_tx_idx’ for query INSERT INTO `wp_wallets_txs` (`blog_id`, `category`,` account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `created_time`,` updated_time`, `confirmations`, `status`, `retries`) VALUES (1, ‘deposit’, 10188,‘ EXSyerNTAh14UkZ2Yisjqo4CB29ZKPDwWR’, ”, ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′,‘ EOT’, ‘3.0000000000’, ‘0’, ‘2018-06-07T14:14:43+0000’, ‘2018-06-07 14:18:23’, 0, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook-> apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC- >cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook- >do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘ wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs- >action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching- >insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection- >insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\ DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250](https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250) [ Thu Jun 07 14:18:23.163316 2018] [:error] [pid 14215] [client 207.154.197.212: 53068] action_wallets_transaction Transaction could not be inserted! Array\n(\ n [blog_id] => 1\n [category] => deposit\n [account] => 10188\n [address] => EXSyerNTAh14UkZ2Yisjqo4CB29ZKPDwWR\n [extra] => \n [txid] => 06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09\ n [symbol] => EOT\n [amount] => 3.0000000000\n [fee] => 0\n [created_time] => 2018-06-07T14:14:43+0000\n [updated_time] => 2018-06-07 14:18:23\n [confirmations] => 0\n [status] => pending\n [retries] => 255\n)\n, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250](https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250)[ Thu Jun 07 14:18:23.163329 2018] [:error] [pid 14215] [client 207.154.197.212: 53068] action_wallets_transaction Last DB error: Duplicate entry ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′ for key ‘uq_tx_idx’, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250](https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250)[ Thu Jun 07 14:18:23.420644 2018] [:error] [pid 14215] [client 207.154.197.212: 53068] WordPress database error Duplicate entry ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′ for key ‘uq_tx_idx’ for query INSERT INTO `wp_wallets_txs` (`blog_id`, `category`,` account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `created_time`,` updated_time`, `confirmations`, `status`, `retries`) VALUES (1, ‘deposit’, 11718,‘ EWejF4HouWb5aaHNpEEcNwYiSqDFL4575e’, ”, ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′,‘ EOT’, ‘4.0000000000’, ‘0’, ‘2018-06-07T14:14:43+0000’, ‘2018-06-07 14:18:23’, 0, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook-> apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC- >cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook- >do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘ wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs- >action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching- >insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection- >insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\ DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250](https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250)[ Thu Jun 07 14:18:23.420731 2018] [:error] [pid 14215] [client 207.154.197.212: 53068] action_wallets_transaction Transaction could not be inserted! Array\n(\ n [blog_id] => 1\n [category] => deposit\n [account] => 11718\n [address] => EWejF4HouWb5aaHNpEEcNwYiSqDFL4575e\n [extra] => \n [txid] => 06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09\ n [symbol] => EOT\n [amount] => 4.0000000000\n [fee] => 0\n [created_time] => 2018-06-07T14:14:43+0000\n [updated_time] => 2018-06-07 14:18:23\n [confirmations] => 0\n [status] => pending\n [retries] => 255\n)\n, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250](https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] Double send transactions!](https://wordpress.org/support/topic/double-send-transactions/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/double-send-transactions/#post-10373869) * 1. Yes, using an RPC wallet – was not doing this until the last update of 3.4.1 EOT Wallet – the wallet is responding correctly and the transactions are working correctly directly from the command line. Also have the bitcoin wallet running. * 2. Bitcoin and Altcoin Wallets Version 3.4.1 * Bitcoin and Altcoin Wallets: Airdrop extension 1.0.1 * Bitcoin and Altcoin Wallets: Full Node Multi Coin Adapter extension 1.0.4 * 3. Only first TxID logged in the database * 4. wallets_withdraw shortcode * 5. Server didn’t crash, but are still having database errors from previous post - This reply was modified 8 years, 2 months ago by [eotwallet](https://wordpress.org/support/users/eotwallet/). - This reply was modified 8 years, 2 months ago by [eotwallet](https://wordpress.org/support/users/eotwallet/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10341772) * Increasing it didn’t help – still getting the error * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10341184) * Ok. I found an issue with the max number of connections to the my SQL database. I have increase the number for max connections, so hopefully this solves it. It would still be nice to be able to search through the transaction list. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10340630) * Hi, * Yes, we are experiencing issues where the website is consistently giving Database Errors – Users can not access the site. * Browser message: Error establishing a database connection * It is nearly impossible to see if there are failing transactions, we have over 315k transactions and there is no way to search the transaction list. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/#post-10337350) * Hello, * Even after upgrade to version 3.3.6 I am still facing the same issue: * Tue May 29 06:58:06.217334 2018] [:error] [pid 6900] [client 207.154.197.212: 60858] WordPress database error Duplicate entry ‘b5b669117771cd4a4a6a21c945a22784d4ff7889af37ab2fcb4237a66fde8880’ for key ‘uq_tx_idx’ for query INSERT INTO `wp_wallets_txs` (`blog_id`, `category`,` account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `created_time`,` updated_time`, `confirmations`, `status`, `retries`) VALUES (1, ‘deposit’, 10307,‘ ERShErn3h2iJgwUuJAcLDeDhJGKQoGBeEs’, ”, ‘b5b669117771cd4a4a6a21c945a22784d4ff7889af37ab2fcb4237a66fde8880’,‘ EOT’, ‘3.0000000000’, ‘0’, ‘2018-05-29T06:54:40+0000’, ‘2018-05-29 06:58:06’, 2, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook-> apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC- >cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook- >do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘ wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs- >action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching- >insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection- >insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\ DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527577080.2362229824066162109375](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527577080.2362229824066162109375) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/#post-10321999) * Even with your latest version 3.3.5 * Fri May 25 08:28:46.452073 2018] [:error] [pid 26872] [client 207.154.197.212: 46450] WordPress database error BIGINT UNSIGNED value is out of range in ‘(`eotwallet_wordpress`.` wp_wallets_txs`.`retries` – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\ twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘pending’,\n\t\t\t\t\ t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 837503\n\t\ t\t\t\t\t made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Cron::trigger_cron, do_action(‘wallets_periodic_checks’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs- >execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching- >query, W3TC\\_CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection- >query, W3TC\\DbCache_Wpdb->default_query * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/#post-10309701) * After running for a while with the new update, got the database error again: * [Tue May 22 16:57:50.083965 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] action_wallets_transaction Last DB error: Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000) [ Tue May 22 16:57:50.087500 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] WordPress database error Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’ for query INSERT INTO `wp_wallets_txs` (`blog_id`, `category`,` account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `created_time`,` updated_time`, `confirmations`, `status`, `retries`) VALUES (1, ‘deposit’, 10440,‘ EcZ2NPqkT8Fv4KYorwAp8pPrcX9FRn9YDL’, ”, ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’,‘ EOT’, ‘6.0000000000’, ‘0’, ‘2018-05-22T16:54:58+0000’, ‘2018-05-22 16:57:50’, 1, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook-> apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC- >cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook- >do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘ wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs- >action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching- >insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection- >insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\ DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000)[ Tue May 22 16:57:50.087551 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] action_wallets_transaction Transaction could not be inserted! Array\n(\ n [blog_id] => 1\n [category] => deposit\n [account] => 10440\n [address] => EcZ2NPqkT8Fv4KYorwAp8pPrcX9FRn9YDL\n [extra] => \n [txid] => 7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a\ n [symbol] => EOT\n [amount] => 6.0000000000\n [fee] => 0\n [created_time] => 2018-05-22T16:54:58+0000\n [updated_time] => 2018-05-22 16:57:50\n [confirmations] => 1\n [status] => pending\n [retries] => 255\n)\n, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000)[ Tue May 22 16:57:50.087560 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] action_wallets_transaction Last DB error: Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000)[ Tue May 22 16:57:50.089672 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] WordPress database error Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’ for query INSERT INTO `wp_wallets_txs` (`blog_id`, `category`,` account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `created_time`,` updated_time`, `confirmations`, `status`, `retries`) VALUES (1, ‘deposit’, 9805,‘ EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq’, ”, ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’,‘ EOT’, ‘7.0000000000’, ‘0’, ‘2018-05-22T16:54:58+0000’, ‘2018-05-22 16:57:50’, 1, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook-> apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC- >cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook- >do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘ wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs- >action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching- >insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection- >insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\ DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000)[ Tue May 22 16:57:50.089716 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] action_wallets_transaction Transaction could not be inserted! Array\n(\ n [blog_id] => 1\n [category] => deposit\n [account] => 9805\n [address] => EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq\ n [extra] => \n [txid] => 7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a\ n [symbol] => EOT\n [amount] => 7.0000000000\n [fee] => 0\n [created_time] => 2018-05-22T16:54:58+0000\n [updated_time] => 2018-05-22 16:57:50\n [confirmations] => 1\n [status] => pending\n [retries] => 255\n)\n, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000)[ Tue May 22 16:57:50.089732 2018] [:error] [pid 2292] [client 207.154.197.212: 58282] action_wallets_transaction Last DB error: Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/#post-10309060) * mysql> SHOW INDEX FROM wp_wallets_txs; +—————-+————+————-+————–+————-+———–+————- +———-+——–+——+————+———+—————+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +—————-+————+————-+————–+————-+———–+————-+———-+——– +——+————+———+—————+ | wp_wallets_txs | 0 | PRIMARY | 1 | id | A | 157047 | NULL | NULL | | BTREE | | | | wp_wallets_txs | 0 | uq_tx_idx | 1 | txid | A | 110339 | NULL | NULL | YES | BTREE | | | | wp_wallets_txs | 0 | uq_tx_idx | 2 | address | A | 127234 | NULL | NULL | | BTREE | | | | wp_wallets_txs | 0 | uq_tx_idx | 3 | symbol | A | 146973 | NULL | NULL | | BTREE | | | | wp_wallets_txs | 1 | account_idx | 1 | account | A | 9816 | NULL | NULL | | BTREE | | | | wp_wallets_txs | 1 | blogid_idx | 1 | blog_id | A | 1 | NULL | NULL | | BTREE | | | +—————-+———— +————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+ 6 rows in set (0.00 sec) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Bitcoin and Altcoin Wallets] WordPress Database error](https://wordpress.org/support/topic/wordpress-database-error-125/) * Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/) * (@eotwallet) * [8 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-125/#post-10308680) * Some errors I am getting in apache2 error log * [Tue May 22 12:18:42.307574 2018] [:error] [pid 1449] [client 207.154.197.212: 54660] WordPress database error Duplicate entry ‘568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214’ for key ‘uq_tx_idx’ for query INSERT INTO `wp_wallets_txs` (`blog_id`, `category`,` account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `created_time`,` updated_time`, `confirmations`, `status`, `retries`) VALUES (1, ‘deposit’, 9805,‘ EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq’, ”, ‘568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214’,‘ EOT’, ‘2.0000000000’, ‘0’, ‘2018-05-22T12:14:38+0000’, ‘2018-05-22 12:18:42’, 1, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook-> apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC- >cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook- >do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘ wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs- >action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching- >insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection- >insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\ DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000) [ Tue May 22 12:18:42.309991 2018] [:error] [pid 1449] [client 207.154.197.212: 54660] action_wallets_transaction Transaction could not be inserted! Array\n(\ n [blog_id] => 1\n [category] => deposit\n [account] => 9805\n [address] => EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq\ n [extra] => \n [txid] => 568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214\ n [symbol] => EOT\n [amount] => 2.0000000000\n [fee] => 0\n [created_time] => 2018-05-22T12:14:38+0000\n [updated_time] => 2018-05-22 12:18:42\n [confirmations] => 1\n [status] => pending\n [retries] => 255\n)\n, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000)[ Tue May 22 12:18:42.311921 2018] [:error] [pid 1449] [client 207.154.197.212: 54660] action_wallets_transaction Last DB error: Duplicate entry ‘568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214’ for key ‘uq_tx_idx’, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000](https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000)[ Tue May 22 13:38:41.387791 2018] [:error] [pid 7192] [client 207.154.197.212: 46156] WordPress database error BIGINT UNSIGNED value is out of range in ‘(`eotwallet_wordpress`.` wp_wallets_txs`.`retries` – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\ twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘pending’,\n\t\t\t\t\ t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 766363\n\t\ t\t\t\t\t made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\ _CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection- >query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996312.6995460987091064453125](https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996312.6995460987091064453125)[ Tue May 22 13:38:42.210531 2018] [:error] [pid 8032] [client 207.154.197.212: 46042] WordPress database error BIGINT UNSIGNED value is out of range in ‘(`eotwallet_wordpress`.` wp_wallets_txs`.`retries` – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\ twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘failed’,\n\t\t\t\t\ t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 766363\n\t\ t\t\t\t\t made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\ _CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection- >query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996311.9633519649505615234375](https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996311.9633519649505615234375)[ Tue May 22 13:38:43.140770 2018] [:error] [pid 7327] [client 207.154.197.212: 46352] WordPress database error BIGINT UNSIGNED value is out of range in ‘(`eotwallet_wordpress`.` wp_wallets_txs`.`retries` – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\ twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘failed’,\n\t\t\t\t\ t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 766363\n\t\ t\t\t\t\t made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\ _CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection- >query, W3TC\\DbCache_Wpdb->default_query, referer: [https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996313.4660971164703369140625](https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996313.4660971164703369140625) Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/users/eotwallet/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/eotwallet/replies/page/2/?output_format=md)