Merci cela va mieux mais !
QuoteAll files upgraded. Now upgrading database...
Updating database schema...Executing: CREATE TABLE lbd_admin_filter (id INT AUTO_INCREMENT NOT NULL, employee INT NOT NULL, shop INT NOT NULL, controller VARCHAR(60) NOT NULL, action VARCHAR(100) NOT NULL, filter LONGTEXT NOT NULL, filter_id VARCHAR(255) NOT NULL, UNIQUE INDEX admin_filter_search_id_idx (employee, shop, controller, action, filter_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDBExecuting: CREATE TABLE lbd_module_history (id INT AUTO_INCREMENT NOT NULL, id_employee INT NOT NULL, id_module INT NOT NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDBExecuting: CREATE TABLE lbd_translation (id_translation INT AUTO_INCREMENT NOT NULL, id_lang INT NOT NULL, `key` TEXT NOT NULL, translation TEXT NOT NULL, domain VARCHAR(80) NOT NULL, theme VARCHAR(32) DEFAULT NULL, INDEX IDX_E2E02552BA299860 (id_lang), INDEX `key` (domain), PRIMARY KEY(id_translation)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDBExecuting: ALTER TABLE lbd_attribute CHANGE color color VARCHAR(32) NOT NULL, CHANGE position position INT NOT NULL DEFAULT '0'Executing: CREATE INDEX IDX_2AA8CE9C7A4F53DC ON lbd_attribute_shop (id_attribute)Executing: DROP INDEX id_shop ON lbd_attribute_shopExecuting: CREATE INDEX IDX_2AA8CE9C274A50A0 ON lbd_attribute_shop (id_shop)Executing: ALTER TABLE lbd_attribute_group CHANGE is_color_group is_color_group TINYINT(1) NOT NULL DEFAULT '0' , CHANGE group_type group_type VARCHAR(255) NOT NULL DEFAULT 'select' , CHANGE position position INT NOT NULL DEFAULT '0'Executing: CREATE INDEX IDX_499AD34267A664FB ON lbd_attribute_group_shop (id_attribute_group)Executing: DROP INDEX id_shop ON lbd_attribute_group_shopExecuting: CREATE INDEX IDX_499AD342274A50A0 ON lbd_attribute_group_shop (id_shop)Executing: CREATE INDEX IDX_D4F91B8267A664FB ON lbd_attribute_group_lang (id_attribute_group)Executing: CREATE INDEX IDX_D4F91B82BA299860 ON lbd_attribute_group_lang (id_lang)Executing: DROP INDEX id_lang ON lbd_attribute_langExecuting: CREATE INDEX IDX_B7CB065C7A4F53DC ON lbd_attribute_lang (id_attribute)Executing: CREATE INDEX IDX_B7CB065CBA299860 ON lbd_attribute_lang (id_lang)Executing: ALTER TABLE lbd_lang CHANGE id_lang id_lang INT AUTO_INCREMENT NOT NULL, CHANGE active active TINYINT(1) NOT NULL DEFAULT '0' , CHANGE iso_code iso_code VARCHAR(2) NOT NULL, CHANGE language_code language_code VARCHAR(5) NOT NULL, CHANGE date_format_lite date_format_lite VARCHAR(32) NOT NULL DEFAULT 'Y-m-d' , CHANGE date_format_full date_format_full VARCHAR(32) NOT NULL DEFAULT 'Y-m-d H:i:s' , CHANGE is_rtl is_rtl TINYINT(1) NOT NULL DEFAULT '0' , ADD PRIMARY KEY (id_lang)Executing: ALTER TABLE lbd_lang_shop ADD PRIMARY KEY (id_lang, id_shop)Executing: CREATE INDEX IDX_A845FEA4BA299860 ON lbd_lang_shop (id_lang)Executing: CREATE INDEX IDX_A845FEA4274A50A0 ON lbd_lang_shop (id_shop)Executing: ALTER TABLE lbd_product_download CHANGE id_product_download id_product_download INT UNSIGNED AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id_product_download)Executing: ALTER TABLE lbd_shop CHANGE id_shop id_shop INT AUTO_INCREMENT NOT NULL, CHANGE id_category id_category INT NOT NULL DEFAULT '1' , CHANGE theme_name theme_name VARCHAR(255) NOT NULL, CHANGE active active TINYINT(1) NOT NULL DEFAULT '1' , CHANGE deleted deleted TINYINT(1) NOT NULL DEFAULT '0' , ADD PRIMARY KEY (id_shop)Executing: CREATE INDEX IDX_5A47B1B9F5C9E40 ON lbd_shop (id_shop_group)Executing: ALTER TABLE lbd_shop_group CHANGE id_shop_group id_shop_group INT AUTO_INCREMENT NOT NULL, CHANGE active active TINYINT(1) NOT NULL DEFAULT '1' , CHANGE deleted deleted TINYINT(1) NOT NULL DEFAULT '0' , ADD PRIMARY KEY (id_shop_group)Executing: ALTER TABLE lbd_stock_mvt CHANGE id_stock_mvt id_stock_mvt BIGINT AUTO_INCREMENT NOT NULL, CHANGE id_stock id_stock INT NOT NULL, CHANGE id_order id_order INT DEFAULT NULL, CHANGE id_supply_order id_supply_order INT DEFAULT NULL, CHANGE id_stock_mvt_reason id_stock_mvt_reason INT NOT NULL, CHANGE id_employee id_employee INT NOT NULL, CHANGE employee_lastname employee_lastname VARCHAR(32) DEFAULT '', CHANGE employee_firstname employee_firstname VARCHAR(32) DEFAULT '', CHANGE physical_quantity physical_quantity INT NOT NULL, CHANGE sign sign SMALLINT DEFAULT '1', CHANGE referer referer BIGINT DEFAULT NULL, ADD PRIMARY KEY (id_stock_mvt)Executing: CREATE INDEX id_stock ON lbd_stock_mvt (id_stock)Executing: CREATE INDEX id_stock_mvt_reason ON lbd_stock_mvt (id_stock_mvt_reason)Executing: ALTER TABLE lbd_tab CHANGE id_tab id_tab INT AUTO_INCREMENT NOT NULL, CHANGE class_name class_name VARCHAR(64) DEFAULT NULL, CHANGE position position INT NOT NULL, CHANGE active active TINYINT(1) NOT NULL DEFAULT '1' , CHANGE hide_host_mode hide_host_mode TINYINT(1) NOT NULL DEFAULT '0' , CHANGE icon icon VARCHAR(32) DEFAULT '', ADD PRIMARY KEY (id_tab)Executing: ALTER TABLE lbd_tab_lang CHANGE name name VARCHAR(128) NOT NULL, ADD PRIMARY KEY (id_tab, id_lang)22:45:57 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign". Message: "An exception occurred while executing 'ALTER TABLE lbd_tab_lang CHANGE name name VARCHAR(128) NOT NULL, ADD PRIMARY KEY (id_tab, id_lang)':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ '183-1' pour la clef 'PRIMARY'" ["exception" => Doctrine\DBAL\Exception\UniqueConstraintViolationException { …},"command" => "prestashop:schema:update-without-foreign","message" => """ An exception occurred while executing 'ALTER TABLE lbd_tab_lang CHANGE name name VARCHAR(128) NOT NULL, ADD PRIMARY KEY (id_tab, id_lang)':\n \n SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ '183-1' pour la clef 'PRIMARY' """]In AbstractMySQLDriver.php line 66:An exception occurred while executing 'ALTER TABLE lbd_tab_lang CHANGE name name VARCHAR(128) NOT NULL, ADD PRIMARYKEY (id_tab, id_lang)':SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ '183-1' pour la clef 'PRIMARY'In PDOConnection.php line 106:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ '183-1' pour la clef 'PRIMARY'In PDOConnection.php line 104:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ '183-1' pour la clef 'PRIMARY'prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--]
SQL 1.7.1.0 1075 in ALTER TABLE `lbd_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL AUTO_INCREMENT: Un seul champ automatique est permis et il doit être indexé
SQL 1.7.1.0 1075 in ALTER TABLE `lbd_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL AUTO_INCREMENT: Un seul champ automatique est permis et il doit être indexé
SQL 1.7.1.0 1075 in ALTER TABLE `lbd_shop_group` CHANGE `id_shop_group` `id_shop_group` INT(11) NOT NULL AUTO_INCREMENT: Un seul champ automatique est permis et il doit être indexé
SQL 1.7.1.0 1075 in ALTER TABLE `lbd_tab` CHANGE `id_tab` `id_tab` INT(11) NOT NULL AUTO_INCREMENT: Un seul champ automatique est permis et il doit être indexé
Error during database upgrade. You may need to restore your database.Error upgrading Doctrine schema