Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,194,853 members, 7,956,207 topics. Date: Monday, 23 September 2024 at 07:45 AM

Fix SQL Error On Prestashop 1.6 Installation - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Fix SQL Error On Prestashop 1.6 Installation (824 Views)

How Do I Solve 502 Bad Gateway Error On Ubuntu Server (digitalocean)? / Subscription Business With Prestashop Recurring Payment On Prestashop Site / Fix Any Error On Your Website/script (2) (3) (4)

(1) (Reply)

Fix SQL Error On Prestashop 1.6 Installation by nataliasa: 3:22am On Sep 05, 2018
It's time for Prestashop 1.7. But there are many developers have to install Prestashop 1.6 for their clients.

If you install Prestashop 1.6 on a server with Mysql 5.7, you will get an SQL error on query occured installation process: All parts of a PRIMARY KEY must be NOT NULL, if you need NULL in a key, use UNIQUE instead

You might want to try many times, but you can not finish the installation process because this error will breaks the installation.

So, how can we fix it?

First, Open your Prestashop-package/install/data/db_structure.sql file.

Then, Find

CREATE TABLE `PREFIX_cart_product`


Look below this line and change PRIMARY KEY to UNIQUE



It is easy, isn't it?

(1) (Reply)

IF You Can And Have Developed Android Or Ios App We Have A Job For You / Any Advice For A CSC Student / React Native Swiper Slider Layout Example

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.