javialvamore Posted January 26, 2016 Share Posted January 26, 2016 Hi all, I'm installing Prestashop on wampp, and in the last step occurr the next error: Crear fichero settings.inc Crear tablas de la base de datos Error SQL en la consulta All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead I've drop the database and create it again. I'm using the root user, the default administrator, any idea? Thanxs in advance Link to comment Share on other sites More sharing options...
tuk66 Posted January 27, 2016 Share Posted January 27, 2016 What version? Link to comment Share on other sites More sharing options...
javialvamore Posted January 27, 2016 Author Share Posted January 27, 2016 Sorry, is the last version: prestashop_1.6.1.4_es The installation stopped when it reached the 12%. In DDBB has created only 27 tables Link to comment Share on other sites More sharing options...
tuk66 Posted January 27, 2016 Share Posted January 27, 2016 So the last created table is ps_cart_product. It looks like wrong demo data. Try to install the shop in English. Link to comment Share on other sites More sharing options...
javialvamore Posted January 28, 2016 Author Share Posted January 28, 2016 Hi all, I've tried to install in spanish, english, and different versions: prestashop_1.6.1.4-es, prestashop_1.6.1.4 and prestashop_1.6.1.3 I think is problem of my instalation, i've a windows 10 on my laptop, my wamp server is version 3.0.0 that includes Server Software: Apache/2.4.17 (Win32) PHP/5.6.15 - Port defined for Apache: 8080 MySQL Version: 5.7.9 - Port defined for MySQL: 3306 Link to comment Share on other sites More sharing options...
2FR3 Posted February 1, 2016 Share Posted February 1, 2016 Same problem here. Link to comment Share on other sites More sharing options...
2FR3 Posted February 1, 2016 Share Posted February 1, 2016 (edited) Ok, i've found : U should to install mysql 5.6 an not 5.7.x. Edited February 1, 2016 by 2FR3 (see edit history) 1 Link to comment Share on other sites More sharing options...
prince0080 Posted November 6, 2016 Share Posted November 6, 2016 (edited) Hi, guys I'm having the same problem. When installing PrestaShop on my local machine running Wampserver 2.5, php 5.5.12 (fcgi), mySql 5.6.17, Apache 2.4.9, the installation stops at 12% giving me the error: create database tables ( An error occurred during installation...) A screen capture below: http://prnt.sc/d3wvyo I tried about 6 or 7 times, same error occurred! Tried both using chrome and IE browser. Once installation stopped, if I check the database I see 232 tables. I also can see C:\wamp\www\prestashop\config\settings.inc.php has been created. Checking C:\wamp\logs\apache_error.log [Mon Nov 07 01:07:22.720729 2016] [mpm_winnt:notice] [pid 5196:tid 920] AH00422: Parent: Received shutdown signal -- Shutting down the server. [Mon Nov 07 01:07:24.736951 2016] [mpm_winnt:notice] [pid 11200:tid 752] AH00364: Child: All worker threads have exited. [Mon Nov 07 01:07:33.158829 2016] [fcgid:error] [pid 11200:tid 800] FastCGI process 6084 still did not exit, terminating forcefully [Mon Nov 07 01:07:33.158829 2016] [fcgid:error] [pid 11200:tid 800] FastCGI process 4212 still did not exit, terminating forcefully [Mon Nov 07 01:07:34.281417 2016] [mpm_winnt:notice] [pid 5196:tid 920] AH00430: Parent: Child process 11200 exited successfully. [Mon Nov 07 01:07:38.220872 2016] [mpm_winnt:notice] [pid 6436:tid 924] AH00455: Apache/2.4.9 (Win64) mod_fcgid/2.3.9 configured -- resuming normal operations [Mon Nov 07 01:07:38.220872 2016] [mpm_winnt:notice] [pid 6436:tid 924] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59 [Mon Nov 07 01:07:38.220872 2016] [core:notice] [pid 6436:tid 924] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d C:/wamp/bin/apache/apache2.4.9' [Mon Nov 07 01:07:38.220872 2016] [mpm_winnt:notice] [pid 6436:tid 924] AH00418: Parent: Created child process 8080 [Mon Nov 07 01:07:38.953580 2016] [mpm_winnt:notice] [pid 8080:tid 816] AH00354: Child: Starting 64 worker threads. [Mon Nov 07 01:16:59.071842 2016] [fcgid:warn] [pid 8080:tid 1328] [client ::1:57951] mod_fcgid: read timeout from pipe, referer: http://localhost/prestashop/install/index.php [Mon Nov 07 01:16:59.071842 2016] [core:error] [pid 8080:tid 1328] [client ::1:57951] End of script output before headers: index.php, referer: http://localhost/prestashop/install/index.php [Mon Nov 07 01:17:08.461405 2016] [fcgid:warn] [pid 8080:tid 792] mod_fcgid: process 10720 graceful kill fail, sending SIGKILL I googled for a similar issues but couldn't didn't a solution yet. Tried a couple of answers suggested by a few, like.. Setting wamserver > PHP > php.ini default_socket_timeout = 2400 mysql.connect_timeout = 2400 but I'm still having the issue. Remember I'm trying to get Prestashop install on my local machine running Windows 8.1. Can somebody please HELP! Edited November 6, 2016 by prince0080 (see edit history) Link to comment Share on other sites More sharing options...
prince0080 Posted November 6, 2016 Share Posted November 6, 2016 I forgot to mention.. I am trying to install the latest version of PrestaShop (prestashop_1.6.1.8.zip) downloaded from the official site. Link to comment Share on other sites More sharing options...
prince0080 Posted November 6, 2016 Share Posted November 6, 2016 Is it anything to do with the Fast cgi ? Link to comment Share on other sites More sharing options...
prak Posted November 7, 2016 Share Posted November 7, 2016 PrestaShop does NOT support MySQL 5.7! Only partial support is available. Hello, Is it true for Prestashop 1.6.1.8 as well? I ran into the same problem Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now