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

Ok, dig deeper into the MySQL settings and found out that this could be a real issue if you define a prefix with Case sensitive letters, the check will fail :

https://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html

Here is the patch for this case :

https://code.google.com/p/nextgen-gallery/source/detail?r=823

@odassis
Thanks for the hint, now I can reproduce it in the same way here.

Thanks for this great plugin.

Thanks for the fix ??

Thanks guys,
All work fine now ??

Thanks for your feedback, I reworked the check a little bit, but it should do the same :

https://code.google.com/p/nextgen-gallery/source/detail?r=824

hello,

just for the records, I solved this issue by setting Auto-activating on and Mass activate

these options are available through Plugin commander mod and I’m running in network mode

hope will help,
regards

Nope…the fix didn’t fix it…at least not for me…

Lemme just check if I get it right. Updating “install.php” and “upgrade.php” to latest versions (the ones that u declare here) should do it…right? I’ve done so, but still get the “Tables could not created, please check your database settings”-error. Am I missing something here? Am I supposed to do something else?

Thanks!

…eager to get this plugin to work as it seems like a VERY nice one! ??

I also updated install.php and upgrade.php with a patch I generated from r824, and tried the table upgrade again. Like Darth NiN, I got the same message – “Tables could not created, please check your database settings”.

We’re using this plugin on a large number of WordPress sites and they all need to be upgraded…

Hi,

I am having a similar issue on multisite. NextGEN works fine on the main site and on any sub-sites that existed when the plugin was installed.

But, on any newly-created site (with NextGEN set to activate automatically, via a plugin manager), users get:

“Please update the database of NextGEN Gallery. Click here to proceed.”

They “click here” and nothing happens. There is no error message of any kind.

I had originally used a mixed-case table prefix. But, I have since created an entirely new installation with only lower-case letters. And I still experience this.

Please help if you can!

Thanks!!!

Mark

This topic describe a problem which happend when you use a mixed-case table prefix in a single setup (not multisite !)

If you still have problems AND a multisite setup, please open a new thread as it’s not related to this request. Thanks

Simple and easy fix
https://www.ads-software.com/support/topic/nextgen-gallery-tables-could-not-created-fixed?replies=1#post-1777917

Thanks for the fix, replacing the install.php and the upgrade.php files did the trick. I ran the upgrade but still received an error about the tables not being created. So I deactivated and re-activated the plugin and everything is working.

judahstevenson,

please, could you send me your install.php and upgrade.php? I need fix it surely

Thank′s a lot ??

I tried same as “judahstevenson” and it ran!

Thanks for fix guys, I′m happy! ??