Database error

@vilican – Does your WordPress database user (this use is not related to any WordPress User account) have *ALL* privileges with the WordPress database?

– Cais.

What privileges a exactly required to do this?
The user can do this: select, insert, update, delete, create_tmp_table, lock_tables, execute

@vilican – The simplest measure is to select the “ALL” option for the database user but at a glance you should also have the “ALTER” privilege available.

– Cais.

I changed the wp-config.php file to use MySQL user with *ALL* privileges.
Then, I reinstalled this plugin. However, the problem still appears.

Is there any “debug” mode which would show me raw error?

Example of raw error what I want to get:
Access denied for user ‘someone’@’somepc’ [Using password: YES]

@vilican – You can try looking at the server error_logs file(s), and you may need to go deeper into your server configuration file than adding a line to the wp-config.php file.

Thanks!

– Cais.

What line to wp-config.php should I add?

@vilican – You noted, “I changed the wp-config.php file to use MySQL user with *ALL* privileges.” This may not have taken effect … this is why I suggested working with your web host to ensure those privileges are set.

Thanks!

– Cais.

I am on a shared webhosting, not a dedicated or virtual server. I do not have access to these settings. The only clue what I can have is the MySQL error. The best for this is to try to commit the operation, print result and die. However, this is not my system nor plugin, so I do not have any knowledge about code and thus I cannot easily do it – that′s why I am trying to write somebody who has.

@vilican – Try contacting your web hosting service to have them verify the settings and privileges of your WordPress database user. Although many shared hosting services provide access to the database directly obviously not all do, in these cases your web host will have to do this for you.

Thanks!

– Cais.

The webhosting company claims that the admin user, which is in use now, has all rights for the database.

This colud help also you:
sw: MySQL
ver sw: 5.6.23 – Source distribution
protocol ver.: 10
php extension: mysqli

@vilican – The WordPress database user and the WordPress Admin (account) user are generally not the same thing (it’s actually a bad idea for them to be the same from a security perspective).

– Cais.

Sorry, that is misunderstanding. The webhosting company gives me two users for one database: web and admin for MySQL. I meant the MySQL admin user. Not WP user. And yes, there are different passwords on all three of them.

@vilican – Although the only cause we have ever seen for this issue is not having the necessary privileges for the database user there could be a plugin conflict going on here or at least it should be ruled out. Have you tried deactivating all of your plugins, clearing your browser cache (and site caches if you are using a caching plugin), then reactivating the NextGEN plugin?

If this fixes the problem then it was likely one of the deactivated plugins that was causing an issue. Now, retrace your steps activating each plugin and re-checking to see if the problem returns. If it does then that last activated plugin was probably the one. Keep reactivating and in most cases it is also best to keep checking after each plugin, sometimes there may be more than one plugin on a site that will create an issue. If you do find one (or more) plugins causing this problem we would greatly appreciate your feedback on them so the developers may address them as soon as they can.

Also to note, in rare cases it may be the theme itself that is causing a conflict so while you have just the NextGEN plugin activated you might consider temporarily switching to one of the default WordPress Twenty series themes and see if this corrects the issue as well.

If the problem still persists after all of this we would still want to know, even more so, as we will still want to sort out the issue and may need additional details.

Thanks!

– Cais.

The problem persists even after disabling all plugins.
Since I have now a free server, I will try to make the smallest possible situation with this error where I can give you access to.

Also one more thing: could you send me the MySQL query which is the plugin trying to run in order to create tables? Maybe is an error there.