NextGEN Gallery : Tables could not created, please check your database settings

Hmm. Having the same problem.

I’ve used nextgen on several sites with no problem. I’m not sure what I did wrong here. I’m using the most recent version with simple install and activation and I get the error.

I am not comfortable messing with Please install.php nor config. Is there a problem with 1.6.2 or did I just mess up somehow?

OK. I’ve spent many hours reading posts on this issue and trying several suggestion fixes to no avail.

This is a new nextgen gallery install so no previous galleries or tables to worry about. This is a new (and very limited) site.

Can someone please post step by step instructions for a fix when you get this error on a new install on a new site? I’ve used nextgen on several other sites with no problem. I would really like to be able to use it on this site as well.

Thanks in advance!!

Try the v1.7.0 beta, it include all fixes

Alex,

I’m still getting “Please update the database of NextGEN Gallery. Click here to proceed.” when I activate the plugin. I assume there is something there in the database from the previous version. Any ideas?

I have deactivated and deleted the entire plugin. Checked the database to delete the associated tables and they weren’t there. I then re-uploaded the new “beta” version of the plugin, activated it and still got the same error. I then verified that there again were no database tables created.

Does anyone know what my cause such a thing? Or better yet…. what I can do about it?

Please!

Ok, these annoying thing is actual even now, few months after it started.

So, I got nextgen gallery working by patching install.php and upgrade.php files, as mentioned above, by revision 824. It didn’t helped, so in addition, I created 3 mysql tables as “DariusKM” writed.

PS. WP 3.0.2 NextGen 1.6.2

I’ve just tried the latest version of the Plug-in, and I’m getting the same problem.

Have you got any other suggestions as to what could be the problem Alex? I’m using WordPress V 3.1 and NextGen 1.7.4.

It’s still displaying the same message as I first tried. Is there any way for me to post my file somewhere for you to have a look at what’s going? This plug-in looks super awesome and I’d love for it to work on my blog.

Thanks.

I’ve tried everything possible, but I’m still getting the same error message.

Anyone else still having the same issues?

I am also having the same problem with WordPress 3.1 and NextGen 1.7.4.

I also had same problem with different environments, but they are all now working.

My environments that I tested are:
WP 3.0.5 + mysql 5.0.91-community-log + NextGen 1.7.4
WP 3.1 + mysql 5.0.91-community-log + NextGen 1.7.4
WP 3.1 + mysql 5.5.8-log + NextGen 1.7.4

My solution is to change both DB_CHARSET and DB_COLLATE in wp-config.php:

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Previously it was:

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8_unicode_ci');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', 'utf8_unicode_ci');

Hope this works for you…

My DB_CHARSET and DB_COLLATE had those values already and it does not work.