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?