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
