Impossible d'installer en MYSQL

J'ai voulu m'installer un site neuf.

  • checkout spip spip-debug.test -> tout est récupéré
  • http://spip-debug.test/ecrire/ -> le processus d'install se lance
  • connexion à la BDD mysql -> pas de souci
  • choix d'une nouvelle base neuf `L’opération a échoué.

Retournez à la page précédente, sélectionnez une autre base ou créez-en une nouvelle. Vérifiez les informations fournies par votre hébergeur.`

COntenu de tmp/mysqlmysql.log

2022-05-27 13:54:15 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/base/create.php L74 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE  TABLE IF NOT EXISTS `spip_debug`.spipdebug_meta (
		nom VARCHAR (255)  NOT NULL,
		valeur text  DEFAULT '',
		impt ENUM('non', 'oui') DEFAULT 'oui' NOT NULL,
		maj TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
		PRIMARY KEY (nom)) ENGINE=MyISAM
2022-05-27 13:54:16 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/base/create.php L83 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE  TABLE IF NOT EXISTS `spip_debug`.spipdebug_meta (
		nom VARCHAR (255)  NOT NULL,
		valeur text  DEFAULT '',
		impt ENUM('non', 'oui') DEFAULT 'oui' NOT NULL,
		maj TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
		PRIMARY KEY (nom)) ENGINE=MyISAM
2022-05-27 13:54:17 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/base/create.php L74 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE  TABLE IF NOT EXISTS `spip_debug`.spipdebug_urls (
		id_parent bigint(21) DEFAULT '0' NOT NULL,
		url VARCHAR(255)  NOT NULL,
		type varchar(25)  DEFAULT 'article' NOT NULL,
		id_objet bigint(21) NOT NULL,
		date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
		segments SMALLINT(3) DEFAULT '1' NOT NULL,
		perma TINYINT(1) DEFAULT '0' NOT NULL,
		langue VARCHAR(10)  DEFAULT '' NOT NULL,
		PRIMARY KEY (id_parent, url),
		KEY type (type, id_objet),
		KEY langue (langue),
		KEY url (url)) ENGINE=MyISAM
2022-05-27 13:54:18 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/base/create.php L83 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE  TABLE IF NOT EXISTS `spip_debug`.spipdebug_urls (
		id_parent bigint(21) DEFAULT '0' NOT NULL,
		url VARCHAR(255)  NOT NULL,
		type varchar(25)  DEFAULT 'article' NOT NULL,
		id_objet bigint(21) NOT NULL,
		date DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
		segments SMALLINT(3) DEFAULT '1' NOT NULL,
		perma TINYINT(1) DEFAULT '0' NOT NULL,
		langue VARCHAR(10)  DEFAULT '' NOT NULL,
		PRIMARY KEY (id_parent, url),
		KEY type (type, id_objet),
		KEY langue (langue),
		KEY url (url)) ENGINE=MyISAM
2022-05-27 13:54:18 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1146 de mysql: Table 'spip_debug.spipdebug_meta' doesn't exist
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/install/etape_3.php L126 [sql_insertq(),install_bases(),install_etape_3_dist(),exec_install_dist()]
INSERT INTO spipdebug_meta (nom,valeur,impt) VALUES ('version_installee','2022022302','non')
2022-05-27 13:54:18 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1146 de mysql: Table 'spip_debug.spipdebug_meta' doesn't exist
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/install/etape_3.php L129 [sql_insertq(),install_bases(),install_etape_3_dist(),exec_install_dist()]
INSERT INTO spipdebug_meta (nom,valeur,impt) VALUES ('nouvelle_install','1','non')
2022-05-27 13:54:18 127.0.0.1 (pid 36465) :Pri:ERREUR: Erreur 1146 de mysql: Table 'spip_debug.spipdebug_meta' doesn't exist
in /home/mrouquet/Sites/dev/spip-debug.test/ecrire/req/mysql.php L1750 [sql_delete(),test_rappel_nom_base_mysql(),install_mode_appel(),install_bases(),install_etape_3_dist(),exec_install_dist()]
DELETE FROM `spip_debug`.spipdebug_meta
WHERE nom='mysql_rappel_nom_base'