Jump to content

Error Creating Database Tables


Recommended Posts

Hi all,

 

I'm installing Prestashop on wampp, and in the last step occurr the next error:

 

  1. Crear fichero settings.inc
  2. Crear tablas de la base de datos
    1. 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

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

  • 9 months later...

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 by prince0080 (see edit history)
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...