database error – too many keys wppa

Resolved my own problem – its apparently a jquery conflict between the WPPA plugin and wordpress. Installing https://www.ads-software.com/plugins/use-google-libraries/ solves the problem.

That error comes up when a plugin is not using dbDelta properly when defining keys in custom tables.

See: https://www.charlestonsw.com/wordpress-dbdelta-too-many-keys-specified/

@ Charleston

Thank you very much for finally unvealing this mystery to me.

I read your explanation. You recommend NOT to specify a key length:

Do not add field lengths to the keys.

but that gives the following error:

WordPress database error: [BLOB/TEXT column ‘slug’ used in key specification without a key length]
ALTER TABLE wp_wppa_index ADD KEY slug (slug)

for the following table spec:

//
	$create_index = "CREATE TABLE " . WPPA_INDEX . " (
					id bigint(20) NOT NULL,
					slug tinytext NOT NULL,
					albums text NOT NULL,
					photos text NOT NULL,
					PRIMARY KEY  (id),
					KEY slug (slug)
					) DEFAULT CHARACTER SET utf8;";

while the following works and does not generate superfluous keys when dbDelta is run during each update:

//
	$create_index = "CREATE TABLE " . WPPA_INDEX . " (
					id bigint(20) NOT NULL,
					slug tinytext NOT NULL,
					albums text NOT NULL,
					photos text NOT NULL,
					PRIMARY KEY  (id),
					KEY slug (slug(20))
					) DEFAULT CHARACTER SET utf8;";