Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,122 members, 7,957,204 topics. Date: Tuesday, 24 September 2024 at 09:07 AM |
Nairaland Forum / Science/Technology / Programming / Fix SQL Error On Prestashop 1.6 Installation (825 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)
Join My Startup / Webdesign Mentorship / What Is Artificial Intelligence Programming? How It Works?
(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. 5 |