search

plegall / Piwigo-community

11 stars 24 forks source link

RECURSIVE is a reserved word in MariaDB #36

Closed nicubuga closed 6 years ago

nicubuga commented 6 years ago

Hi, can u tell me what's wrong?

screenshot from 2018-02-14 16-14-28

nicubuga commented 6 years ago

Linux Fedora 27, PHP 7.1.14, MariaDB 10.2.12 , Apache 2.4.29 , nginx 1.12.1, suport SSL, mod rewrite, ionCube encoder, curl, GD

tipsynurse commented 6 years ago

This is just because RECURSIVE is a reserved word in MariaDB. It can be fixed by putting back ticks around "recursive" in the installation code.

If you don't fancy diving in there you can just run the query below in phyMyAdmin or similar which will create the table in advance and (with a bit of complaining) get the plugin installed.

(Well helpfully githib won't let you post back ticks because it indicates code... but you put backticks round "recursive" on line 8.)

CREATE TABLE IF NOT EXISTS piwi90_community_permissions ( id int(11) NOT NULL AUTO_INCREMENT, type varchar(255) NOT NULL, group_id smallint(5) unsigned DEFAULT NULL, user_id mediumint(8) unsigned DEFAULT NULL, category_id smallint(5) unsigned DEFAULT NULL, user_album enum('true','false') NOT NULL DEFAULT 'false', recursive enum('true','false') NOT NULL DEFAULT 'true', create_subcategories enum('true','false') NOT NULL DEFAULT 'false', moderated enum('true','false') NOT NULL DEFAULT 'true', nb_photos int DEFAULT NULL, storage int DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;