Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,853 members, 7,956,207 topics. Date: Monday, 23 September 2024 at 07:45 AM |
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 |