fasten

Same issue here with WP 5.3.2 and Mailjet plugin version 5.2.1

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