1-Click Upgrade 1.5.0.9 to 1.5.3.1 issues

[[email protected]]

I'm able to run the 1-click upgrade on our test server, for Prestashop 1.5.0.9. We urgently need to get the codebase up to 1.5.3.1, as our customers are having issues we need resolved as soon as possible.

 

However, when I run the upgrade, I get a list of MySQL errors. I've posted them towards the end of this post.

 

When logging out, and back into Prestashop, I can see I am on 1.5.3.1, and everything appears to be working okay. Only until I re-enable Multistore. When I do this, I get a PHP error saying:

 

 

[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP Fatal error:  Call to undefined method Shop::getContextGroupShopID() in /usr/share/oursite.com/releases/20130326091537/override/classes/controller/AdminController.php on line 52, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP Stack trace:, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP   1. {main}() /usr/share/oursite.com/releases/20130326091537/admin75149/index.php:0, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP   2. DispatcherCore->dispatch() /usr/share/oursite.com/releases/20130326091537/admin75149/index.php:50, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP   3. ControllerCore::getController() /usr/share/oursite.com/releases/20130326091537/classes/Dispatcher.php:341, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP   4. AdminShopGroupControllerCore->__construct() /usr/share/oursite.com/releases/20130326091537/classes/controller/Controller.php:128, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP   5. AdminControllerCore->__construct() /usr/share/oursite.com/releases/20130326091537/controllers/admin/AdminShopGroupController.php:85, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940
[Tue Mar 26 09:39:25 2013] [error] [client 105.237.19.116] PHP   6. AdminController->initShopContext() /usr/share/oursite.com/releases/20130326091537/classes/controller/AdminController.php:331, referer: http://test.oursite.com/admin12345/index.php?controller=AdminPreferences&token=28ce4df9f7a86a191785c9970190d940

 

Any idea how we can fix this?

 

MySQL Errors During Upgrade:

 

 

[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 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 1062 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): Duplicate entry '1-14' for key 'PRIMARY'

[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 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-14' 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=InnoDB DEFAULT CHARSET=utf8: Table 'ps_group_shop' already exists

[ERROR] SQL 1.5.0.10 1054 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): Unknown column 'id_group' in 'field list'

[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-14' 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-14' 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 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 '1-14' 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=InnoDB 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 '1-14' 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=InnoDB DEFAULT CHARSET=utf8: Table 'ps_order_invoice_payment' already exists

[ERROR] SQL 1.5.0.13 1062 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): Duplicate entry '1-1' for key 'PRIMARY'

[ERROR] PHP 1.5.0.13 /* PHP:p15013_add_missing_columns(); */ 1 - Duplicate column name 'id_shop'

[ERROR] PHP 1.5.0.16 /* PHP:p15016_add_missing_columns(); */ 1 - Unknown column 'id_reinsurance' in 'ps_reinsurance'

Warning detected during upgrade.

[[email protected]]

Problem solved, we had some overrides lying around that needed to be changed!