'' Install Prestashop: Fix SQL error on installation process 2024 '' ''

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.

Get this Advanced Cart Rules module

PrestaShop Newsletter Christmas theme

Latest modules update!

ChargeMe v5.3.9 ⊙
Fix the backend issue.


Age Restriction - 18+ v2.3.4⊙
Fix the Smarty issues.


Newsletter Popup v3.2.3 ⊙
Fixed some issues & a new Christmas Edition to boost your sales.


Trusty v1.4.7 ⊙
Compatible with both PrestaShop 1.7 & PrestaShop 8.

PrestaSOO team
Everything you need to make a living doing work you love.

Discover

It is a wise investment

PrestaShop modules we created first to solve the problem of our own business - an e-Commerce site. That means they are very useful for serious business. If you value your web property, these modules are a wise investment.
Sarah Reeves, App Developer @ PrestaSOO
Made with in Paris & Hanoi
PrestaSOO © 2024. All rights reserved. // Privacy Policy Terms of Service
''