Jump to content
Galanid

Mise a jour prestashop 1.6.0.6 > 1.7.6.1

Recommended Posts

Bonjour tlm,

Ca fait un bail que j'avais pas pris le temps de faire une mise a jour de ma boutique qui tourné en 1.6.0.6. J'ai suivi le dev de prestashop de la 1.4 >1.6 :)

Aujourd’hui je me suis mis en tête de mettre a jour en 1.7 :) Bred un petit casse tete en prévision. J'ai plus ou moins reussi avec qq perte ( theme par exemple) mais j'avais prevu du changement dans tous les cas.

Pour info j'ai opérer tout cela en local /XAMP

Je suis passer de la 1.6.0.6 > 1.6.1.24 pour des raison techinque lié au version de php sans soucis et ensuite je suis passer a 1.7.6.1

J'ai reussi avec peu de casse hormis les erreur suivante sur la base suite au passage a la 1.7.6.1

Quote

SQL 1.6.0.11 1064 in ALTER IGNORE TABLE `ps_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 `ps_product` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEFAULT NULL' at line 1
SQL 1.6.0.11 1064 in ALTER IGNORE TABLE `ps_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 `ps_product_attribute` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEF' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_produ' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_customization` ADD KEY `id_cart_product` (`id_cart`, `id_produc' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `id_' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`)' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_product_attribute` ADD UNIQUE KEY `product_default` (`id_produc' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_produc' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_product_download` ADD UNIQUE KEY `id_product` (`id_product`)' at line 1
SQL 1.6.1.0 1064 in ALTER IGNORE TABLE `ps_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 `ps_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_p' at line 1
SQL 1.7.5.0 1071 in ALTER TABLE `ps_customer` CHANGE `company` `company` VARCHAR(255), CHANGE `email` `email` VARCHAR(255) NOT NULL, CHANGE `passwd` `passwd` VARCHAR(255) NOT NULL: Specified key was too long; max key length is 1000 bytes
SQL 1.7.5.0 1071 in ALTER TABLE `ps_employee` CHANGE `firstname` `firstname` VARCHAR(255) NOT NULL, CHANGE `email` `email` VARCHAR(255) NOT NULL, CHANGE `passwd` `passwd` VARCHAR(255) NOT NULL, CHANGE `lastname` `lastname` VARCHAR(255) NOT NULL: Specified key was too long; max key length is 1000 bytes

A Priori des erreur de syntaxe dans les requêtes et de version de mysql. J'ai fait les update sur un mysql 5.7.20

Est ce que a votre avis j’investigue un peu plus ou je peux ignorer ces erreurs.

D’après ce que j'ai pu tester la boutique fonctionne normalement

Merci pour l'aide que vous pourriez m'apporter. 

Sinon bravo a l'equipe prestashop. J'aime beaucoup la nouvelle interface et les amélioration.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More