je passe d'une 1.9.3dev dont je n'ai pas le numéro à une 2.0.6 ,
j'ai ça dans spip.log , une idée ? :
Action super-admin: mise à niveau de votre base SQL
meta: upgrade upgrade,admin_b42edc5c8c,non
admin _1_ (init)
recree les tables eventuellement disparues
Erreur mysql 1064
You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL,
- CREATE TABLE IF NOT EXISTS `plouf`.spip_articles (
id_article bigint(21) NOT NULL auto_increment,
surtitre text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL,
titre text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL,
soustitre text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT
'' NOT NULL,
id_rubrique bigint(21) DEFAULT '0' NOT NULL,
descriptif text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT
'' NOT NULL,
chapo mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT
'' NOT NULL,
texte longtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT
'' NOT NULL,
ps mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL,
date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
statut varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT '0' NOT NULL,
id_secteur bigint(21) DEFAULT '0' NOT NULL,
maj TIMESTAMP,
export VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'oui',
date_redac datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
visites integer DEFAULT '0' NOT NULL,
referers integer DEFAULT '0' NOT NULL,
popularite DOUBLE DEFAULT '0' NOT NULL,
accepter_forum CHAR(3) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT '' NOT NULL,
date_modif datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
lang VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT
'' NOT NULL,
langue_choisie VARCHAR(3) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT 'non',
id_trad bigint(21) DEFAULT '0' NOT NULL,
extra longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
id_version int unsigned DEFAULT '0' NOT NULL,
nom_site tinytext CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT '' NOT NULL,
url_site VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT '' NOT NULL,
PRIMARY KEY (id_article),
KEY id_rubrique (id_rubrique),
KEY id_secteur (id_secteur),
KEY id_trad (id_trad),
KEY lang (lang),
KEY statut (statut, date)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci