fbpx

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 :

"SQL error on query All parts of a PRIMARY KEY must be NOT NULL, if you need NULL in a key, use UNIQUE instead​"

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 :

Prestashop Installation Error

Find

CREATE TABLE `PREFIX_cart_product`
Look below this line and change PRIMARY KEY to UNIQUE

prestashop-install-error.png

Save and exit. That's all. Now you can re-install without any problems.

Discover more

Related articles

Something might be useful for your Prestashop websites

What should be the length of title on Prestashop for SEO

What should be the length of title on Pr…

How to write a strong SEO Title Tag that Google will love on your site? In my previous tutorial on...

PrestaSOO website uses cookies. By continuing to use this website, you are giving consent to cookies being used. More details… X