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

1 Comment

Have you seen the following error when trying to install NextGEN Gallery, FLAGallery or a similar gallery?

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

For my particular situation, it works like this…

  • I only have issues with sites that were created prior to a MySQL version update
  • Those particular databases are encoded – (‘DB_CHARSET’, ‘latin1’)
  • I have set this value above in my config file or…when set as (‘DB_CHARSET’, ‘utf8’)…I get special characters appearing throughout my existing content
  • That said, when I change my config file to (‘DB_CHARSET’, ‘utf8’) I am able to install the gallery without issue
  • Once installed I change back to (‘DB_CHARSET’, ‘latin1’) and everything works fine
1 Comment
    • Mary
    • January 18, 2011

    It worked!!! I was working on for 2 weeks…
    Thanks a lot~~~~

Leave a Comment

Categories

A Little About Me

I am a business consultant with a ton of digital experience. I help companies achieve success with a focus on technology and the Web.

Request a callback

I'd be more than happy to discuss your project to see how I can help!

More from my blog

See all posts