@champ1on you should give user ‘w119678_clubsez’@’10.28.16.109’ rights to drop table wp_t_computed_variables.
In mysql as root run this: GRANT DROP ON wp_t_computed_variables TO 'w119678_clubsez'@'10.28.16.109';
I do not know what it means. I can only backup the database.
Chyba
SQL dotaz:
GRANT DROP ON wp_t_computed_variables TO ‘w119678_clubsez’@’10.28.16.109’
MySQL hlásí:
#1142 – DROP, GRANT command denied to user ‘w119678_clubsez’@’10.28.20.28’ for table ‘wp_t_computed_variables’
@champ1on you need to run it under more powerful user. Not under user, to which you want give more rights. Use phpmyadmin or what your hosting offer and user like root for example.
Chyba
SQL dotaz:
GRANT DROP ON wp_t_computed_variables TO ‘w119678_clubsez’@’10.28.16.109’
MySQL hlásí:
#1142 – GRANT command denied to user ‘a119678_clubsez’@’10.28.20.28’ for table ‘wp_t_computed_variables’
—–
I do not get it.
I do not know what you want me to do. I do not even know how to ask technical support.
-
This reply was modified 6 years, 7 months ago by
champ1on.
I do not even know how to ask technical support.
Then you are stuck.
I do not get it.
You are trying to give rights to user w119678_clubsez, but you execute those commands under those user.
The hosts told me that GRANT orders are forbidden globally.
So fix the plugin.
The plugin can not be activated because it caused a serious error.
@champ1on, I suggest you to change hoster. As only you as site owner should have all rights to operate your site’s data.
Let’s try manual fix.
Through plugin editor find this file and change at line 17 $options += array('force' => true); to $options += array('force' => false);.
See https://github.com/garex/wp-testing/blob/247a075f5f821be233e60397b8c1c8ee8b76d027/db/migrations/wp_testing/Base/TableDefinition.php#L17
I fixed the file on line 17
The plugin can not be activated because it caused a serious error.
Fatal error: Uncaught Migrate.php(259) : WpTesting_Migration_AddComputedVariablesTable – Error executing ‘query’ with: CREATE TABLE wp_t_computed_variables ( computed_variable_id bigint UNSIGNED auto_increment NOT NULL, test_id bigint UNSIGNED NOT NULL, computed_variable_name varchar(190) NOT NULL, computed_variable_source text NOT NULL, computed_variable_sort int(11) DEFAULT 100 NOT NULL, PRIMARY KEY (computed_variable_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8; Reason: CREATE command denied to user ‘w119678_clubsez’@’10.28.16.109’ for table ‘wp_t_computed_variables’ thrown in /data/web/virtuals/119678/virtual/www/domains/clubseznamka.cz/wp-content/plugins/wp-testing/vendor/ruckusing/ruckusing-migrations/lib/Task/Db/Migrate.php on line 259
@champ1on now it’s clearly issue with your hosting or site settings. Plugin already creates many tables and in your current settings it just can’t be activated from start.
I suggest you to choose more adequate hosting provider, that will not play with your DB rights.
