437 erreurs SQL sont apparues

[iQuid]

Quelqu'un sait ce qui peux générer autant d'erreurs lors d'une mise à jour ?

Je test de faire la mise à jour avant sous mamp en local pour infos.

SET NAMES ''utf8''

(1115) Unknown character set: ''

 

SET NAMES ''utf8''

(1115) Unknown character set: ''

 

ALTER TABLE `pss_employee` ADD `bo_color` varchar(32) default NULL AFTER `stats_date_to`

 

ALTER TABLE `pss_employee` ADD `bo_theme` varchar(32) default NULL AFTER `bo_color`

 

ALTER TABLE `pss_employee` ADD `bo_uimode` ENUM(''hover'',''click'') default ''click'' AFTER `bo_theme`

(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 'hover'',''click'') default ''click'' AFTER `bo_theme`' at line 1

 

ALTER TABLE `pss_employee` ADD `id_lang` int(10) unsigned NOT NULL default 0 AFTER `id_profile`

 

ALTER TABLE `pss_cms` ADD `id_cms_category` int(10) unsigned NOT NULL default ''0'' AFTER `id_cms`

(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 '0'' AFTER `id_cms`' at line 1

 

ALTER TABLE `pss_cms` ADD `position` int(10) unsigned NOT NULL default ''0'' AFTER `id_cms_category`

(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 '0'' AFTER `id_cms_category`' at line 1

 

CREATE TABLE `pss_cms_category` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_parent` int(10) unsigned NOT NULL, `level_depth` tinyint(3) unsigned NOT NULL DEFAULT ''0'', `active` tinyint(1) unsigned NOT NULL DEFAULT ''0'', `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, `position` int(10) unsigned NOT NULL default ''0'', PRIMARY KEY (`id_cms_category`), KEY `category_parent` (`id_parent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(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 '0'', `active` tinyint(1) unsigned NOT NULL DEFAULT ''0'', `date_add` datetim' at line 4

[iQuid]

SOS ?

[phil56]

Bonsoir,

 

Je n'ai pas de réponse toute faite mais dans un pareil cas j'installerai la nouvelle version séparément sur une nouvelle base afin de pouvoir comparer les tables.

 

Remarque : c'est normal le 'pss_cms' ?

 

Bon courage,