jsmarcotte Posted October 5, 2012 Share Posted October 5, 2012 J e travaille depuis plusieurs semaines a mettre a jour une boutique en production de 1.4.9 vers 1.5, avec l'autoupgrade , manuellement, par ecrasement, par import/export, j'ai même essayé la magie et le vodoo. Mais je transfere des données (client,commande,produit,categorie) ne veulent jamais suivre, j'ai réussis par écrasement selectif et merge de base de donnée a voir mes données dans l'admin mais les categorie semblait etre completement melé et surtout non réassignable. Il y avait quelques ratés du coté Module Poste Canada que j ai du tweeké mais je n'ai jamais pu être en mesures d'afficher mes produits étant donné que les categorie et fournisseur ne coopérait pas. J'ai donc cancellé le projet et réinstallé un version de 1.5.1 en parralele de ma boutique en production 1.4.9. et je cherche la méthode pour exporter order,catalog,categorie,clients, et de les importer dans une version fraiche de 1.5.1? Lors de l'utilisation de l'outil experimental de mise a jour en 1 clic 0.8.6 des erreurs SQL s'affiche et on m'oblige de restaurer, ce qui ne foncitonne jamais anyway... voici les erreurs: [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `ps_group_shop` (`id_group_shop`, `name`, `active`, `deleted`, `share_stock`, `share_customer`, `share_order`) VALUES (1, 'Default', 1, 0, 0, 0, 0): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `ps_shop` (`id_shop`, `id_group_shop`, `name`, `id_category`, `id_theme`, `active`, `deleted`) VALUES (1, 1, (SELECT value FROM `ps_configuration` WHERE name = 'PS_SHOP_NAME'), 1, 1, 1, 0): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_theme` (`id_theme`, `name`) VALUES (1, 'prestashop'): Duplicate entry '1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_stock` ( `id_stock` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT, `id_product` INT( 11 ) UNSIGNED NOT NULL, `id_product_attribute` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, `quantity` INT(11) NOT NULL, PRIMARY KEY (`id_stock`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`), KEY `id_shop` (`id_shop`), UNIQUE KEY `product_stock` (`id_product` ,`id_product_attribute` ,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_stock' already exists [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `ps_stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, id_product_attribute, 1, quantity FROM ps_product_attribute): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `ps_stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, 0, 1, IF( (SELECT COUNT(*) FROM ps_product_attribute pa WHERE p.id_product = pa.id_product) > 0, (SELECT SUM(pa2.quantity) FROM ps_product_attribute pa2 WHERE p.id_product = pa2.id_product), quantity ) FROM ps_product p): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in UPDATE ps_stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM ps_stock s WHERE s.id_product = sm.id_product AND s.id_product_attribute = sm.id_product_attribute ORDER BY s.id_shop LIMIT 1 ), 0): Unknown column 's.id_shop' in 'order clause' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_country_shop` ( `id_country` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_country`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_country_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_country_shop` (id_shop, id_country) (SELECT 1, id_country FROM ps_country): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_carrier_shop` ( `id_carrier` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_carrier`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_carrier_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_carrier_shop` (id_shop, id_carrier) (SELECT 1, id_carrier FROM ps_carrier): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_lang_shop` ( `id_lang` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_lang`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_lang_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_lang_shop` (id_shop, id_lang) (SELECT 1, id_lang FROM ps_lang): Duplicate entry '4-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_currency_shop` ( `id_currency` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_currency`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_currency_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_currency_shop` (id_shop, id_currency) (SELECT 1, id_currency FROM ps_currency): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_contact_shop` ( `id_contact` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_contact`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_contact_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_contact_shop` (id_shop, id_contact) (SELECT 1, id_contact FROM `ps_contact`): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_image_shop` ( `id_image` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_image`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_image_shop' already exists [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_attribute_group_shop` ( `id_attribute` INT(11) UNSIGNED NOT NULL, `id_group_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_attribute`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_attribute_group_shop' already exists [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `ps_attribute_group_shop` (id_group_shop, id_attribute) (SELECT 1, id_attribute FROM ps_attribute): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_store_shop` ( `id_store` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_store`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_store_shop' already exists [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_product_shop` ( `id_product` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY ( `id_shop` , `id_product` ), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_product_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_product_shop` (id_shop, id_product) (SELECT 1, id_product FROM ps_product): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_module_shop` ( `id_module` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_module` , `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_module_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_module_shop` (`id_module`, `id_shop`) (SELECT `id_module`, 1 FROM `ps_module`): Duplicate entry '6-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_referrer_shop` ( `id_referrer` int(10) unsigned NOT NULL auto_increment, `id_shop` int(10) unsigned NOT NULL default '1', `cache_visitors` int(11) default NULL, `cache_visits` int(11) default NULL, `cache_pages` int(11) default NULL, `cache_registrations` int(11) default NULL, `cache_orders` int(11) default NULL, `cache_sales` decimal(17,2) default NULL, `cache_reg_rate` decimal(5,4) default NULL, `cache_order_rate` decimal(5,4) default NULL, PRIMARY KEY (`id_referrer`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_referrer_shop' already exists [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `ps_scene_shop` ( `id_scene` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_scene`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_scene_shop' already exists [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `ps_module_access` (`id_profile`, `id_module`, `configure`, `view`) ( SELECT `id_profile`, `id_module`, 1, 1 FROM `ps_access` a, ps_module m WHERE `id_tab` = (SELECT `id_tab` FROM `ps_tab` WHERE `class_name` != "" LIMIT 1) AND a.`view` = 1 ): Duplicate entry '1-6' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `ps_gender` (`id_gender`, `type`) VALUES (1, 0), (2, 1), (3, 1): Duplicate entry '1' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `ps_gender_lang` (`id_gender`, `id_lang`, `name`) VALUES (1, 1, 'Mr.'), (1, 2, 'M.'), (1, 3, 'Sr.'), (1, 4, 'Herr'), (1, 5, 'Sig.'), (2, 1, 'Ms.'), (2, 2, 'Mme'), (2, 3, 'Sra.'), (2, 4, 'Frau'), (2, 5, 'Sig.ra'), (3, 1, 'Miss'), (3, 2, 'Melle'), (3, 3, 'Miss'), (3, 4, 'Miss'), (3, 5, 'Miss'): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_customer_message_sync_imap` ( `md5_header` varbinary(32) NOT NULL, KEY `md5_header_index` (`md5_header`(4)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_customer_message_sync_imap' already exists [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `ps_employee_shop` (`id_employee`, `id_shop`) (SELECT `id_employee`, 1 FROM `ps_employee`): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_order_invoice` ( `id_order_invoice` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) NOT NULL, `number` int(11) NOT NULL, `total_discount_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_discount_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_paid_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_paid_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_products` decimal(17,2) NOT NULL DEFAULT '0.00', `total_products_wt` decimal(17,2) NOT NULL DEFAULT '0.00', `total_shipping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_shipping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_wrapping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_wrapping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `date_add` datetime NOT NULL, PRIMARY KEY (`id_order_invoice`), KEY `id_order` (`id_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_order_invoice' already exists [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `ps_payment_cc` TO `ps_order_payment`: Table 'ps_order_payment' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_product_carrier` ( `id_product` int(10) unsigned NOT NULL, `id_carrier_reference` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, PRIMARY KEY (`id_product`, `id_carrier_reference`, `id_shop`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8: Table 'ps_product_carrier' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_cart_rule` ( `id_cart_rule` int(10) unsigned NOT NULL auto_increment, `id_customer` int unsigned NOT NULL default 0, `date_from` datetime NOT NULL, `date_to` datetime NOT NULL, `description` text, `quantity` int(10) unsigned NOT NULL default 0, `quantity_per_user` int(10) unsigned NOT NULL default 0, `priority` int(10) unsigned NOT NULL default 1, `code` varchar(254) NOT NULL, `minimum_amount` decimal(17,2) NOT NULL default 0, `minimum_amount_tax` tinyint(1) NOT NULL default 0, `minimum_amount_currency` int unsigned NOT NULL default 0, `minimum_amount_shipping` tinyint(1) NOT NULL default 0, `country_restriction` tinyint(1) unsigned NOT NULL default 0, `carrier_restriction` tinyint(1) unsigned NOT NULL default 0, `group_restriction` tinyint(1) unsigned NOT NULL default 0, `cart_rule_restriction` tinyint(1) unsigned NOT NULL default 0, `product_restriction` tinyint(1) unsigned NOT NULL default 0, `free_shipping` tinyint(1) NOT NULL default 0, `reduction_percent` decimal(5,2) NOT NULL default 0, `reduction_amount` decimal(17,2) NOT NULL default 0, `reduction_tax` tinyint(1) unsigned NOT NULL default 0, `reduction_currency` int(10) unsigned NOT NULL default 0, `reduction_product` int(10) NOT NULL default 0, `gift_product` int(10) unsigned NOT NULL default 0, `active` tinyint(1) unsigned NOT NULL default 0, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_cart_rule`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_cart_rule_country` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_country` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_country`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_country' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_cart_rule_group` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_group` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_group' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_cart_rule_carrier` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_carrier` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_carrier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_carrier' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_cart_rule_combination` ( `id_cart_rule_1` int(10) unsigned NOT NULL, `id_cart_rule_2` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule_1`, `id_cart_rule_2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_combination' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_cart_rule_product_rule` ( `id_product_rule` int(10) unsigned NOT NULL auto_increment, `id_cart_rule` int(10) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL default 1, `type` ENUM('products', 'categories', 'attributes') NOT NULL, PRIMARY KEY (`id_product_rule`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_product_rule' already exists [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `ps_discount_lang` TO `ps_cart_rule_lang`: Table 'ps_cart_rule_lang' already exists [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'ps_cart_rule_lang' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL: Unknown column 'description' in 'ps_cart_rule_lang' [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `ps_discount_category` TO `ps_cart_rule_product_rule_value`: Table 'ps_cart_rule_product_rule_value' already exists [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL: Unknown column 'id_category' in 'ps_cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'ps_cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in INSERT INTO `ps_cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) ( SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `ps_cart_rule_product_rule_value` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `ps_order_discount` TO `ps_order_cart_rule`: Table 'ps_order_cart_rule' already exists [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `ps_cart_discount` TO `ps_cart_cart_rule`: Table 'ps_cart_cart_rule' already exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `ps_order_detail_tax` ADD `unit_amount` DECIMAL(16, 6) NOT NULL AFTER `id_tax`, ADD `total_amount` DECIMAL(16, 6) NOT NULL AFTER `unit_amount`: Duplicate column name 'unit_amount' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_order_carrier` ( `id_order_carrier` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) unsigned NOT NULL, `id_carrier` int(11) unsigned NOT NULL, `id_order_invoice` int(11) unsigned DEFAULT NULL, `weight` float DEFAULT NULL, `shipping_cost_tax_excl` decimal(20,6) DEFAULT NULL, `shipping_cost_tax_incl` decimal(20,6) DEFAULT NULL, `tracking_number` varchar(64) DEFAULT NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_order_carrier`), KEY `id_order` (`id_order`), KEY `id_carrier` (`id_carrier`), KEY `id_order_invoice` (`id_order_invoice`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_order_carrier' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `ps_hook_alias` ( `id_hook_alias` int(10) unsigned NOT NULL auto_increment, `alias` varchar(64) NOT NULL, `name` varchar(64) NOT NULL, PRIMARY KEY (`id_hook_alias`), UNIQUE KEY `alias` (`alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_hook_alias' already exists [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `ps_hook_alias` (`id_hook_alias`, `name`, `alias`) VALUES (1, 'displayPayment', 'payment'), (2, 'actionValidateOrder', 'newOrder'), (3, 'actionPaymentConfirmation', 'paymentConfirm'), (4, 'displayPaymentReturn', 'paymentReturn'), (5, 'actionUpdateQuantity', 'updateQuantity'), (6, 'displayRightColumn', 'rightColumn'), (7, 'displayLeftColumn', 'leftColumn'), (8, 'displayHome', 'home'), (9, 'displayHeader', 'header'), (10, 'actionCartSave', 'cart'), (11, 'actionAuthentication', 'authentication'), (12, 'actionProductAdd', 'addproduct'), (13, 'actionProductUpdate', 'updateproduct'), (14, 'displayTop', 'top'), (15, 'displayRightColumnProduct', 'extraRight'), (16, 'actionProductDelete', 'deleteproduct'), (17, 'displayFooterProduct', 'productfooter'), (18, 'displayInvoice', 'invoice'), (19, 'actionOrderStatusUpdate', 'updateOrderStatus'), (20, 'displayAdminOrder', 'adminOrder'), (21, 'displayFooter', 'footer'), (22, 'displayPDFInvoice', 'PDFInvoice'), (23, 'displayAdminCustomers', 'adminCustomers'), (24, 'displayOrderConfirmation', 'orderConfirmation'), (25, 'actionCustomerAccountAdd', 'createAccount'), (26, 'displayCustomerAccount', 'customerAccount'), (27, 'actionOrderSlipAdd', 'orderSlip'), (28, 'displayProductTab', 'productTab'), (29, 'displayProductTabContent', 'productTabContent'), (30, 'displayShoppingCartFooter', 'shoppingCart'), (31, 'displayCustomerAccountForm', 'createAccountForm'), (32, 'displayAdminStatsModules', 'AdminStatsModules'), (33, 'displayAdminStatsGraphEngine', 'GraphEngine'), (34, 'actionOrderReturn', 'orderReturn'), (35, 'displayProductButtons', 'productActions'), (36, 'displayBackOfficeHome', 'backOfficeHome'), (37, 'displayAdminStatsGridEngine', 'GridEngine'), (38, 'actionWatermark', 'watermark'), (39, 'actionProductCancel', 'cancelProduct'), (40, 'displayLeftColumnProduct', 'extraLeft'), (41, 'actionProductOutOfStock', 'productOutOfStock'), (42, 'actionProductAttributeUpdate', 'updateProductAttribute'), (43, 'displayCarrierList', 'extraCarrier'), (44, 'displayShoppingCart', 'shoppingCartExtra'), (45, 'actionSearch', 'search'), (46, 'displayBeforePayment', 'backBeforePayment'), (47, 'actionCarrierUpdate', 'updateCarrier'), (48, 'actionOrderStatusPostUpdate', 'postUpdateOrderStatus'), (49, 'displayCustomerAccountFormTop', 'createAccountTop'), (50, 'displayBackOfficeHeader', 'backOfficeHeader'), (51, 'displayBackOfficeTop', 'backOfficeTop'), (52, 'displayBackOfficeFooter', 'backOfficeFooter'), (53, 'actionProductAttributeDelete', 'deleteProductAttribute'), (54, 'actionCarrierProcess', 'processCarrier'), (55, 'actionOrderDetail', 'orderDetail'), (56, 'displayBeforeCarrier', 'beforeCarrier'), (57, 'displayOrderDetail', 'orderDetailDisplayed'), (58, 'actionPaymentCCAdd', 'paymentCCAdded'), (59, 'displayProductComparison', 'extraProductComparison'), (60, 'actionCategoryAdd', 'categoryAddition'), (61, 'actionCategoryUpdate', 'categoryUpdate'), (62, 'actionCategoryDelete', 'categoryDeletion'), (63, 'actionBeforeAuthentication', 'beforeAuthentication'), (64, 'displayPaymentTop', 'paymentTop'), (65, 'actionHtaccessCreate', 'afterCreateHtaccess'), (66, 'actionAdminMetaSave', 'afterSaveAdminMeta'), (67, 'displayAttributeGroupForm', 'attributeGroupForm'), (68, 'actionAttributeGroupSave', 'afterSaveAttributeGroup'), (69, 'actionAttributeGroupDelete', 'afterDeleteAttributeGroup'), (70, 'displayFeatureForm', 'featureForm'), (71, 'actionFeatureSave', 'afterSaveFeature'), (72, 'actionFeatureDelete', 'afterDeleteFeature'), (73, 'actionProductSave', 'afterSaveProduct'), (74, 'actionProductListOverride', 'productListAssign'), (75, 'displayAttributeGroupPostProcess', 'postProcessAttributeGroup'), (76, 'displayFeaturePostProcess', 'postProcessFeature'), (77, 'displayFeatureValueForm', 'featureValueForm'), (78, 'displayFeatureValuePostProcess', 'postProcessFeatureValue'), (79, 'actionFeatureValueDelete', 'afterDeleteFeatureValue'), (80, 'actionFeatureValueSave', 'afterSaveFeatureValue'), (81, 'displayAttributeForm', 'attributeForm'), (82, 'actionAttributePostProcess', 'postProcessAttribute'), (83, 'actionAttributeDelete', 'afterDeleteAttribute'), (84, 'actionAttributeSave', 'afterSaveAttribute'), (85, 'actionTaxManager', 'taxManager'): Duplicate entry '1' for key 'PRIMARY' [ERROR] SQL 1.5.0.2 1050 in CREATE TABLE `ps_specific_price_rule_condition_group` ( `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL, `id_specific_price_rule` INT(11) UNSIGNED NOT NULL, PRIMARY KEY ( `id_specific_price_rule_condition_group`, `id_specific_price_rule` ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_specific_price_rule_condition_group' already exists [ERROR] SQL 1.5.0.2 1050 in CREATE TABLE `ps_specific_price_rule_condition` ( `id_specific_price_rule_condition` INT(11) UNSIGNED NOT NULL, `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL, `type` VARCHAR(255) NOT NULL, `value` VARCHAR(255) NOT NULL, PRIMARY KEY (`id_specific_price_rule_condition`), INDEX (`id_specific_price_rule_condition_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_specific_price_rule_condition' already exists [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_invoice` ADD `note` TEXT NOT NULL AFTER `total_wrapping_tax_incl`: Duplicate column name 'note' [ERROR] PHP 1.5.0.2 /* Update records before alter tables */ /* PHP:set_stock_available(); */ 1054 - (products)Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_cart_rule` ADD `value_tax_excl` DECIMAL(17, 2) NOT NULL DEFAULT '0.00': Duplicate column name 'value_tax_excl' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_cart_rule` ADD `id_order_invoice` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `id_cart_rule`: Duplicate column name 'id_order_invoice' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_invoice` ADD `delivery_number` int(0) NOT NULL DEFAULT '0' AFTER `number`: Duplicate column name 'delivery_number' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_invoice` ADD `delivery_date` datetime AFTER `delivery_number`: Duplicate column name 'delivery_date' [ERROR] SQL 1.5.0.2 1054 in INSERT IGNORE INTO `ps_order_payment` (`id_order_invoice`, `id_order`, `id_currency`, `amount`, `payment_method`, `conversion_rate`, `date_add`) ( SELECT ( SELECT oi.`id_order_invoice` FROM `ps_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), o.`id_order`, o.`id_currency`, o.`total_paid_real`, o.`payment`, o.`conversion_rate`, o.`date_add` FROM `ps_orders` o LEFT JOIN `ps_order_payment` op ON (op.`id_order` = o.`id_order`) WHERE op.`id_order_payment` IS NULL ): Unknown column 'op.id_order' in 'on clause' [ERROR] SQL 1.5.0.2 1050 in CREATE TABLE `ps_webservice_account_shop` ( `id_webservice_account` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_webservice_account` , `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_webservice_account_shop' already exists [ERROR] SQL 1.5.0.3 1060 in ALTER TABLE `ps_theme` ADD COLUMN directory varchar(64) NOT NULL: Duplicate column name 'directory' [ERROR] SQL 1.5.0.4 1050 in CREATE TABLE `ps_category_shop` ( `id_category` int(11) NOT NULL, `id_shop` int(11) NOT NULL, PRIMARY KEY (`id_category`, `id_shop`), UNIQUE KEY `id_category_shop` (`id_category`,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_category_shop' already exists [ERROR] SQL 1.5.0.4 1050 in CREATE TABLE `ps_cart_rule_product_rule_group` ( `id_product_rule_group` int(10) unsigned NOT NULL auto_increment, `id_cart_rule` int(10) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL default 1, PRIMARY KEY (`id_product_rule_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_product_rule_group' already exists [ERROR] SQL 1.5.0.4 1054 in INSERT INTO `ps_cart_rule_product_rule_group` (`id_product_rule_group`, `id_cart_rule`, `quantity`) ( SELECT `id_cart_rule`, `id_cart_rule`, `quantity` FROM `ps_cart_rule_product_rule` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] SQL 1.5.0.4 1054 in ALTER TABLE `ps_cart_rule_product_rule` CHANGE `id_cart_rule` `id_product_rule_group` int(10) unsigned NOT NULL: Unknown column 'id_cart_rule' in 'ps_cart_rule_product_rule' [ERROR] SQL 1.5.0.4 1060 in ALTER TABLE `ps_cart_rule` ADD `partial_use` tinyint(1) unsigned NOT NULL default 0 AFTER `priority`: Duplicate column name 'partial_use' [ERROR] SQL 1.5.0.5 1060 in ALTER TABLE `ps_cart_rule` ADD `shop_restriction` tinyint(1) unsigned NOT NULL default 0 AFTER `product_restriction`: Duplicate column name 'shop_restriction' [ERROR] SQL 1.5.0.5 1050 in CREATE TABLE `ps_cart_rule_shop` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_cart_rule_shop' already exists [ERROR] SQL 1.5.0.5 1050 in CREATE TABLE `ps_module_preference` ( `id_module_preference` int(11) NOT NULL auto_increment, `id_employee` int(11) NOT NULL, `module` varchar(255) NOT NULL, `interest` tinyint(1) default NULL, `favorite` tinyint(1) default NULL, PRIMARY KEY (`id_module_preference`), UNIQUE KEY `employee_module` (`id_employee`, `module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_module_preference' already exists [ERROR] SQL 1.5.0.5 1060 in ALTER TABLE `ps_category_shop` ADD `position` int(10) unsigned NOT NULL default 0 AFTER `id_shop`: Duplicate column name 'position' [ERROR] SQL 1.5.0.7 1060 in ALTER TABLE `ps_cart_rule` ADD `gift_product_attribute` int(10) unsigned NOT NULL default 0 AFTER `gift_product`: Duplicate column name 'gift_product_attribute' [ERROR] SQL 1.5.0.7 1060 in ALTER TABLE `ps_product_shop` ADD `id_category_default` int(11) UNSIGNED DEFAULT NULL: Duplicate column name 'id_category_default' [ERROR] SQL 1.5.0.7 1050 in CREATE TABLE `ps_carrier_tax_rules_group_shop` ( `id_carrier` int(11) unsigned NOT NULL, `id_tax_rules_group` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, PRIMARY KEY (`id_carrier`, `id_tax_rules_group`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_carrier_tax_rules_group_shop' already exists [ERROR] SQL 1.5.0.7 1062 in INSERT INTO `ps_carrier_tax_rules_group_shop` (`id_carrier`, `id_tax_rules_group`, `id_shop`) (SELECT `id_carrier`, `id_tax_rules_group`, `id_shop` FROM `ps_carrier`, `ps_shop`): Duplicate entry '17-0-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in RENAME TABLE `ps_group_shop` TO `ps_shop_group`: Table 'ps_shop_group' already exists [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_shop_group` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT: Unknown column 'id_group_shop' in 'ps_shop_group' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_shop' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `ps_stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'ps_stock_available' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_product_attribute_shop` ( `id_product_attribute` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, `wholesale_price` decimal(20,6) NOT NULL default '0.000000', `price` decimal(20,6) NOT NULL default '0.000000', `ecotax` decimal(17,6) NOT NULL default '0.00', `weight` float NOT NULL default '0', `unit_price_impact` decimal(17,2) NOT NULL default '0.00', `default_on` tinyint(1) unsigned NOT NULL default '0', `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1', `available_date` date NOT NULL, PRIMARY KEY (`id_product_attribute`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_product_attribute_shop' already exists [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_attribute_shop` ( `id_attribute` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_attribute`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_attribute_shop' already exists [ERROR] SQL 1.5.0.10 1054 in INSERT INTO `ps_attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM ps_attribute_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Unknown column 'a.id_attribute' in 'field list' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_feature_shop` ( `id_feature` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_feature`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_feature_shop' already exists [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_group_shop` ( `id_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_group_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_group_shop` (`id_group`, `id_shop`) (SELECT a.id_group, c.id_shop FROM ps_group_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_tax_rules_group_shop` ( `id_tax_rules_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_tax_rules_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_tax_rules_group_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_tax_rules_group_shop` (`id_tax_rules_group`, `id_shop`) (SELECT a.id_tax_rules_group, c.id_shop FROM ps_tax_rules_group_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_zone_shop` ( `id_zone` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_zone`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_zone_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_zone_shop` (`id_zone`, `id_shop`) (SELECT a.id_zone, c.id_shop FROM ps_zone_group_shop a LEFT JOIN ps_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_manufacturer_shop` ( `id_manufacturer` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_manufacturer`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_manufacturer_shop' already exists [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `ps_supplier_shop` ( `id_supplier` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_supplier`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_supplier_shop' already exists [ERROR] SQL 1.5.0.13 1050 in -- Update order_payment structure for multishipping -- Step 1: Add the table ps_order_invoice_payment and populate it CREATE TABLE `ps_order_invoice_payment` ( `id_order_invoice` int(11) unsigned NOT NULL, `id_order_payment` int(11) unsigned NOT NULL, `id_order` int(11) unsigned NOT NULL, PRIMARY KEY (`id_order_invoice`,`id_order_payment`), KEY `order_payment` (`id_order_payment`), KEY `id_order` (`id_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'ps_order_invoice_payment' already exists [ERROR] SQL 1.5.0.13 1054 in INSERT INTO `ps_order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `ps_order_payment` WHERE id_order_invoice > 0): Unknown column 'id_order_invoice' in 'field list' [ERROR] SQL 1.5.0.13 1054 in -- Step 2: Add the collumn id_order_reference ALTER TABLE `ps_order_payment` ADD COLUMN `order_reference` VARCHAR(9) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`): Unknown column 'id_order' in 'ps_order_payment' [ERROR] PHP 1.5.0.13 -- Step 3: Fill in id_order_reference and merge duplicate lines /* PHP:add_order_reference_in_order_payment(); */ [ERROR] SQL 1.5.0.13 1091 in -- Step 4: Drop collumn id_order ALTER TABLE `ps_order_payment` DROP COLUMN `id_order`, DROP COLUMN `id_order_invoice`: Can't DROP 'id_order'; check that column/key exists [ERROR] SQL 1.5.0.14 1062 in INSERT INTO `ps_hook_alias` (`name`, `alias`) VALUES ('displayMyAccountBlock', 'myAccountBlock'): Duplicate entry 'myAccountBlock' for key 'alias' [ERROR] SQL 1.5.0.14 1060 in ALTER TABLE `ps_order_invoice` ADD `shipping_tax_computation_method` INT NOT NULL AFTER `total_shipping_tax_incl`: Duplicate column name 'shipping_tax_computation_method' [ERROR] SQL 1.5.0.16 1061 in ALTER TABLE `ps_stock_available` ADD INDEX `product_sqlstock` ( `id_product` , `id_product_attribute` , `id_shop` ): Duplicate key name 'product_sqlstock' Erreur(s) détectée(s) pendant la mise à jour. Mise à jour terminée, mais des erreurs sql sont apparues pendant la mise à jour de la base de données. Merci de restaurer votre boutique. ---------------------------------------------------------------------------------------------------- Bref.... je cherche simplement a savoir si il existe réelement d'autre gars qui ont réussit ou si on est toute une gang de tata qui perdre leur temps a debugger une version non réélement stable. ps, au programmeur, lorsqu on installe une version a neuf la 1.5.1 gagne beaucoup en vitesse et a des options essentiels, mais en update je ne vois que des centaines de post s'ajouter de jours en jours et personne qui dit , Bien moi ca a marché! Voila! JS http://www.entrepotdelacoiffure.com/shop/fr/ Link to comment Share on other sites More sharing options...
lauriou Posted October 7, 2012 Share Posted October 7, 2012 Moi aussi, je passe mes jours et mes nuits a esseayer de faire cette upgrade et toujours pas de solution... incroyable! Link to comment Share on other sites More sharing options...
bdevries Posted October 9, 2012 Share Posted October 9, 2012 (edited) Idem ! Ci-dessous le compte rendu de mise à jour vers 1.5.1. De plus, la boutique n'était pas stable, le BO non plus avec un affichage totalement désordonné des menus. Du coup, j'ai restauré ma sauvegarde de 1.4.9, mais je ne sais pas exactement ce qu'il s'est passé certains produits n'ont plus d'image. Je dois les régénérer. Sauf que l'hébergeur OVH aime pas bien et me retourne une erreur 500 (malgré la présence de "SetEnv max_execution_time 3600" dans le .HTACCESS) ---------------------- [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `idde_group_shop` (`id_group_shop`, `name`, `active`, `deleted`, `share_stock`, `share_customer`, `share_order`) VALUES (1, 'Default', 1, 0, 0, 0, 0): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `idde_shop` (`id_shop`, `id_group_shop`, `name`, `id_category`, `id_theme`, `active`, `deleted`) VALUES (1, 1, (SELECT value FROM `idde_configuration` WHERE name = 'PS_SHOP_NAME'), 1, 1, 1, 0): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_configuration` ADD `id_group_shop` INT(11) UNSIGNED DEFAULT NULL AFTER `id_configuration` , ADD `id_shop` INT(11) UNSIGNED DEFAULT NULL AFTER `id_group_shop`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1072 in ALTER TABLE `idde_configuration` ADD INDEX (`id_group_shop`): Key column 'id_group_shop' doesn't exist in table [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_theme` (`id_theme`, `name`) VALUES (1, 'prestashop'): Duplicate entry '1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_stock` ( `id_stock` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT, `id_product` INT( 11 ) UNSIGNED NOT NULL, `id_product_attribute` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, `quantity` INT(11) NOT NULL, PRIMARY KEY (`id_stock`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`), KEY `id_shop` (`id_shop`), UNIQUE KEY `product_stock` (`id_product` ,`id_product_attribute` ,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_stock' already exists [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `idde_stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, id_product_attribute, 1, quantity FROM idde_product_attribute): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `idde_stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, 0, 1, IF( (SELECT COUNT(*) FROM idde_product_attribute pa WHERE p.id_product = pa.id_product) > 0, (SELECT SUM(pa2.quantity) FROM idde_product_attribute pa2 WHERE p.id_product = pa2.id_product), quantity ) FROM idde_product p): Unknown column 'id_shop' in 'field list' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE idde_stock_mvt ADD id_stock INT UNSIGNED NOT NULL AFTER id_stock_mvt: Duplicate column name 'id_stock' [ERROR] SQL 1.5.0.0 1054 in UPDATE idde_stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM idde_stock s WHERE s.id_product = sm.id_product AND s.id_product_attribute = sm.id_product_attribute ORDER BY s.id_shop LIMIT 1 ), 0): Unknown column 'sm.id_product' in 'where clause' [ERROR] SQL 1.5.0.0 1091 in ALTER TABLE idde_stock_mvt DROP id_product, DROP id_product_attribute: Can't DROP 'id_product'; check that column/key exists [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_country_shop` ( `id_country` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_country`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_country_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_country_shop` (id_shop, id_country) (SELECT 1, id_country FROM idde_country): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_carrier_shop` ( `id_carrier` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_carrier`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_carrier_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_carrier_shop` (id_shop, id_carrier) (SELECT 1, id_carrier FROM idde_carrier): Duplicate entry '3-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_lang_shop` ( `id_lang` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_lang`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_lang_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_lang_shop` (id_shop, id_lang) (SELECT 1, id_lang FROM idde_lang): Duplicate entry '4-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_currency_shop` ( `id_currency` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_currency`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_currency_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_currency_shop` (id_shop, id_currency) (SELECT 1, id_currency FROM idde_currency): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_cart` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_cart` , ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`, ADD INDEX `id_group_shop` (`id_group_shop`), ADD INDEX `id_shop` (`id_shop`): Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_customer` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_customer` , ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`, ADD INDEX `id_group_shop` (`id_group_shop`), ADD INDEX `id_shop` (`id_shop`): Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_orders` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_order` , ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`, ADD INDEX `id_group_shop` (`id_group_shop`), ADD INDEX `id_shop` (`id_shop`): Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_customer_thread` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_customer_thread`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1061 in ALTER TABLE `idde_customer_thread` ADD INDEX `id_shop` (`id_shop`), ADD INDEX `id_lang` (`id_lang`), ADD INDEX `id_contact` (`id_contact`), ADD INDEX `id_customer` (`id_customer`), ADD INDEX `id_order` (`id_order`), ADD INDEX `id_product` (`id_product`): Duplicate key name 'id_shop' [ERROR] SQL 1.5.0.0 1061 in ALTER TABLE `idde_customer_message` ADD INDEX `id_employee` (`id_employee`): Duplicate key name 'id_employee' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_meta_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_meta`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1061 in ALTER TABLE `idde_meta_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_meta`, `id_shop`, `id_lang`), ADD INDEX `id_shop` (`id_shop`), ADD INDEX `id_lang` (`id_lang`): Duplicate key name 'id_shop' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_contact_shop` ( `id_contact` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_contact`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_contact_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_contact_shop` (id_shop, id_contact) (SELECT 1, id_contact FROM `idde_contact`): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_image_shop` ( `id_image` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_image`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_image_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_image_shop` (id_shop, id_image) (SELECT 1, id_image FROM idde_image): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_attribute_group_shop` ( `id_attribute` INT(11) UNSIGNED NOT NULL, `id_group_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_attribute`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_attribute_group_shop' already exists [ERROR] SQL 1.5.0.0 1054 in INSERT INTO `idde_attribute_group_shop` (id_group_shop, id_attribute) (SELECT 1, id_attribute FROM idde_attribute): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_store_shop` ( `id_store` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_store`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_store_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_store_shop` (id_shop, id_store) (SELECT 1, id_store FROM idde_store): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_product_shop` ( `id_product` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY ( `id_shop` , `id_product` ), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_product_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_product_shop` (id_shop, id_product) (SELECT 1, id_product FROM idde_product): Duplicate entry '12-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_category_lang` ADD `id_shop` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_category`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_product_lang` ADD `id_shop` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_product`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_hook_module` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_hook`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_hook_module_exceptions` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_hook`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_connections` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1', ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1': Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_page_viewed` ADD `id_group_shop` INT UNSIGNED NOT NULL DEFAULT '1' AFTER `id_page`, ADD `id_shop` INT UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_module_shop` ( `id_module` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_module` , `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_module_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `idde_module_shop` (`id_module`, `id_shop`) (SELECT `id_module`, 1 FROM `idde_module`): Duplicate entry '65-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_module_currency` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_module`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_module_country` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_module`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_module_group` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_module`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_carrier_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_carrier`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_search_word` ADD `id_shop` INT(11) NOT NULL DEFAULT '1' AFTER `id_word`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_referrer_shop` ( `id_referrer` int(10) unsigned NOT NULL auto_increment, `id_shop` int(10) unsigned NOT NULL default '1', `cache_visitors` int(11) default NULL, `cache_visits` int(11) default NULL, `cache_pages` int(11) default NULL, `cache_registrations` int(11) default NULL, `cache_orders` int(11) default NULL, `cache_sales` decimal(17,2) default NULL, `cache_reg_rate` decimal(5,4) default NULL, `cache_order_rate` decimal(5,4) default NULL, PRIMARY KEY (`id_referrer`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_referrer_shop' already exists [ERROR] SQL 1.5.0.0 1091 in ALTER TABLE `idde_referrer` DROP `cache_visitors`, DROP `cache_visits`, DROP `cache_pages`, DROP `cache_registrations`, DROP `cache_orders`, DROP `cache_sales`, DROP `cache_reg_rate`, DROP `cache_order_rate`: Can't DROP 'cache_visitors'; check that column/key exists [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_cart_product` ADD `id_shop` INT NOT NULL DEFAULT '1' AFTER `id_product`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_customization` ADD `in_cart` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0': Duplicate column name 'in_cart' [ERROR] SQL 1.5.0.0 1050 in CREATE TABLE `idde_scene_shop` ( `id_scene` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_scene`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_scene_shop' already exists [ERROR] SQL 1.5.0.0 1060 in ALTER TABLE `idde_delivery` ADD `id_shop` INT UNSIGNED NULL DEFAULT NULL AFTER `id_delivery`, ADD `id_group_shop` INT UNSIGNED NULL DEFAULT NULL AFTER `id_shop`: Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `idde_module_access` (`id_profile`, `id_module`, `configure`, `view`) ( SELECT `id_profile`, `id_module`, 1, 1 FROM `idde_access` a, idde_module m WHERE `id_tab` = (SELECT `id_tab` FROM `idde_tab` WHERE `class_name` != "" LIMIT 1) AND a.`view` = 1 ): Duplicate entry '1-65' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_tax_rule` ADD `zipcode_from` INT NOT NULL AFTER `id_state` , ADD `zipcode_to` INT NOT NULL AFTER `zipcode_from` , ADD `behavior` INT NOT NULL AFTER `zipcode_to`, ADD `description` VARCHAR( 100 ) NOT NULL AFTER `id_tax`: Duplicate column name 'zipcode_from' [ERROR] SQL 1.5.0.1 1146 in INSERT INTO `idde_tax_rule` (`id_tax_rules_group`, `id_country`, `id_state`, `id_tax`, `behavior`, `zipcode_from`, `zipcode_to`, `id_county`, `description`, `state_behavior`, `county_behavior`) SELECT r.`id_tax_rules_group`, r.`id_country`, r.`id_state`, r.`id_tax`, 0, z.`from_zip_code`, z.`to_zip_code`, r.`id_county`, r.`description`, r.`state_behavior`, r.county_behavior FROM `idde_tax_rule` r INNER JOIN `idde_county_zip_code` z ON (z.`id_county` = r.`id_county`): Table 'iddemodelisme.idde_county_zip_code' doesn't exist [ERROR] SQL 1.5.0.1 1054 in UPDATE `idde_tax_rule` SET `behavior` = GREATEST(`state_behavior`, `county_behavior`): Unknown column 'state_behavior' in 'field list' [ERROR] SQL 1.5.0.1 1054 in DELETE FROM `idde_tax_rule` WHERE `id_county` != 0 AND `zipcode_from` = 0: Unknown column 'id_county' in 'where clause' [ERROR] SQL 1.5.0.1 1091 in ALTER TABLE `idde_tax_rule` DROP `id_county`, DROP `state_behavior`, DROP `county_behavior`: Can't DROP 'id_county'; check that column/key exists [ERROR] SQL 1.5.0.1 1051 in DROP TABLE `idde_county_zip_code`: Unknown table 'idde_county_zip_code' [ERROR] SQL 1.5.0.1 1051 in DROP TABLE `idde_county`: Unknown table 'idde_county' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_employee` ADD `id_last_order` tinyint(1) unsigned NOT NULL default '0', ADD `id_last_customer_message` tinyint(1) unsigned NOT NULL default '0', ADD `id_last_customer` tinyint(1) unsigned NOT NULL default '0': Duplicate column name 'id_last_order' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_product` ADD `available_date` DATE NOT NULL AFTER `available_for_order`: Duplicate column name 'available_date' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_product_attribute` ADD `available_date` DATE NOT NULL: Duplicate column name 'available_date' [ERROR] SQL 1.5.0.1 1091 in /* Index was only used by deprecated function Image::positionImage() */ ALTER TABLE `idde_image` DROP INDEX `product_position`: Can't DROP 'product_position'; check that column/key exists [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `idde_gender` (`id_gender`, `type`) VALUES (1, 0), (2, 1), (3, 1): Duplicate entry '1' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `idde_gender_lang` (`id_gender`, `id_lang`, `name`) VALUES (1, 1, 'Mr.'), (1, 2, 'M.'), (1, 3, 'Sr.'), (1, 4, 'Herr'), (1, 5, 'Sig.'), (2, 1, 'Ms.'), (2, 2, 'Mme'), (2, 3, 'Sra.'), (2, 4, 'Frau'), (2, 5, 'Sig.ra'), (3, 1, 'Miss'), (3, 2, 'Melle'), (3, 3, 'Miss'), (3, 4, 'Miss'), (3, 5, 'Miss'): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_tax` ADD `deleted` INT NOT NULL AFTER `active`: Duplicate column name 'deleted' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_customer_message_sync_imap` ( `md5_header` varbinary(32) NOT NULL, KEY `md5_header_index` (`md5_header`(4)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_customer_message_sync_imap' already exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_customer_message` ADD `private` TINYINT NOT NULL DEFAULT '0' AFTER `user_agent`: Duplicate column name 'private' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_attribute` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0': Duplicate column name 'position' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `idde_product_download` CHANGE `date_deposit` `date_add` DATETIME NOT NULL: Unknown column 'date_deposit' in 'idde_product_download' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `idde_product_download` CHANGE `physically_filename` `filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL: Unknown column 'physically_filename' in 'idde_product_download' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_product_download` ADD `is_shareable` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `active`: Duplicate column name 'is_shareable' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_attribute_group` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0': Duplicate column name 'position' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_attribute_group` ADD `group_type` ENUM('select', 'radio', 'color') NOT NULL DEFAULT 'select': Duplicate column name 'group_type' [ERROR] SQL 1.5.0.1 1091 in ALTER TABLE `idde_product` DROP `id_color_default`: Can't DROP 'id_color_default'; check that column/key exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_feature` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0': Duplicate column name 'position' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_carrier` ADD COLUMN `id_reference` int(10) NOT NULL AFTER `id_carrier`: Duplicate column name 'id_reference' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_product` ADD `is_virtual` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `cache_has_attachments`: Duplicate column name 'is_virtual' [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `idde_employee_shop` (`id_employee`, `id_shop`) (SELECT `id_employee`, 1 FROM `idde_employee`): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_carrier` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0': Duplicate column name 'position' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_order_state` ADD COLUMN `shipped` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `delivery`: Duplicate column name 'shipped' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_order_invoice` ( `id_order_invoice` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) NOT NULL, `number` int(11) NOT NULL, `total_discount_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_discount_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_paid_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_paid_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_products` decimal(17,2) NOT NULL DEFAULT '0.00', `total_products_wt` decimal(17,2) NOT NULL DEFAULT '0.00', `total_shipping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_shipping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_wrapping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_wrapping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `date_add` datetime NOT NULL, PRIMARY KEY (`id_order_invoice`), KEY `id_order` (`id_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_order_invoice' already exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_order_detail` ADD `id_order_invoice` int(11) NOT NULL DEFAULT 0 AFTER `id_order`: Duplicate column name 'id_order_invoice' [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_payment_cc` CHANGE `id_payment_cc` `id_order_payment` INT NOT NULL auto_increment: Table 'iddemodelisme.idde_payment_cc' doesn't exist [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_payment_cc` ADD `id_order_invoice` varchar(255) NOT NULL AFTER `id_order_payment`: Table 'iddemodelisme.idde_payment_cc' doesn't exist [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_payment_cc` ADD `payment_method` varchar(255) NOT NULL AFTER `amount`: Table 'iddemodelisme.idde_payment_cc' doesn't exist [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_payment_cc` ADD `conversion_rate` decimal(13,6) NOT NULL DEFAULT 1 AFTER `payment_method`: Table 'iddemodelisme.idde_payment_cc' doesn't exist [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `idde_payment_cc` TO `idde_order_payment`: Table 'idde_order_payment' already exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_carrier` ADD COLUMN `max_width` int(10) DEFAULT 0 AFTER `position`, ADD COLUMN `max_height` int(10) DEFAULT 0 AFTER `max_width`, ADD COLUMN `max_depth` int(10) DEFAULT 0 AFTER `max_height`, ADD COLUMN `max_weight` int(10) DEFAULT 0 AFTER `max_depth`, ADD COLUMN `grade` int(10) DEFAULT 0 AFTER `max_weight`: Duplicate column name 'max_width' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_cart_product` ADD COLUMN `id_address_delivery` int(10) UNSIGNED DEFAULT 0 AFTER `date_add`: Duplicate column name 'id_address_delivery' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_cart` ADD COLUMN `allow_seperated_package` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `gift_message`: Duplicate column name 'allow_seperated_package' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_product_carrier` ( `id_product` int(10) unsigned NOT NULL, `id_carrier_reference` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, PRIMARY KEY (`id_product`, `id_carrier_reference`, `id_shop`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8: Table 'idde_product_carrier' already exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_customization` ADD COLUMN `id_address_delivery` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `id_product_attribute`, DROP PRIMARY KEY, ADD PRIMARY KEY (`id_customization`, `id_cart`, `id_product`, `id_address_delivery`): Duplicate column name 'id_address_delivery' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_cart_rule` ( `id_cart_rule` int(10) unsigned NOT NULL auto_increment, `id_customer` int unsigned NOT NULL default 0, `date_from` datetime NOT NULL, `date_to` datetime NOT NULL, `description` text, `quantity` int(10) unsigned NOT NULL default 0, `quantity_per_user` int(10) unsigned NOT NULL default 0, `priority` int(10) unsigned NOT NULL default 1, `code` varchar(254) NOT NULL, `minimum_amount` decimal(17,2) NOT NULL default 0, `minimum_amount_tax` tinyint(1) NOT NULL default 0, `minimum_amount_currency` int unsigned NOT NULL default 0, `minimum_amount_shipping` tinyint(1) NOT NULL default 0, `country_restriction` tinyint(1) unsigned NOT NULL default 0, `carrier_restriction` tinyint(1) unsigned NOT NULL default 0, `group_restriction` tinyint(1) unsigned NOT NULL default 0, `cart_rule_restriction` tinyint(1) unsigned NOT NULL default 0, `product_restriction` tinyint(1) unsigned NOT NULL default 0, `free_shipping` tinyint(1) NOT NULL default 0, `reduction_percent` decimal(5,2) NOT NULL default 0, `reduction_amount` decimal(17,2) NOT NULL default 0, `reduction_tax` tinyint(1) unsigned NOT NULL default 0, `reduction_currency` int(10) unsigned NOT NULL default 0, `reduction_product` int(10) NOT NULL default 0, `gift_product` int(10) unsigned NOT NULL default 0, `active` tinyint(1) unsigned NOT NULL default 0, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_cart_rule`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_cart_rule_country` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_country` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_country`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_country' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_cart_rule_group` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_group` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_group' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_cart_rule_carrier` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_carrier` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_carrier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_carrier' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_cart_rule_combination` ( `id_cart_rule_1` int(10) unsigned NOT NULL, `id_cart_rule_2` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule_1`, `id_cart_rule_2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_combination' already exists [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_cart_rule_product_rule` ( `id_product_rule` int(10) unsigned NOT NULL auto_increment, `id_cart_rule` int(10) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL default 1, `type` ENUM('products', 'categories', 'attributes') NOT NULL, PRIMARY KEY (`id_product_rule`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_product_rule' already exists [ERROR] SQL 1.5.0.1 1146 in INSERT INTO `idde_cart_rule` ( `id_cart_rule`, `id_customer`, `date_from`, `date_to`, `description`, `quantity`, `quantity_per_user`, `priority`, `code`, `minimum_amount`, `minimum_amount_tax`, `minimum_amount_currency`, `minimum_amount_shipping`, `country_restriction`, `carrier_restriction`, `group_restriction`, `cart_rule_restriction`, `product_restriction`, `free_shipping`, `reduction_percent`, `reduction_amount`, `reduction_tax`, `reduction_currency`, `reduction_product`, `gift_product`, `active`, `date_add`, `date_upd` ) ( SELECT `id_discount`, `id_customer`, `date_from`, `date_to`, `name`, `quantity`, `quantity_per_user`, 1, `name`, `minimal`, 1, @id_currency_default, 1, 0, 0, IF(id_group = 0, 0, 1), IF(cumulable = 1, 0, 1), 0, IF(id_discount_type = 3, 1, 0), IF(id_discount_type = 1, value, 0), IF(id_discount_type = 2, value, 0), 1, `id_currency`, 0, 0, `active`, `date_add`, `date_upd` FROM `idde_discount` ): Table 'iddemodelisme.idde_discount' doesn't exist [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `idde_discount_lang` TO `idde_cart_rule_lang`: Table 'idde_cart_rule_lang' already exists [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `idde_cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'idde_cart_rule_lang' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `idde_cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL: Unknown column 'description' in 'idde_cart_rule_lang' [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `idde_discount_category` TO `idde_cart_rule_product_rule_value`: Table 'idde_cart_rule_product_rule_value' already exists [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `idde_cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL: Unknown column 'id_category' in 'idde_cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in ALTER TABLE `idde_cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'idde_cart_rule_product_rule_value' [ERROR] SQL 1.5.0.1 1054 in INSERT INTO `idde_cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) ( SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `idde_cart_rule_product_rule_value` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_cart_discount` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Table 'iddemodelisme.idde_cart_discount' doesn't exist [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_order_discount` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Table 'iddemodelisme.idde_order_discount' doesn't exist [ERROR] SQL 1.5.0.1 1146 in ALTER TABLE `idde_order_discount` CHANGE `id_order_discount` `id_order_cart_rule` int(10) unsigned NOT NULL AUTO_INCREMENT: Table 'iddemodelisme.idde_order_discount' doesn't exist [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `idde_order_discount` TO `idde_order_cart_rule`: Table 'idde_order_cart_rule' already exists [ERROR] SQL 1.5.0.1 1050 in RENAME TABLE `idde_cart_discount` TO `idde_cart_cart_rule`: Table 'idde_cart_cart_rule' already exists [ERROR] SQL 1.5.0.1 1062 in UPDATE `idde_hook` SET `name` = 'actionTaxManager' WHERE `name` = 'taxManager': Duplicate entry 'actionTaxManager' for key 'hook_name' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_order_detail_tax` ADD `unit_amount` DECIMAL(16, 6) NOT NULL AFTER `id_tax`, ADD `total_amount` DECIMAL(16, 6) NOT NULL AFTER `unit_amount`: Duplicate column name 'unit_amount' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_specific_price` ADD `id_product_attribute` INT UNSIGNED NOT NULL AFTER `id_product`: Duplicate column name 'id_product_attribute' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_cart` ADD COLUMN `delivery_option` varchar(100) AFTER `id_carrier`: Duplicate column name 'delivery_option' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_order_carrier` ( `id_order_carrier` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) unsigned NOT NULL, `id_carrier` int(11) unsigned NOT NULL, `id_order_invoice` int(11) unsigned DEFAULT NULL, `weight` float DEFAULT NULL, `shipping_cost_tax_excl` decimal(20,6) DEFAULT NULL, `shipping_cost_tax_incl` decimal(20,6) DEFAULT NULL, `tracking_number` varchar(64) DEFAULT NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_order_carrier`), KEY `id_order` (`id_order`), KEY `id_carrier` (`id_carrier`), KEY `id_order_invoice` (`id_order_invoice`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_order_carrier' already exists [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_order_slip` ADD COLUMN `amount` DECIMAL(10,2) NOT NULL AFTER `shipping_cost`: Duplicate column name 'amount' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_order_slip` ADD COLUMN `shipping_cost_amount` DECIMAL(10,2) NOT NULL AFTER `amount`: Duplicate column name 'shipping_cost_amount' [ERROR] SQL 1.5.0.1 1060 in ALTER TABLE `idde_order_slip` ADD COLUMN `partial` TINYINT(1) NOT NULL AFTER `shipping_cost_amount`: Duplicate column name 'partial' [ERROR] SQL 1.5.0.1 1050 in CREATE TABLE `idde_hook_alias` ( `id_hook_alias` int(10) unsigned NOT NULL auto_increment, `alias` varchar(64) NOT NULL, `name` varchar(64) NOT NULL, PRIMARY KEY (`id_hook_alias`), UNIQUE KEY `alias` (`alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_hook_alias' already exists [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `idde_hook_alias` (`id_hook_alias`, `name`, `alias`) VALUES (1, 'displayPayment', 'payment'), (2, 'actionValidateOrder', 'newOrder'), (3, 'actionPaymentConfirmation', 'paymentConfirm'), (4, 'displayPaymentReturn', 'paymentReturn'), (5, 'actionUpdateQuantity', 'updateQuantity'), (6, 'displayRightColumn', 'rightColumn'), (7, 'displayLeftColumn', 'leftColumn'), (8, 'displayHome', 'home'), (9, 'displayHeader', 'header'), (10, 'actionCartSave', 'cart'), (11, 'actionAuthentication', 'authentication'), (12, 'actionProductAdd', 'addproduct'), (13, 'actionProductUpdate', 'updateproduct'), (14, 'displayTop', 'top'), (15, 'displayRightColumnProduct', 'extraRight'), (16, 'actionProductDelete', 'deleteproduct'), (17, 'displayFooterProduct', 'productfooter'), (18, 'displayInvoice', 'invoice'), (19, 'actionOrderStatusUpdate', 'updateOrderStatus'), (20, 'displayAdminOrder', 'adminOrder'), (21, 'displayFooter', 'footer'), (22, 'displayPDFInvoice', 'PDFInvoice'), (23, 'displayAdminCustomers', 'adminCustomers'), (24, 'displayOrderConfirmation', 'orderConfirmation'), (25, 'actionCustomerAccountAdd', 'createAccount'), (26, 'displayCustomerAccount', 'customerAccount'), (27, 'actionOrderSlipAdd', 'orderSlip'), (28, 'displayProductTab', 'productTab'), (29, 'displayProductTabContent', 'productTabContent'), (30, 'displayShoppingCartFooter', 'shoppingCart'), (31, 'displayCustomerAccountForm', 'createAccountForm'), (32, 'displayAdminStatsModules', 'AdminStatsModules'), (33, 'displayAdminStatsGraphEngine', 'GraphEngine'), (34, 'actionOrderReturn', 'orderReturn'), (35, 'displayProductButtons', 'productActions'), (36, 'displayBackOfficeHome', 'backOfficeHome'), (37, 'displayAdminStatsGridEngine', 'GridEngine'), (38, 'actionWatermark', 'watermark'), (39, 'actionProductCancel', 'cancelProduct'), (40, 'displayLeftColumnProduct', 'extraLeft'), (41, 'actionProductOutOfStock', 'productOutOfStock'), (42, 'actionProductAttributeUpdate', 'updateProductAttribute'), (43, 'displayCarrierList', 'extraCarrier'), (44, 'displayShoppingCart', 'shoppingCartExtra'), (45, 'actionSearch', 'search'), (46, 'displayBeforePayment', 'backBeforePayment'), (47, 'actionCarrierUpdate', 'updateCarrier'), (48, 'actionOrderStatusPostUpdate', 'postUpdateOrderStatus'), (49, 'displayCustomerAccountFormTop', 'createAccountTop'), (50, 'displayBackOfficeHeader', 'backOfficeHeader'), (51, 'displayBackOfficeTop', 'backOfficeTop'), (52, 'displayBackOfficeFooter', 'backOfficeFooter'), (53, 'actionProductAttributeDelete', 'deleteProductAttribute'), (54, 'actionCarrierProcess', 'processCarrier'), (55, 'actionOrderDetail', 'orderDetail'), (56, 'displayBeforeCarrier', 'beforeCarrier'), (57, 'displayOrderDetail', 'orderDetailDisplayed'), (58, 'actionPaymentCCAdd', 'paymentCCAdded'), (59, 'displayProductComparison', 'extraProductComparison'), (60, 'actionCategoryAdd', 'categoryAddition'), (61, 'actionCategoryUpdate', 'categoryUpdate'), (62, 'actionCategoryDelete', 'categoryDeletion'), (63, 'actionBeforeAuthentication', 'beforeAuthentication'), (64, 'displayPaymentTop', 'paymentTop'), (65, 'actionHtaccessCreate', 'afterCreateHtaccess'), (66, 'actionAdminMetaSave', 'afterSaveAdminMeta'), (67, 'displayAttributeGroupForm', 'attributeGroupForm'), (68, 'actionAttributeGroupSave', 'afterSaveAttributeGroup'), (69, 'actionAttributeGroupDelete', 'afterDeleteAttributeGroup'), (70, 'displayFeatureForm', 'featureForm'), (71, 'actionFeatureSave', 'afterSaveFeature'), (72, 'actionFeatureDelete', 'afterDeleteFeature'), (73, 'actionProductSave', 'afterSaveProduct'), (74, 'actionProductListOverride', 'productListAssign'), (75, 'displayAttributeGroupPostProcess', 'postProcessAttributeGroup'), (76, 'displayFeaturePostProcess', 'postProcessFeature'), (77, 'displayFeatureValueForm', 'featureValueForm'), (78, 'displayFeatureValuePostProcess', 'postProcessFeatureValue'), (79, 'actionFeatureValueDelete', 'afterDeleteFeatureValue'), (80, 'actionFeatureValueSave', 'afterSaveFeatureValue'), (81, 'displayAttributeForm', 'attributeForm'), (82, 'actionAttributePostProcess', 'postProcessAttribute'), (83, 'actionAttributeDelete', 'afterDeleteAttribute'), (84, 'actionAttributeSave', 'afterSaveAttribute'), (85, 'actionTaxManager', 'taxManager'): Duplicate entry '1' for key 'PRIMARY' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_module` ADD `version` VARCHAR( 8 ) NOT NULL: Duplicate column name 'version' [ERROR] SQL 1.5.0.2 1050 in CREATE TABLE `idde_specific_price_rule_condition_group` ( `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL, `id_specific_price_rule` INT(11) UNSIGNED NOT NULL, PRIMARY KEY ( `id_specific_price_rule_condition_group`, `id_specific_price_rule` ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_specific_price_rule_condition_group' already exists [ERROR] SQL 1.5.0.2 1050 in CREATE TABLE `idde_specific_price_rule_condition` ( `id_specific_price_rule_condition` INT(11) UNSIGNED NOT NULL, `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL, `type` VARCHAR(255) NOT NULL, `value` VARCHAR(255) NOT NULL, PRIMARY KEY (`id_specific_price_rule_condition`), INDEX (`id_specific_price_rule_condition_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_specific_price_rule_condition' already exists [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_specific_price` ADD `id_specific_price_rule` INT(11) UNSIGNED NOT NULL AFTER `id_specific_price`, ADD INDEX (`id_specific_price_rule`): Duplicate column name 'id_specific_price_rule' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_invoice` ADD `note` TEXT NOT NULL AFTER `total_wrapping_tax_incl`: Duplicate column name 'note' [ERROR] SQL 1.5.0.2 1060 in /* ORDER STATES */ ALTER TABLE `idde_order_state` ADD `paid` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `shipped`: Duplicate column name 'paid' [ERROR] SQL 1.5.0.2 1060 in /* SPECIFIC PRICE */ ALTER TABLE `idde_specific_price` ADD `id_customer` INT UNSIGNED NOT NULL AFTER `id_group`: Duplicate column name 'id_customer' [ERROR] PHP 1.5.0.2 /* Update records before alter tables */ /* PHP:set_stock_available(); */ 1054 - (products)Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_address` ADD COLUMN `id_warehouse` int(10) unsigned NOT NULL DEFAULT 0 AFTER `id_supplier`: Duplicate column name 'id_warehouse' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_detail` ADD COLUMN `id_warehouse` int(10) unsigned NOT NULL default '0' AFTER `id_order_invoice`: Duplicate column name 'id_warehouse' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_stock_mvt_reason` ADD COLUMN `deleted` tinyint(1) unsigned NOT NULL default '0' AFTER `date_upd`: Duplicate column name 'deleted' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_product` ADD COLUMN `advanced_stock_management` tinyint(1) default '0' NOT NULL: Duplicate column name 'advanced_stock_management' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_detail` ADD `reduction_amount_tax_incl` DECIMAL( 20, 6 ) NOT NULL AFTER `reduction_amount` , ADD `reduction_amount_tax_excl` DECIMAL( 20, 6 ) NOT NULL AFTER `reduction_amount_tax_incl`, ADD `total_price_tax_incl` DECIMAL(20, 6) NOT NULL AFTER `download_deadline`, ADD `total_price_tax_excl` DECIMAL(20, 6) NOT NULL AFTER `total_price_tax_incl`, ADD `unit_price_tax_incl` DECIMAL(20, 6) NOT NULL AFTER `total_price_tax_excl`, ADD `unit_price_tax_excl` DECIMAL(20, 6) NOT NULL AFTER `unit_price_tax_incl`, ADD `total_shipping_price_tax_incl` DECIMAL(20, 6) NOT NULL AFTER `unit_price_tax_excl`, ADD `total_shipping_price_tax_excl` DECIMAL(20, 6) NOT NULL AFTER `total_shipping_price_tax_incl`, ADD `purchase_supplier_price` DECIMAL(20, 6) NOT NULL AFTER `total_shipping_price_tax_excl`, ADD `original_product_price` DECIMAL(20, 6) NOT NULL AFTER `purchase_supplier_price`: Duplicate column name 'reduction_amount_tax_incl' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_orders` ADD `total_discounts_tax_excl` decimal(17,2) NOT NULL AFTER `total_discounts`, ADD `total_discounts_tax_incl` decimal(17,2) NOT NULL AFTER `total_discounts_tax_excl`, ADD `total_paid_tax_excl` decimal(17,2) NOT NULL AFTER `total_paid`, ADD `total_paid_tax_incl` decimal(17,2) NOT NULL AFTER `total_paid_tax_excl`, ADD `total_shipping_tax_excl` decimal(17,2) NOT NULL AFTER `total_shipping`, ADD `total_shipping_tax_incl` decimal(17,2) NOT NULL AFTER `total_shipping_tax_excl`, ADD `total_wrapping_tax_excl` decimal(17,2) NOT NULL AFTER `total_wrapping`, ADD `total_wrapping_tax_incl` decimal(17,2) NOT NULL AFTER `total_wrapping_tax_excl`: Duplicate column name 'total_discounts_tax_excl' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_cart_rule` ADD `value_tax_excl` DECIMAL(17, 2) NOT NULL DEFAULT '0.00': Duplicate column name 'value_tax_excl' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_cart_rule` ADD `id_order_invoice` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `id_cart_rule`: Duplicate column name 'id_order_invoice' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_detail` ADD `tax_computation_method` tinyint(1) unsigned NOT NULL default '0' AFTER `product_weight`: Duplicate column name 'tax_computation_method' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_invoice` ADD `delivery_number` int(0) NOT NULL DEFAULT '0' AFTER `number`: Duplicate column name 'delivery_number' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_invoice` ADD `delivery_date` datetime AFTER `delivery_number`: Duplicate column name 'delivery_date' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_tab` ADD `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1': Duplicate column name 'active' [ERROR] SQL 1.5.0.2 1242 in UPDATE `idde_order_detail` od SET od.`id_order_invoice` = ( SELECT oi.`id_order_invoice` FROM `idde_order_invoice` oi WHERE oi.`id_order` = od.`id_order` ): Subquery returns more than 1 row [ERROR] SQL 1.5.0.2 1242 in INSERT INTO `idde_order_carrier` (`id_order`, `id_carrier`, `id_order_invoice`, `weight`, `shipping_cost_tax_excl`, `shipping_cost_tax_incl`, `tracking_number`, `date_add`) ( SELECT `id_order`, `id_carrier`, ( SELECT oi.`id_order_invoice` FROM `idde_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), ( SELECT SUM(`product_weight`) FROM `idde_order_detail` od WHERE od.`id_order` = o.`id_order` ), `total_shipping_tax_excl`, `total_shipping_tax_incl`, `shipping_number`, `date_add` FROM `idde_orders` o ): Subquery returns more than 1 row [ERROR] SQL 1.5.0.2 1054 in INSERT IGNORE INTO `idde_order_payment` (`id_order_invoice`, `id_order`, `id_currency`, `amount`, `payment_method`, `conversion_rate`, `date_add`) ( SELECT ( SELECT oi.`id_order_invoice` FROM `idde_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), o.`id_order`, o.`id_currency`, o.`total_paid_real`, o.`payment`, o.`conversion_rate`, o.`date_add` FROM `idde_orders` o LEFT JOIN `idde_order_payment` op ON (op.`id_order` = o.`id_order`) WHERE op.`id_order_payment` IS NULL ): Unknown column 'op.id_order' in 'on clause' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_specific_price` ADD `id_cart` INT(11) UNSIGNED NOT NULL AFTER `id_specific_price_rule`: Duplicate column name 'id_cart' [ERROR] SQL 1.5.0.2 1061 in ALTER TABLE `idde_specific_price` ADD INDEX `id_cart` (`id_cart`): Duplicate key name 'id_cart' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_slip_detail` CHANGE `amount` `amount_tax_excl` DECIMAL( 10, 2 ) default NULL: Duplicate column name 'amount_tax_excl' [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_order_slip_detail` ADD COLUMN `amount_tax_incl` DECIMAL(10,2) default NULL AFTER `amount_tax_excl`: Duplicate column name 'amount_tax_incl' [ERROR] SQL 1.5.0.2 1050 in CREATE TABLE `idde_webservice_account_shop` ( `id_webservice_account` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_webservice_account` , `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_webservice_account_shop' already exists [ERROR] SQL 1.5.0.2 1060 in ALTER TABLE `idde_group` ADD `show_prices` tinyint(1) unsigned NOT NULL DEFAULT '1' AFTER `price_display_method`: Duplicate column name 'show_prices' [ERROR] SQL 1.5.0.3 1060 in ALTER TABLE `idde_theme` ADD COLUMN directory varchar(64) NOT NULL: Duplicate column name 'directory' [ERROR] SQL 1.5.0.4 1060 in ALTER TABLE `idde_category` ADD COLUMN `is_root_category` tinyint(1) NOT NULL default '0' AFTER `position`: Duplicate column name 'is_root_category' [ERROR] SQL 1.5.0.4 1050 in CREATE TABLE `idde_category_shop` ( `id_category` int(11) NOT NULL, `id_shop` int(11) NOT NULL, PRIMARY KEY (`id_category`, `id_shop`), UNIQUE KEY `id_category_shop` (`id_category`,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_category_shop' already exists [ERROR] PHP 1.5.0.4 /* PHP:update_mailalerts_add_column_idshop(); */ 1 - unable to create column id_shop (Duplicate column name 'id_shop') [ERROR] SQL 1.5.0.4 1050 in CREATE TABLE `idde_cart_rule_product_rule_group` ( `id_product_rule_group` int(10) unsigned NOT NULL auto_increment, `id_cart_rule` int(10) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL default 1, PRIMARY KEY (`id_product_rule_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_product_rule_group' already exists [ERROR] SQL 1.5.0.4 1054 in INSERT INTO `idde_cart_rule_product_rule_group` (`id_product_rule_group`, `id_cart_rule`, `quantity`) ( SELECT `id_cart_rule`, `id_cart_rule`, `quantity` FROM `idde_cart_rule_product_rule` ): Unknown column 'id_cart_rule' in 'field list' [ERROR] SQL 1.5.0.4 1054 in ALTER TABLE `idde_cart_rule_product_rule` CHANGE `id_cart_rule` `id_product_rule_group` int(10) unsigned NOT NULL: Unknown column 'id_cart_rule' in 'idde_cart_rule_product_rule' [ERROR] SQL 1.5.0.4 1060 in ALTER TABLE `idde_cart_rule` ADD `partial_use` tinyint(1) unsigned NOT NULL default 0 AFTER `priority`: Duplicate column name 'partial_use' [ERROR] SQL 1.5.0.4 1060 in ALTER TABLE `idde_orders` ADD `current_state` int(10) unsigned NOT NULL default 0 AFTER `id_address_invoice`: Duplicate column name 'current_state' [ERROR] SQL 1.5.0.5 1060 in ALTER TABLE `idde_cart_rule` ADD `shop_restriction` tinyint(1) unsigned NOT NULL default 0 AFTER `product_restriction`: Duplicate column name 'shop_restriction' [ERROR] SQL 1.5.0.5 1050 in CREATE TABLE `idde_cart_rule_shop` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_cart_rule_shop' already exists [ERROR] SQL 1.5.0.5 1054 in INSERT INTO `idde_configuration`(`id_group_shop`, `id_shop`, `name`, `value`, `date_add`, `date_upd`) VALUES (NULL, NULL, 'PS_LOGO', 'logo.jpg', NOw(), NOW()), (NULL, NULL, 'PS_LOGO_MAIL', 'logo_mail.jpg', NOw(), NOW()), (NULL, NULL, 'PS_LOGO_INVOICE', 'logo_invoice.jpg', NOW(), NOW()), (NULL, NULL, 'PS_FAVICON', 'favicon.jpg', NOW(), NOW()), (NULL, NULL, 'PS_STORES_ICON', 'logo_stores.gif', NOW(), NOW()): Unknown column 'id_group_shop' in 'field list' [ERROR] SQL 1.5.0.5 1050 in CREATE TABLE `idde_module_preference` ( `id_module_preference` int(11) NOT NULL auto_increment, `id_employee` int(11) NOT NULL, `module` varchar(255) NOT NULL, `interest` tinyint(1) default NULL, `favorite` tinyint(1) default NULL, PRIMARY KEY (`id_module_preference`), UNIQUE KEY `employee_module` (`id_employee`, `module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_module_preference' already exists [ERROR] SQL 1.5.0.5 1060 in ALTER TABLE `idde_category_shop` ADD `position` int(10) unsigned NOT NULL default 0 AFTER `id_shop`: Duplicate column name 'position' [ERROR] SQL 1.5.0.7 1060 in ALTER TABLE `idde_cart_rule` ADD `gift_product_attribute` int(10) unsigned NOT NULL default 0 AFTER `gift_product`: Duplicate column name 'gift_product_attribute' [ERROR] SQL 1.5.0.7 1060 in ALTER TABLE `idde_product_shop` ADD `id_category_default` int(11) UNSIGNED DEFAULT NULL: Duplicate column name 'id_category_default' [ERROR] SQL 1.5.0.7 1060 in ALTER TABLE `idde_employee` ADD `bo_width` int(10) unsigned NOT NULL DEFAULT 0 AFTER `bo_theme`: Duplicate column name 'bo_width' [ERROR] SQL 1.5.0.7 1050 in CREATE TABLE `idde_carrier_tax_rules_group_shop` ( `id_carrier` int(11) unsigned NOT NULL, `id_tax_rules_group` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, PRIMARY KEY (`id_carrier`, `id_tax_rules_group`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_carrier_tax_rules_group_shop' already exists [ERROR] SQL 1.5.0.7 1062 in INSERT INTO `idde_carrier_tax_rules_group_shop` (`id_carrier`, `id_tax_rules_group`, `id_shop`) (SELECT `id_carrier`, `id_tax_rules_group`, `id_shop` FROM `idde_carrier`, `idde_shop`): Duplicate entry '1-0-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.8 1060 in ALTER TABLE `idde_product` ADD `visibility` ENUM('both', 'catalog', 'search', 'none') NOT NULL default 'both' AFTER `indexed`: Duplicate column name 'visibility' [ERROR] SQL 1.5.0.9 1060 in ALTER TABLE `idde_employee` ADD `default_tab` int(10) unsigned NOT NULL default 0 AFTER `bo_theme`: Duplicate column name 'default_tab' [ERROR] SQL 1.5.0.9 1051 in DROP TABLE `idde_subdomain`: Unknown table 'idde_subdomain' [ERROR] SQL 1.5.0.10 1050 in RENAME TABLE `idde_group_shop` TO `idde_shop_group`: Table 'idde_shop_group' already exists [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_shop_group` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT: Unknown column 'id_group_shop' in 'idde_shop_group' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_shop' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_stock_available' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_cart` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_cart' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_configuration` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL: Unknown column 'id_group_shop' in 'idde_configuration' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_connections` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_connections' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_customer` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_customer' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_delivery` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL: Unknown column 'id_group_shop' in 'idde_delivery' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_orders` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_orders' [ERROR] SQL 1.5.0.10 1054 in ALTER TABLE `idde_page_viewed` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Unknown column 'id_group_shop' in 'idde_page_viewed' [ERROR] SQL 1.5.0.10 1060 in ALTER TABLE `idde_specific_price` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL: Duplicate column name 'id_shop_group' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_product_attribute_shop` ( `id_product_attribute` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, `wholesale_price` decimal(20,6) NOT NULL default '0.000000', `price` decimal(20,6) NOT NULL default '0.000000', `ecotax` decimal(17,6) NOT NULL default '0.00', `weight` float NOT NULL default '0', `unit_price_impact` decimal(17,2) NOT NULL default '0.00', `default_on` tinyint(1) unsigned NOT NULL default '0', `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1', `available_date` date NOT NULL, PRIMARY KEY (`id_product_attribute`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_product_attribute_shop' already exists [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_attribute_shop` ( `id_attribute` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_attribute`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_attribute_shop' already exists [ERROR] SQL 1.5.0.10 1054 in INSERT INTO `idde_attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM idde_attribute_group_shop a LEFT JOIN idde_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN idde_shop c ON b.id_shop_group = c.id_shop_group): Unknown column 'a.id_attribute' in 'field list' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_feature_shop` ( `id_feature` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_feature`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_feature_shop' already exists [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_group_shop` ( `id_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_group_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `idde_group_shop` (`id_group`, `id_shop`) (SELECT a.id_group, c.id_shop FROM idde_group_group_shop a LEFT JOIN idde_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN idde_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_tax_rules_group_shop` ( `id_tax_rules_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_tax_rules_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_tax_rules_group_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `idde_tax_rules_group_shop` (`id_tax_rules_group`, `id_shop`) (SELECT a.id_tax_rules_group, c.id_shop FROM idde_tax_rules_group_group_shop a LEFT JOIN idde_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN idde_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_zone_shop` ( `id_zone` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_zone`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_zone_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `idde_zone_shop` (`id_zone`, `id_shop`) (SELECT a.id_zone, c.id_shop FROM idde_zone_group_shop a LEFT JOIN idde_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN idde_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_manufacturer_shop` ( `id_manufacturer` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_manufacturer`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_manufacturer_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `idde_manufacturer_shop` (`id_manufacturer`, `id_shop`) (SELECT a.id_manufacturer, c.id_shop FROM idde_manufacturer_group_shop a LEFT JOIN idde_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN idde_shop c ON b.id_shop_group = c.id_shop_group): Duplicate entry '1-1' for key 'PRIMARY' [ERROR] SQL 1.5.0.10 1050 in CREATE TABLE `idde_supplier_shop` ( `id_supplier` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_supplier`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_supplier_shop' already exists [ERROR] SQL 1.5.0.13 1050 in -- Update order_payment structure for multishipping -- Step 1: Add the table ps_order_invoice_payment and populate it CREATE TABLE `idde_order_invoice_payment` ( `id_order_invoice` int(11) unsigned NOT NULL, `id_order_payment` int(11) unsigned NOT NULL, `id_order` int(11) unsigned NOT NULL, PRIMARY KEY (`id_order_invoice`,`id_order_payment`), KEY `order_payment` (`id_order_payment`), KEY `id_order` (`id_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'idde_order_invoice_payment' already exists [ERROR] SQL 1.5.0.13 1054 in INSERT INTO `idde_order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `idde_order_payment` WHERE id_order_invoice > 0): Unknown column 'id_order_invoice' in 'field list' [ERROR] SQL 1.5.0.13 1054 in -- Step 2: Add the collumn id_order_reference ALTER TABLE `idde_order_payment` ADD COLUMN `order_reference` VARCHAR(9) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`): Unknown column 'id_order' in 'idde_order_payment' [ERROR] PHP 1.5.0.13 -- Step 3: Fill in id_order_reference and merge duplicate lines /* PHP:add_order_reference_in_order_payment(); */ [ERROR] SQL 1.5.0.13 1091 in -- Step 4: Drop collumn id_order ALTER TABLE `idde_order_payment` DROP COLUMN `id_order`, DROP COLUMN `id_order_invoice`: Can't DROP 'id_order'; check that column/key exists [ERROR] SQL 1.5.0.14 1062 in INSERT INTO `idde_hook_alias` (`name`, `alias`) VALUES ('displayMyAccountBlock', 'myAccountBlock'): Duplicate entry 'myAccountBlock' for key 'alias' [ERROR] SQL 1.5.0.14 1060 in ALTER TABLE `idde_order_invoice` ADD `shipping_tax_computation_method` INT NOT NULL AFTER `total_shipping_tax_incl`: Duplicate column name 'shipping_tax_computation_method' [ERROR] SQL 1.5.0.15 1060 in ALTER TABLE `idde_order_state` ADD `module_name` VARCHAR(255) NULL DEFAULT NULL AFTER `send_email`: Duplicate column name 'module_name' [ERROR] SQL 1.5.0.16 1060 in ALTER TABLE `idde_order_detail` ADD `id_shop` INT(11) UNSIGNED NOT NULL AFTER `id_warehouse`, ADD INDEX (`id_shop`): Duplicate column name 'id_shop' [ERROR] SQL 1.5.0.16 1061 in ALTER TABLE `idde_tax_rule` ADD INDEX `category_getproducts` ( `id_tax_rules_group` , `id_country` , `id_state` , `zipcode_from` ): Duplicate key name 'category_getproducts' [ERROR] SQL 1.5.0.16 1060 in ALTER TABLE `idde_product` ADD `id_shop_default` int(10) unsigned NOT NULL default 1 AFTER `id_category_default`: Duplicate column name 'id_shop_default' [ERROR] SQL 1.5.0.16 1060 in ALTER TABLE `idde_category` ADD `id_shop_default` int(10) unsigned NOT NULL default 1 AFTER `id_parent`: Duplicate column name 'id_shop_default' [ERROR] SQL 1.5.0.17 1060 in ALTER TABLE `idde_customer_message` ADD `read` tinyint(1) NOT NULL default '0' AFTER `private`: Duplicate column name 'read' [ERROR] SQL 1.5.1.0 1060 in ALTER TABLE `idde_image_shop` ADD `cover` TINYINT(1) UNSIGNED NOT NULL AFTER `id_shop`: Duplicate column name 'cover' [ERROR] SQL 1.5.1.0 1091 in ALTER TABLE `idde_image_shop` DROP PRIMARY KEY: Can't DROP 'PRIMARY'; check that column/key exists Erreur(s) détectée(s) pendant la mise à jour. --------------------------------- Edited October 9, 2012 by bdevries (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts