DariusKM

IestynR, in my case none of the above worked unfortunately, except the hacky bit.

I would suggest try commenting out the below code in nextgen-gallery instal.php and see if it works for you too.

// check one table again, to be sure
    if($wpdb->get_var("show tables like '$nggpictures'")!= $nggpictures) {
        update_option( "ngg_init_check", __('NextGEN Gallery : Tables could not created, please check your database settings',"nggallery") );
        return;
    }

You can find this code in:

wp-content / plugins / nextgen-gallery / admin / install.php

I am sure this is not the best way to tackle this issue and hopefully alexrabe or another expert would come up with a proper solution.

Best,
Darius.

Thanks for the reply Alex,

Here is what I did based on your suggestion:

• Deactivated the plugin on both sites.
• Manually created 3 database tables, with wp_ prefix based on the code in install.php for version 1.6.2 as follow:

  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)
          );

• after tables were successfully created, activated the plugin on my local.site.v2 but still experiencing the exact same issue.
• Next, i tried to find the code that leads to “Please update the database of NextGEN Gallery… ” error.
• Found the code in install.php as follow and commented it out (out of curiosity 😉

  // check one table again, to be sure
      if($wpdb->get_var("show tables like '$nggpictures'")!= $nggpictures) {
          update_option( "ngg_init_check", __('NextGEN Gallery : Tables could not created, please check your database settings',"nggallery") );
          return;
      }

• …And the plugin works! 🙂
• I deleted the new tables with wp_ prefix, and the plugin still works!

Alex, thanks for the reply and most importantly thanks for writing such wonderful plugin.

I am new to weordpress and php and I am already enjoying it very much 🙂

Experiencing the same issue.

I’m using WordPress version 3.0.1, and NextGEN 1.6.0

Couldn’t find any solid answer to this so far 🙁

Any thoughts would be appreciated
Thanks,
Darius.