How to fix SQL error to Install Prestashop
When you install Prestashop on a server with Mysql 5.7, you will get an error occured installation process :
This error will breaks your installation process whether you try to reinstall as many times. Here is the way to fix this problem.
Open your Prestashop-package/install/data/db_structure.sql file :
Look below this line and change PRIMARY KEY to UNIQUE
CREATE TABLE `PREFIX_cart_product`
Save and exit. That's all. Now you can re-install without any problems.
The founder of the Owaci, a fast-growing ecommerce company, main developer of PrestaSOO team. Subscribe to receive his articles to show you how to manage, develop your Prestashop website.