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

Written by Frank Kenedy. / Last updated on 07 August 2018.

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 :

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.

PrestaSEO AI++.

PrestaSEO AI++ is a cutting-edge module designed to take your PrestaShop store’s SEO to the next level. Built with advanced automation and AI technology, it streamlines SEO tasks, making optimization easier and more effective.

Whether you're focused on improving local visibility or cleaning up your site's URL structure, PrestaSEO AI provides a comprehensive suite of features to enhance your store's performance.

Latest modules update!

iConvert Promotions 8.0.0 ⊙

Optimize source codes to improve the performance and user experiences on PrestaShop 8, resolved various issues to enhance compatibility with PrestaShop 1.7.x.

DocumenThemix 3.3.7 ⊙

Compatible with PrestaShop 8.

ChargeMe v5.4.1 ⊙

Clear the cart & redirect to the checkout page.

Age Restriction - 18+ v2.3.6⊙

Fix page assignment issues.

Newsletter Popup v3.2.5 ⊙

Enhance the level of security.

JumptoCheckout v.2.1.1 ⊙

Fix the deleting product issue.

Trusted by 7k++ clients.

Modules 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