Jump to content

Upgrade problem - error 500


Recommended Posts

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?

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...