Cancel Order
Logo Slider
Pretty Fox
Cart Reservation
Magic Menu
PageSpeed
DeleteX
ChargeMe
SEO Redirection
Age Restriction 18+
DocumenThemix
Agile Search
Checklist to Protect
Newsletter Popup
COVID-19 Stats
IConvert Promotion
Trusty Sale Proof
Countdown x Bar
Xleft
Jump to Checkout
GDPR
Create a new accountHow 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 :
Find
CREATE TABLE `PREFIX_cart_product`
Look below this line and change PRIMARY KEY to UNIQUE
Save and exit. That's all. Now you can re-install without any problems.
