Impossible d'installer en MYSQL #5195

Closed
opened 4 months ago by maieul · 3 comments
maieul commented 4 months ago
Collaborator

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'
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' ````
Poster
Collaborator

mysql Ver 8.0.29-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))

est-ce que serait too much ?

`mysql Ver 8.0.29-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))` est-ce que serait too much ?
Owner

Ça sent le doublon de #4342 et ça peut être contourné avec define('_MYSQL_ENGINE', 'InnoDB'); maintenant ;)

Ça sent le doublon de #4342 et ça peut être contourné avec `define('_MYSQL_ENGINE', 'InnoDB');` maintenant ;)
Poster
Collaborator

Effectivement c'est le cas. Du coup on ferme. Mais ca rend encore plus pertinent #5189

Effectivement c'est le cas. Du coup on ferme. Mais ca rend encore plus pertinent #5189
maieul closed this issue 4 months ago
b_b added the
doublon
label 4 months ago
Sign in to join this conversation.
No Milestone
No project
No Assignees
2 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Loading…
There is no content yet.