Napisane przez Frank Kenedy. / Ostatnio zmienione .

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.

Halloween theme

PrestaSEO AI++.

PrestaSEO AI module

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.

Aktualizacja najnowszych modułów!

Age Restriction - 18+ ⊙
Rozwiąż niektóre problemy z wyświetlaniem na urządzeniach przenośnych.

Newsletter Popup v3.2.2 ⊙
Edycja świąteczna, aby zwiększyć sprzedaż.

Trusty v1.4.7 ⊙
Kompatybilny zarówno z PrestaShop 1.7, jak i PrestaShop 8.

What is new in PrestaShop 8 beta?
PrestaShop cart rules - buy X get the cheapest free
Age Restriction & Verification module v2.3.1 has been released, fixed some issues 👉 #prestashop #prestasoo #18plusonly
New SOO Magic Menu v4.2.2 - Mega Menu PrestaShop module 🤩👉 #megamenu #prestashop
New PrestaShop Newsletter module v3.1.4 - sync languages