I reply to all queries on the forums and via email, once per day, Monday to Friday (not weekends).

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

Reply To: problem when installing the wallet

dashed-slug.net Forums General discussion problem when installing the wallet Reply To: problem when installing the wallet

#2954
alexg
Keymaster

Thank you very much. Your version is recent.

Can you try the following and tell me if it works please?

CREATE TABLE wp_wallets_adds (
	id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	blog_id bigint(20) NOT NULL DEFAULT '1' COMMENT 'blog_id for multisite installs',
	account bigint(20) UNSIGNED NOT NULL COMMENT 'wp_users.ID',
	symbol varchar(5) COLLATE latin1_bin NOT NULL COMMENT 'coin symbol (e.g. BTC for Bitcoin)',
	address varchar(255) COLLATE latin1_bin NOT NULL,
	extra varchar(255) COLLATE latin1_bin NOT NULL DEFAULT '' COMMENT 'extra info required by some coins such as XMR',
	created_time datetime NOT NULL COMMENT 'when address was requested in GMT',
	status enum('old','current') NOT NULL COMMENT 'all addresses are used to perform deposits, but only the current one is displayed',
	PRIMARY KEY (id),
	INDEX retrieve_idx (account,symbol),
	INDEX lookup_idx (address),
	UNIQUE KEY 'uq_ad_idx' ('address', 'symbol', 'extra')
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

If this works I will add the fix to the next version of wallets. Some versions of MySQL seems to have a problem with defining default values for enum columns explicitly.

Looking forward to your reply.

regards