WordPress.org

Forums

NextGEN Gallery : Tables could not created, please check your database settings (10 posts)

  1. ring69
    Member
    Posted 5 years ago #

    I'm getting this message "NextGEN Gallery : Tables could not created, please check your database settings" and I can't figure out what is wrong.

    Do I have to change some wordpress/NextGen settings or my server settings from cPanel?

    I'm using WP 2.8.3 and NextGen 1.3.5

  2. paulatreides250
    Member
    Posted 5 years ago #

    i have the same problem, my definied charset in wp-config is iso-8859-1

  3. dustyhawk
    Member
    Posted 5 years ago #

    having the same issue as above. using 2.8.4 with nGen 1.3.5

  4. bjornsennbrink
    Member
    Posted 5 years ago #

    Check that the database user has all the rights to create new tables and the like.

    I had the same problem and my solution solved this issue.

  5. The J
    Member
    Posted 5 years ago #

    I just got this error message witha fresh install of NextGen 1.5.0 on WP 2.9.2
    Of course my db user has ALL privileges.
    The prefix of my tables is standard wp_
    The tables are NOT created at all...

    I dont understand where the error comes from. I have updated other wp sites with this new release, and none of them had issues.

    Anyone?

  6. Zelos
    Member
    Posted 4 years ago #

    I have the same problem. using 3.0

  7. fasten
    Member
    Posted 4 years ago #

    Hi,

    I had the exact same problem and here's how I fixed it:

    - rename tables to match the "wp_" pattern : my tables were matching another pattern Next Gen Gallery don't understand for some reason. I tried the SQL insert code WITHOUT previously renaming the tables and it didn't work. But you can try.
    - don't forget to change the wp-config.php file (change whatever prefix you had to $table_prefix = 'wp_';)
    - I converted the whole DB to UTF-8 - I can't say if it had any impact at the end.
    - disable the extension
    - insert manually (phpmyadmin if you want) the code found on the "install" script (nextgen-gallery/admin/install.php) : it differs from version to version, so here's the SQL code for the 1.5.5 version :

    CREATE TABLE wp_ngg_gallery (
    		gid BIGINT(20) NOT NULL AUTO_INCREMENT ,
    		name VARCHAR(255) NOT NULL ,
    		path MEDIUMTEXT NULL ,
    		title MEDIUMTEXT NULL ,
    		galdesc MEDIUMTEXT NULL ,
    		pageid BIGINT(20) DEFAULT '0' NOT NULL ,
    		previewpic BIGINT(20) DEFAULT '0' NOT NULL ,
    		author BIGINT(20) DEFAULT '0' NOT NULL  ,
    		PRIMARY KEY gid (gid)
    		);
    
    CREATE TABLE wp_ngg_album (
    		id BIGINT(20) NOT NULL AUTO_INCREMENT ,
    		name VARCHAR(255) NOT NULL ,
    		previewpic BIGINT(20) DEFAULT '0' NOT NULL ,
    		albumdesc MEDIUMTEXT NULL ,
    		sortorder LONGTEXT NOT NULL,
    		pageid BIGINT(20) DEFAULT '0' NOT NULL,
    		PRIMARY KEY id (id)
    		);
    CREATE TABLE wp_ngg_pictures (
    		pid BIGINT(20) NOT NULL AUTO_INCREMENT ,
    		post_id BIGINT(20) DEFAULT '0' NOT NULL ,
    		galleryid BIGINT(20) DEFAULT '0' NOT NULL ,
    		filename VARCHAR(255) NOT NULL ,
    		description MEDIUMTEXT NULL ,
    		alttext MEDIUMTEXT NULL ,
    		imagedate DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    		exclude TINYINT NULL DEFAULT '0' ,
    		sortorder BIGINT(20) DEFAULT '0' NOT NULL ,
    		meta_data LONGTEXT,
    		PRIMARY KEY pid (pid),
    		KEY post_id (post_id)
    		);

    - enable the extension: error is gone !

    Cheers,
    Stef

  8. michaeldmccarthy
    Member
    Posted 4 years ago #

    I am a bit of a noob, Stef, can you explain this in some simpler terms by any chance? :-)

  9. michaeldmccarthy
    Member
    Posted 4 years ago #

    yeah, just tried but have no idea - got a critical error message upon re-activation. I hope Alex Rabe gets to see this and perhaps offer some help:-)

  10. Laura Nuttall
    Member
    Posted 4 years ago #

    Hello, I'm a complete noob too and have no idea how to fix this error! If someone, anyone PLEEEASE could tell me in simple baby terms how to fix this I'll be eternally grateful. All I want is a decent gallery to show my artwork, I have no idea about databases etc and am completely lost!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.