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'