Unable to upgrade Prestashop 1.5.3.1 to 1.5.4

[denzar]

Hello,

 

I am using my managed dedicated server with Plesk for Prestashop. I was able to install Prestashop on my server with Plesk control panel, however Plesk installs 1.5.3.1 version while Prestashop now offers 1.5.4

 

I installed 1-click upgrade module in my store admin panel and tried to run an upgrade. I put the store under maintenance just like I am suppose to. Selected to backup database and images, also selected “yes” to disable non-native modules, selected “yes” to upgrading default themes and “no” to upgrading default emails. Upgrade check list shows all green checkmarks!

 

When I click on “Upgrade PrestaShop Now” – I get the following errors:

Upgrade complete, but warnings has been found.

 

Errors:

[ERROR] SQL 1.5.4.0 1060 in ALTER TABLE `prstshp_customer` ADD `id_lang` INT UNSIGNED NULL AFTER `id_default_group`: Duplicate column name 'id_lang'

[ERROR] SQL 1.5.4.0 1060 in ALTER TABLE `prstshp_order_cart_rule` ADD `free_shipping` tinyint(1) NOT NULL DEFAULT 0 AFTER `value_tax_excl`: Duplicate column name 'free_shipping'

[ERROR] SQL 1.5.4.0 1050 in CREATE TABLE `prstshp_tab_module_preference` ( `id_tab_module_preference` int(11) NOT NULL auto_increment, `id_employee` int(11) NOT NULL, `id_tab` int(11) NOT NULL, `module` varchar(255) NOT NULL, PRIMARY KEY (`id_tab_module_preference`), UNIQUE KEY `employee_module` (`id_employee`, `id_tab`, `module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Table 'prstshp_tab_module_preference' already exists

[ERROR] PHP 1.5.4.0 /* PHP:p1540_add_missing_columns(); */ 1 - Can't DROP 'product_sqlstock'; check that column/key exists

[ERROR] SQL 1.5.4.0 1060 in ALTER TABLE `prstshp_guest` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0: Duplicate column name 'mobile_theme'

[ERROR] SQL 1.5.4.0 1060 in ALTER TABLE `prstshp_orders` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0 AFTER `gift_message`: Duplicate column name 'mobile_theme'

[ERROR] SQL 1.5.4.0 1060 in ALTER TABLE `prstshp_cart` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0 AFTER `gift_message`: Duplicate column name 'mobile_theme'

Error when opening settings.inc.php file in write mode: 5

Warning detected during upgrade.

[ERROR] /modules/cashondelivery/ has not been unzipped

[WARNING] error when trying to upgrade module cashondelivery.

[ERROR] /modules/cashondelivery/ has not been unzipped

[WARNING] error when trying to upgrade module cashondelivery.

[ERROR] /modules/gsitemap/ has not been unzipped

[ERROR] /modules/gsitemap/backward_compatibility/ has not been unzipped

[ERROR] /modules/gsitemap/upgrade/ has not been unzipped

[ERROR] /modules/gsitemap/tpl/ has not been unzipped

[ERROR] /modules/gsitemap/img/ has not been unzipped

[ERROR] /modules/gsitemap/translations/ has not been unzipped

[WARNING] error when trying to upgrade module gsitemap.

[ERROR] /modules/gsitemap/ has not been unzipped

[ERROR] /modules/gsitemap/backward_compatibility/ has not been unzipped

[ERROR] /modules/gsitemap/upgrade/ has not been unzipped

[ERROR] /modules/gsitemap/tpl/ has not been unzipped

[ERROR] /modules/gsitemap/img/ has not been unzipped

[ERROR] /modules/gsitemap/translations/ has not been unzipped

[WARNING] error when trying to upgrade module gsitemap.

[ERROR] /modules/themeinstallator/ has not been unzipped

[ERROR] /modules/themeinstallator/backward_compatibility/ has not been unzipped

[ERROR] /modules/themeinstallator/export/ has not been unzipped

[ERROR] /modules/themeinstallator/import/ has not been unzipped

[WARNING] error when trying to upgrade module themeinstallator.

[ERROR] /modules/themeinstallator/ has not been unzipped

[ERROR] /modules/themeinstallator/backward_compatibility/ has not been unzipped

[ERROR] /modules/themeinstallator/export/ has not been unzipped

[ERROR] /modules/themeinstallator/import/ has not been unzipped

[WARNING] error when trying to upgrade module themeinstallator.

 

Followed to do list, but still have an old version of Prestashop. Tried to log in, log out, etc.

ToDo list:

• Cookies have changed, you will need to log in again once you refreshed the page
  
• Javascript and CSS files have changed, please clear your browser cache with CTRL-F5
  
• Please check that your front office theme is functionnal (try to create an account, place an order...)
  
• Product images does not appear in the front office? Try regenerating the thumbnails in Preferences > Images
  
• Do not forget to reactivate your shop once you have checked everything!
  

Please advise! Thanks!

[bellini13]

How old and established is the store? Why not just delete the store and re-create it using the new version directly from Prestashop