dashed-slug.net › Forums › General discussion › Table wallet bdd
- This topic has 12 replies, 3 voices, and was last updated 6 years, 9 months ago by
alexg.
-
AuthorPosts
-
September 30, 2017 at 10:49 pm #1843
Anonymous
InactiveHello,
After a bad manipulation on my part, I no longer have the two tables of the plugin “Bitcoin and Altcoin Wallets” in my database.
Would it be possible to send me SQL queries, that I can manually re-inject them?
I try to reinstall the plugin, but the tables do not want to automatically reset, so I get an error message during installation.
————————————————– ————————————————– ———–
Bitcoin and Altcoin Wallets errorBitcoin and Altcoin Wallets could NOT create a transaction “wp_wallets_txs” in the database. The plugin may not function properly.
————————————————– ————————————————– ———–Thanks in advance for support.
Cordially.
October 1, 2017 at 6:17 am #1844alexg
KeymasterHello,
I could send you the schema in SQL, but it is safer if you do the following:
1. Delete the
wp_wallets_revision
option from the DB:DELETE FROM wp_options WHERE option_name = 'wallets_db_revision';
Make sure to replace
wp_
with whatever prefix your DB is using.2. After deleting the option, deactivate the plugin and reactivate it.
I will make a note to make the uninstall script delete the DB revision so that in the future a simple deactivate/reactivate cycle will repair the schema without manual intervention. This will be rolled out in the next release.
Let me know how it goes.
regards,
AlexOctober 1, 2017 at 11:58 am #1845Anonymous
InactiveThanks for your support/reply, it’s ok for me.
cordially
November 9, 2017 at 11:04 pm #2052Anonymous
Inactivesame messages after installing and activating
Bitcoin and Altcoin Wallets could NOT create a transactions table “wp_wallets_txs” in the database. The plugin may not function properly.
what is wrong ? how to fix? tried several times, deleting … also executing sql line and reinstalling …
did not helpedNovember 10, 2017 at 8:01 am #2053alexg
KeymasterHello,
A few people have reported this issue in the last couple of days but I was unable to reproduce the problem in a number of setups.
Is it possible for you to enable logs and send me whatever gets written out while you activate the plugin? Instructions for enabling logs are here: https://codex.wordpress.org/Debugging_in_WordPress This will help me know what’s wrong and what to fix.
Alternatively you can use the following SQL code in your console, to create the tables manually.
The above code assumes that your DB prefix is
wp_
. If it is something else, you will need to replace the table names.November 11, 2017 at 3:28 am #2059Anonymous
InactiveI think the problem is here
MySQL said: Documentation
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’may be if I change it to utf8mb4_unicode_ci will work … , (I will check tomorrow it is too late now)
November 11, 2017 at 3:56 am #2060Anonymous
InactiveP.S. I know … I need mysql 5.6 but unfortunately there is no 5.6 for my distro
may be will compile one in the future …
$ mysql –version
mysql Ver 14.14 Distrib 5.5.58, for debian-linux-gnu (armv7l) using readline 6.3but this still does not explain why I was not able to install the plugin 🙁 , or explain ?
November 11, 2017 at 8:06 am #2061alexg
KeymasterI have not yet found the reason why the plugin did not work to begin with.
The SQL I sent you was exported from my machine. Most of the collation and charset directives are not needed. Only the ones that refer to the latin1 charset. You should be OK with MySQL 5.5. I have edited the SQL code and removed any unnecessary charsets. Your system should now use whatever is default for the columns where it doesn’t matter.
So please do another attempt. Use the same pastebin link. I have edited it.
November 19, 2017 at 1:06 am #2080Anonymous
InactiveHello,
After installing this new version, I also have this table problem that does not install …
I left as agreed on the test of withdrawal via tor, but I remain blocked on this problem.Bitcoin and Altcoin Wallets could NOT create a transactions table “wallets_txs” in the database. The plugin may not function properly.
Tomorrow I will try to make a transaction to see if an error message appears.
November 19, 2017 at 1:07 am #2081Anonymous
InactivePS :
Server type: MySQL
Server version: 5.6.38 – MySQL Community Server (GPL)November 19, 2017 at 7:43 am #2082alexg
KeymasterHello,
If the table is not created correctly you will definitely not be able to perform transactions. This is why the plugin is warning you.
This is an issue that was fixed in a past release. I assume you have already checked that you are installing the latest version.
If that’s the case, I recommend that you drop the two tables and reinstall, this time taking note of any errors in the logs. That’s the only way to know what went wrong. The plugin has been tested with PHP 5.6 and it should work.
Do let me know what you find.
regards
November 19, 2017 at 10:41 am #2083alexg
KeymasterFollowing up from my previous post, I believe I have isolated the issue:
Due to an error on my part, if the tables do not exist the plugin does not create them immediately on activation, but after the first run/request. I will fix this.
If you only saw the error once and no more then that means that the tables are created now and you can proceed.
If the error persists, deleting the
wallets_db_revision
option will do the trick.
With SQL:DELETE FROM wp_options where option_name = 'wallets_db_revision';
Or with cp-cli:wp option delete wallets_db_revision
.Refresh your WordPress and your tables should be created.
Or simply wait until the next patch.
Apologies for the confusion.
regards
November 21, 2017 at 11:48 am #2093alexg
KeymasterThe missing tables issue is now slved in 2.10.0
-
AuthorPosts
- You must be logged in to reply to this topic.