Upgrade problem - error 500

[Fiszix]

Hi everyone,

 

I've tried to upgrade my prestashop 1.6.0.9 to 1.6.1.6 but when I was doing it the errors come out:

SQL 1.6.0.11 1064 in ALTER IGNORE TABLE `fresh_product` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEFAULT NULL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_product` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEFAULT NU' at line 1
SQL 1.6.0.11 1064 in ALTER IGNORE TABLE `fresh_product_attribute` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEFAULT NULL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_product_attribute` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL ' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_pr' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_customization` ADD KEY `id_cart_product` (`id_cart`, `id_product`, `id_product_attribute`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_customization` ADD KEY `id_cart_product` (`id_cart`, `id_pro' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `id_shop`, `cover`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `id_shop`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cove' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `cover`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_s' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_product_attribute` ADD UNIQUE KEY `product_default` (`id_product`,`default_on`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_product_attribute` ADD UNIQUE KEY `product_default` (`id_pro' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `default_on`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_pro' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_product_download` ADD UNIQUE KEY `id_product` (`id_product`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_product_download` ADD UNIQUE KEY `id_product` (`id_product`)' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `fresh_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `fresh_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `i' at line 1
Wykryto ostrzeżenie podczas aktualizacji.

Admin page just working well but when I'm trying to get index page I'm getting an error 500.

Any solutions for that problem?

[Scully]

In terms of SQL syntax, the statments seem correct to me. Tested on an MySQL Instance with 5.5.57.

Maybe post full details on you software setup?

Edited August 7, 2017 by Scully (see edit history)