Bonjour
Version Spip installée : spip-v3.2.8
Version php : 7.4.4
Message d’erreur de SPIP :
Le serveur SQL contient plusieurs bases de données.
Sélectionnez ci-après celle qui vous a été attribuée par votre hébergeur :
• information_schema
• rossi_spip-v3_2_8
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.
Logs trouvés dans TMP/LOG :
Fichier mysqlmysql.log :
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L73 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_meta (
nom VARCHAR (255) NOT NULL,
valeur text DEFAULT ‹ ›,
impt ENUM(‹ non ›, ‹ oui ›) DEFAULT ‹ oui › NOT NULL,
maj TIMESTAMP,
PRIMARY KEY (nom)) ENGINE=MyISAM
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L81 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_meta (
nom VARCHAR (255) NOT NULL,
valeur text DEFAULT ‹ ›,
impt ENUM(‹ non ›, ‹ oui ›) DEFAULT ‹ oui › NOT NULL,
maj TIMESTAMP,
PRIMARY KEY (nom)) ENGINE=MyISAM
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L73 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_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-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L81 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_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-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1146 de mysql: Table ‹ rossi_spip-v3_2_8.spip_meta › doesn’t exist
in /home/rossi/www/spip-v3.2.8/ecrire/install/etape_3.php L127 [sql_insertq(),install_bases(),install_etape_3_dist(),exec_install_dist()]
INSERT INTO spip_meta (nom,valeur,impt) VALUES (‹ version_installee ›,‹ 23375 ›,‹ non ›)
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1146 de mysql: Table ‹ rossi_spip-v3_2_8.spip_meta › doesn’t exist
in /home/rossi/www/spip-v3.2.8/ecrire/install/etape_3.php L130 [sql_insertq(),install_bases(),install_etape_3_dist(),exec_install_dist()]
INSERT INTO spip_meta (nom,valeur,impt) VALUES (‹ nouvelle_install ›,‹ 1 ›,‹ non ›)
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1146 de mysql: Table ‹ rossi_spip-v3_2_8.spip_meta › doesn’t exist
in /home/rossi/www/spip-v3.2.8/ecrire/req/mysql.php L1739 [sql_delete(),test_rappel_nom_base_mysql(),install_mode_appel(),install_bases(),install_etape_3_dist(),exec_install_dist()]
DELETE FROM rossi_spip-v3_2_8
.spip_meta
WHERE nom=‹ mysql_rappel_nom_base ›
Fichier spip.log :
2022-01-22 17:29:50 87.90.214.177 (pid 3560721) :Pri:!INFO: spip_connect: fichier de connexion ‹ › non trouve
2022-01-22 17:30:54 87.90.214.177 (pid 3560721) :Pri:WARNING: SPIP ne connait pas les Charsets disponibles sur le serveur mysql. Le serveur choisira seul.
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L73 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_meta (
nom VARCHAR (255) NOT NULL,
valeur text DEFAULT ‹ ›,
impt ENUM(‹ non ›, ‹ oui ›) DEFAULT ‹ oui › NOT NULL,
maj TIMESTAMP,
PRIMARY KEY (nom)) ENGINE=MyISAM
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:55 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L81 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_meta (
nom VARCHAR (255) NOT NULL,
valeur text DEFAULT ‹ ›,
impt ENUM(‹ non ›, ‹ oui ›) DEFAULT ‹ oui › NOT NULL,
maj TIMESTAMP,
PRIMARY KEY (nom)) ENGINE=MyISAM
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:cf maj.log
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L73 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_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-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1071
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1071 de mysql: Specified key was too long; max key length is 1000 bytes
in /home/rossi/www/spip-v3.2.8/ecrire/base/create.php L81 [sql_create(),creer_ou_upgrader_table(),alterer_base(),creer_base(),install_bases(),install_etape_3_dist(),exec_install_dist()]
CREATE TABLE IF NOT EXISTS rossi_spip-v3_2_8
.spip_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-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:cf maj.log
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1146 de mysql: Table ‹ rossi_spip-v3_2_8.spip_meta › doesn’t exist
in /home/rossi/www/spip-v3.2.8/ecrire/install/etape_3.php L127 [sql_insertq(),install_bases(),install_etape_3_dist(),exec_install_dist()]
INSERT INTO spip_meta (nom,valeur,impt) VALUES (‹ version_installee ›,‹ 23375 ›,‹ non ›)
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1146 de mysql: Table ‹ rossi_spip-v3_2_8.spip_meta › doesn’t exist
in /home/rossi/www/spip-v3.2.8/ecrire/install/etape_3.php L130 [sql_insertq(),install_bases(),install_etape_3_dist(),exec_install_dist()]
INSERT INTO spip_meta (nom,valeur,impt) VALUES (‹ nouvelle_install ›,‹ 1 ›,‹ non ›)
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur 1146 de mysql: Table ‹ rossi_spip-v3_2_8.spip_meta › doesn’t exist
in /home/rossi/www/spip-v3.2.8/ecrire/req/mysql.php L1739 [sql_delete(),test_rappel_nom_base_mysql(),install_mode_appel(),install_bases(),install_etape_3_dist(),exec_install_dist()]
DELETE FROM rossi_spip-v3_2_8
.spip_meta
WHERE nom=‹ mysql_rappel_nom_base ›
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:ERREUR: Erreur mysql 1146
Fichier maj.log :
2022-01-22 17:30:56 87.90.214.177 (pid 3560721) :Pri:CRITIQUE: Echec creation table spip_meta
2022-01-22 17:30:57 87.90.214.177 (pid 3560721) :Pri:CRITIQUE: Echec creation table spip_urls
Merci pour votre aide