Lanaworks Posted December 13, 2012 Share Posted December 13, 2012 (edited) Bonjour, Quelques petites erreurs SQL suite à une mise à jour de 1.4.9 en 1.5.2. [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.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 'id_order_invoice' in 'field list' [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 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_invoice'; check that column/key exists Après quelques tests, je n'ai pas eu d'erreurs... mais je préfèrerai mettre en production une version stable de ma 1.5.2. Si vous avez des solutions je suis preneur. Merci. Edited December 14, 2012 by Weetabix40 (see edit history) Link to comment Share on other sites More sharing options...
Muad'Dib Posted December 13, 2012 Share Posted December 13, 2012 (edited) Bonjour, Ces erreurs me semblent sans la moindre importance. Perso lors de ma MAJ de 1.2.5 à 1.5.2 j'ai eu 48 erreurs SQL. Après avoir regardé de quoi il s'agissait exactement, j'ai pu constater que pour des raisons que j'ignore les scripts d'updates essayaient de faire des changements qui avaient déjà été effectués probablement sur une version mineure précédente et oubliés dans le nouveau fichier. Typiquement lorsque le script de MAJ essaie d'enlever un champs qui n'est pas là au départ, ce n'est pas trop inquiétant Après tout le résultat est le même le champs n'est pas là Bref a mon humble avis, sans importance. Bon courage! A+ Edited December 13, 2012 by Muad'Dib (see edit history) Link to comment Share on other sites More sharing options...
Lanaworks Posted December 13, 2012 Author Share Posted December 13, 2012 Merci pour cette réponse. Je pense cependant que les tables "ps_order_payment" et "ps_payment_cc" doivent être corrigées : - "ps_order_payment" retourne 36 enregistrements? - "ps_payment_cc" retourne tous les autres enregistrements. La table "ps_order_payment" enregistre les nouveaux paiements mais avec un id_order qui reste à 0. De mon avis c'est un peu trop risqué pour une mise en production. En espérant qu'un dev prestashop passe par là avant noël... Link to comment Share on other sites More sharing options...
X@vier Posted December 14, 2012 Share Posted December 14, 2012 Bonjour, je viens de tenter une mise à jour de 1.4.9 vers 1.5.2 avec le "1 click autoupgrade v 0.9.4" qui s'est soldé par une restauration de la base suite a un paquet d'erreurs SQL. J'ai eu exactement le même problème à ma dernière tentaive de MAJ en tentant 1.4.9 vers 1.5.0 avec le "1click autoupgrade V 0.9.3" qui s'est soldé à un retour vers 1.4.9. La différence la première fois la restauration s'est très bien passé et cette fois ci à près la restauration, plus de boutique, page d'accueil en erreur 500 et plus de mot de passe pour l'accès au BO. J'ai du passer par Phpmyadmin pour restaurer les tables. bilan : 3 heures de perdues et le moral dans les godasses pour un Prestashop de base :-( 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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 '1-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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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 '10-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=MyISAM 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 '1-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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8: Table 'ps_scene_shop' already exists [ERROR] SQL 1.5.0.0 1062 in INSERT INTO `ps_scene_shop` (id_shop, id_scene) (SELECT 1, id_scene FROM ps_scene): Duplicate entry '1-1' for key 'PRIMARY' [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-1' 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=MyISAM 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=MyISAM 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 = MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8: Table 'ps_cart_rule_product_rule' already exists [ERROR] SQL 1.5.0.1 1062 in INSERT INTO `ps_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 `ps_discount` ): Duplicate entry '1' for key 'PRIMARY' [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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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 1242 in UPDATE `ps_order_detail` od SET od.`id_order_invoice` = ( SELECT oi.`id_order_invoice` FROM `ps_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 `ps_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 `ps_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), ( SELECT SUM(`product_weight`) FROM `ps_order_detail` od WHERE od.`id_order` = o.`id_order` ), `total_shipping_tax_excl`, `total_shipping_tax_incl`, `shipping_number`, `date_add` FROM `ps_orders` o ): Subquery returns more than 1 row [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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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 '1-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=MyISAM DEFAULT CHARSET=utf8: Table 'ps_product_attribute_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_product_attribute_shop` (`id_product_attribute`, `id_shop`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) (SELECT `id_product_attribute`, (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_SHOP_DEFAULT'), `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date` FROM `ps_product_attribute`): Duplicate entry '53-1' for key 'PRIMARY' [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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8: Table 'ps_feature_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_feature_shop` (`id_feature`, `id_shop`) (SELECT a.id_feature, c.id_shop FROM ps_feature_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_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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8: Table 'ps_manufacturer_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_manufacturer_shop` (`id_manufacturer`, `id_shop`) (SELECT a.id_manufacturer, c.id_shop FROM ps_manufacturer_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 '3-1' for key 'PRIMARY' [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=MyISAM DEFAULT CHARSET=utf8: Table 'ps_supplier_shop' already exists [ERROR] SQL 1.5.0.10 1062 in INSERT INTO `ps_supplier_shop` (`id_supplier`, `id_shop`) (SELECT a.id_supplier, c.id_shop FROM ps_supplier_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 '43-1' for key 'PRIMARY' [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=MyISAM 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.1.0 1060 in ALTER TABLE `ps_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 `ps_image_shop` DROP PRIMARY KEY: Can't DROP 'PRIMARY'; check that column/key exists Erreur(s) détectée(s) pendant la mise à jour. Link to comment Share on other sites More sharing options...
barrejat Posted February 4, 2013 Share Posted February 4, 2013 I have the same problem, Xavier. Did you find a solution for upgrading to 1.5.x? Link to comment Share on other sites More sharing options...
X@vier Posted February 5, 2013 Share Posted February 5, 2013 Non, Il y a maintenant un nouveau module mais d'après ce que j'ai pu lire ça ne règle pas le problème SQL. Personnellement, j'attends de lire sur le forum que le problème est réglé. Je n'ai pas le temps de passer de 1-2 jours pour faire la mise à jour et restaurer la sauvegarde. Peut-être qu'au mois de mars 2013 ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now