Bitcoin and Altcoin Wallets error

Can anybody give me a fix or point me in the right direction?

Hello,

The plugin creates a couple of custom tables on your DB. The message indicates that the DB indexes were not created correctly.

I would like to know the following:

1. Is this a new installation or are you upgrading from a previous version?

2. What is the result of SELECT VERSION(); on your SQL console?

3. If possible, you should check your SQL error log. This is where the errors would show.

kind regards
Alex

Hello:

Q1:
New installation
Q2:
+ Options
VERSION()
10.1.31-MariaDB-cll-lve
Q3:
[30-Aug-2018 21:12:57 UTC] WordPress database error Table ‘checstfb_wp186.wpeb_wallets_txs’ doesn’t exist for query
UPDATE
wpeb_wallets_txs
SET
status = ‘failed’,
updated_time = ‘2018-08-30 21:12:57’
WHERE
( blog_id = 1 || 0 ) AND
status = ‘pending’ AND
category IN ( ‘withdraw’, ‘move’ ) AND
retries < 1
made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->fail_transactions
[30-Aug-2018 21:12:57 UTC] WordPress database error Table ‘checstfb_wp186.wpeb_wallets_txs’ doesn’t exist for query
LOCK TABLES
wpeb_wallets_txs WRITE,
wpeb_options WRITE,
wpeb_wallets_adds READ,
wpeb_users READ,
wpeb_usermeta READ
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_moves
[30-Aug-2018 21:12:57 UTC] WordPress database error Table ‘checstfb_wp186.wpeb_wallets_txs’ doesn’t exist for query
SELECT
*
FROM
wpeb_wallets_txs
WHERE
( blog_id = 1 || 0 ) AND
category = ‘move’ AND
status = ‘pending’ AND
retries > 0 AND
amount < 0
ORDER BY
created_time ASC
LIMIT
8
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_moves
[30-Aug-2018 21:12:57 UTC] WordPress database error Table ‘checstfb_wp186.wpeb_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpeb_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[30-Aug-2018 21:12:57 UTC] confirm_transactions: Failed to update unconfirmed withdrawals.
[30-Aug-2018 21:12:57 UTC] WordPress database error Table ‘checstfb_wp186.wpeb_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpeb_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[30-Aug-2018 21:12:57 UTC] confirm_transactions: Failed to update unconfirmed moves between users.
[30-Aug-2018 21:17:54 UTC] WordPress database error Table ‘checstfb_wp186.wpeb_wallets_txs’ doesn’t exist for query

Rgds,

Ralph

Hi Ralph,

Thanks for all your feedback.

After some quick tests I am not able to reproduce the problem you report on my system. I would therefore like to ask you for one more thing:

The errors you pasted above are a direct result of the tables not having been created. It would be more useful to me if you could spot any errors arising from CREATE TABLE statements.

Could you please search these same logs for the string CREATE TABLE and send me an example of the errors arising from that statement?

thank you very much for your help

kind regards

I have now deleted the theme, wordpress installation and re-installed all.
Your plugin is the only one to be installed (via wordress) and the error is exactly the same:

UPDATE
wpdp_wallets_txs
SET
status = ‘failed’,
updated_time = ‘2018-09-01 12:16:18’
WHERE
( blog_id = 1 || 0 ) AND
status = ‘pending’ AND
category IN ( ‘withdraw’, ‘move’ ) AND
retries < 1
made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->fail_transactions
[01-Sep-2018 12:16:18 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
LOCK TABLES
wpdp_wallets_txs WRITE,
wpdp_options WRITE,
wpdp_wallets_adds READ,
wpdp_users READ,
wpdp_usermeta READ
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_moves
[01-Sep-2018 12:16:18 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
SELECT
*
FROM
wpdp_wallets_txs
WHERE
( blog_id = 1 || 0 ) AND
category = ‘move’ AND
status = ‘pending’ AND
retries > 0 AND
amount < 0
ORDER BY
created_time ASC
LIMIT
8
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_moves
[01-Sep-2018 12:16:18 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpdp_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[01-Sep-2018 12:16:18 UTC] confirm_transactions: Failed to update unconfirmed withdrawals.
[01-Sep-2018 12:16:18 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpdp_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[01-Sep-2018 12:16:18 UTC] confirm_transactions: Failed to update unconfirmed moves between users.
[01-Sep-2018 12:21:40 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
UPDATE
wpdp_wallets_txs
SET
status = ‘failed’,
updated_time = ‘2018-09-01 12:21:40’
WHERE
( blog_id = 1 || 0 ) AND
status = ‘pending’ AND
category IN ( ‘withdraw’, ‘move’ ) AND
retries < 1
made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->fail_transactions
[01-Sep-2018 12:21:40 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
LOCK TABLES
wpdp_wallets_txs WRITE,
wpdp_options WRITE,
wpdp_wallets_adds READ,
wpdp_users READ,
wpdp_usermeta READ
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_moves
[01-Sep-2018 12:21:40 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
SELECT
*
FROM
wpdp_wallets_txs
WHERE
( blog_id = 1 || 0 ) AND
category = ‘move’ AND
status = ‘pending’ AND
retries > 0 AND
amount < 0
ORDER BY
created_time ASC
LIMIT
8
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_moves
[01-Sep-2018 12:21:40 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpdp_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[01-Sep-2018 12:21:40 UTC] confirm_transactions: Failed to update unconfirmed withdrawals.
[01-Sep-2018 12:21:40 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpdp_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[01-Sep-2018 12:21:40 UTC] confirm_transactions: Failed to update unconfirmed moves between users.
[01-Sep-2018 12:53:14 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
UPDATE
wpdp_wallets_txs
SET
status = ‘failed’,
updated_time = ‘2018-09-01 12:53:14’
WHERE
( blog_id = 1 || 0 ) AND
status = ‘pending’ AND
category IN ( ‘withdraw’, ‘move’ ) AND
retries < 1
made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->fail_transactions
[01-Sep-2018 12:53:14 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
LOCK TABLES
wpdp_wallets_txs WRITE,
wpdp_options WRITE,
wpdp_wallets_adds READ,
wpdp_users READ,
wpdp_usermeta READ
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_moves
[01-Sep-2018 12:53:14 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query
SELECT
*
FROM
wpdp_wallets_txs
WHERE
( blog_id = 1 || 0 ) AND
category = ‘move’ AND
status = ‘pending’ AND
retries > 0 AND
amount < 0
ORDER BY
created_time ASC
LIMIT
8
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_moves
[01-Sep-2018 12:53:14 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpdp_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[01-Sep-2018 12:53:14 UTC] confirm_transactions: Failed to update unconfirmed withdrawals.
[01-Sep-2018 12:53:14 UTC] WordPress database error Table ‘checstfb_wp160.wpdp_wallets_txs’ doesn’t exist for query SHOW FULL COLUMNS FROM wpdp_wallets_txs made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Confirmations->cron, Dashed_Slug_Wallets_Confirmations->confirm_transactions
[01-Sep-2018 12:53:14 UTC] confirm_transactions: Failed to update unconfirmed moves between users.

Hello again,

The errors you posted are the same as before. Please see my earlier comment about the CREATE TABLE statement. Were you able to find any such errors in your logs? They would have been produced the first time you install the plugin. If you need to try again, deactivate and uninstall the plugin, then install and activate it again. At the time of activation the CREATE TABLE statements should fail with some error.

kind regards

I didn′t find anything in the logs. Various install, activate and deactivate. As site not live, I can give out an admin login.

It is not very likely that I would be able to help you if I login to your WordPress admin screens as this is an SQL problem.

Instead, I would recommend that you log on to your SQL console (e.g. via phpmyadmin), and attempt to create the tables manually. Simply enter the following two queries. Normally these should create the necessary tables. If you get any errors, please report them to me.

SQL CREATE TABLE statements (for DB prefix wpdb):

https://pastebin.com/DC3SYS5E

Sorry;

but:

Error
Static analysis:

4 errors were found during analysis.

A comma or a closing bracket was expected. (near “signed” at position 962)
Unexpected beginning of statement. (near “20” at position 1045)
Unexpected beginning of statement. (near “10” at position 1048)
Unrecognized statement type. (near “signed” at position 1052)
SQL query:

CREATE TABLE wpdb_wallets_txs ( id int(10) unsigned NOT NULL AUTO_INCREMENT, blog_id bigint(20) NOT NULL DEFAULT 1 COMMENT ‘useful in multisite installs only if plugin is not network activated’, category enum(‘deposit’,’move’,’withdraw’,’trade’) NOT NULL COMMENT ‘type of transaction’, tags varchar(255) NOT NULL DEFAULT ” COMMENT ‘space separated list of tags, slugs, etc that further describe the type of transaction’, account bigint(20) unsigned NOT NULL COMMENT ‘wpdb_users.ID’, other_account bigint(20) unsigned DEFAULT NULL COMMENT ‘wpdb_users.ID when category==move’, address varchar(128) NOT NULL DEFAULT ” COMMENT ‘blockchain address when category==deposit or category==withdraw’, extra varchar(128) NOT NULL DEFAULT ” COMMENT ‘extra info required by some coins such as XMR’, txid varchar(128) DEFAULT NULL COMMENT ‘blockchain transaction id’, symbol varchar(8) NOT NULL COMMENT ‘coin symbol (e.g. BTC for Bitcoin)’, amount decimal(20,10) signed NOT NULL COMMENT ‘amount plus any fees deducted from account’, fee decimal(20,10) signed NOT NULL DEFAULT 0 COMMENT ‘fees deducted from account’, comment TEXT DEFAULT NULL COMMENT ‘transaction comment’, created_time datetime NOT NULL COMMENT ‘when transaction was entered into the system in GMT’, updated_time datetime NOT NULL COMMENT ‘when transaction was last updated in GMT (e.g. for update to confirmations count)’, confirmations mediumint unsigned DEFAULT 0 COMMENT ‘amount of confirmations received from blockchain, or null for category IN (move,trade)’, status enum(‘unconfirmed’,’pending’,’done’,’failed’,’cancelled’) NOT NULL DEFAULT ‘unconfirmed’ COMMENT ‘state of transaction’, retries tinyint unsigned NOT NULL DEFAULT 1 COMMENT ‘retries left before a pending transaction status becomes failed’, admin_confirm tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘1 if an admin has confirmed this transaction’, user_confirm tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘1 if the user has confirmed this transaction over email’, nonce char(32) DEFAULT NULL COMMENT ‘nonce for user to confirm via emailed link’, PRIMARY KEY (id), KEY account_idx (account), KEY blogid_idx (blog_id), UNIQUE KEY uq_tx_idx (txid,address,symbol) )

MySQL said: Documentation

#1071 – Specified key was too long; max key length is 1000 bytes

Hello,

Which tool did you use to perform static analysis? Is it specifically for MySQL or generally for SQL?

The code I sent you in pastebin is definitely valid MySQL.

The error you get is because some old versions of MySQL / mariaDB have this restriction and it all depends on your default charset which affects how long the VARCHAR columns are.

You could try entering the following before you paste the CREATE TABLE statements:

SET @@global.innodb_large_prefix = 1;

I will add this to the plugin in the next patch release.

kind regards

Error
SQL query:

SET @@global.innodb_large_prefix = 1
MySQL said: Documentation

#1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation

saludos tengo el mismo problema
Bitcoin and Altcoin Wallets error
Bitcoin and Altcoin Wallets could NOT create a transactions table “wpov_wallets_txs” in the database. The plugin may not function properly.

Bitcoin and Altcoin Wallets error
The plugin may not function properly because at least one DB index was not found on the wpov_wallets_txs table. If this error message persists, please contact support and report this: Array ( ) .

Bitcoin and Altcoin Wallets error
The plugin may not function properly because at least one DB index was not found on the wpov_wallets_adds table. If this error message persists, please contact support and report this: Array ( ) .

Hi

I am having the same issue. Installed and activated and getting the following messages:-

Bitcoin and Altcoin Wallets could NOT create a transactions table “wpte_wallets_txs” in the database. The plugin may not function properly.

The plugin may not function properly because at least one DB index was not found on the wpte_wallets_txs table. If this error message persists, please contact support and report this: Array ( ) .

The plugin may not function properly because at least one DB index was not found on the wpte_wallets_adds table. If this error message persists, please contact support and report this: Array ( ) .

I have followed everything you mentioned above to the other person, but none of it is working. DO you have any other ideas please?

Thanks in advance.

Thank you to all who reported this problem.

The issue is fixed in version 3.6.6.

TL;DR explanation:

All of you are using very ancient versions of MySQL; your hosts should be ashamed! This is not a problem on its own, but since the default charset is set to utf8mb4 to accommodate the full Unicode set, some indexes on large columns go over the limit of 1000 bytes that these old databases had. Previously I had set those columns to the latin1 character set to avoid this problem. But this had caused problems for other people. In any case, the columns are such now that even if these two conditions exist (old database + utf8mb4), the total index length does not exceed 1000 bytes. Transaction IDs now can go up to 120 characters, while Monero addresses do not exceed 106 characters, so this is enough for all coins. I was able to verify with MySQL 5.5 via Docker that the new schema no longer causes error 1071.