Error During Instalation At Create Database Tables Step

[psantos10]

I am trying to install Prestashop on production machine and local one. Both give me the same error: 

 

I found this link: https://github.com/PrestaShop/PrestaShop/commit/8134781f64053826c8c21402ef7d46bf6ca1bad4

and I made the same modification, but the problem still the same.

How can I solve this?

[prestaad]

The error seemed to be an SQL type error to me.  After much looking and reading I decided to modify the provided db_structure.sql in line with what I found.  e.g. primary key must not be null   ... clearly at line 314 this is incorrect for my version of mysql.

 

file is: ~/install/data/db_structure.sql

 

The following describe my changes to this file.

 

The number is the line number in the file.  So taking the first 4 lines ...

 

314c314 ... CHANGE LINE 314

<   `id_product_attribute` int(10) unsigned DEFAULT NULL, ... THIS IS THE ORIGINAL TEXT

--- ... A SEPARATOR

>   `id_product_attribute` int(10) unsigned NOT NULL, ... THIS IS THE NEW TEXT

 

 

 

314c314

<   `id_product_attribute` int(10) unsigned DEFAULT NULL,

---

>   `id_product_attribute` int(10) unsigned NOT NULL,

762c762

<   `last_connection_date` date DEFAULT '0000-00-00',

---

>   `last_connection_date` date DEFAULT NULL,

1470c1470

<   `available_date` date NOT NULL DEFAULT '0000-00-00',

---

>   `available_date` date NOT NULL,

1512c1512

<   `available_date` date NOT NULL DEFAULT '0000-00-00',

---

>   `available_date` date NOT NULL,

1544c1544

<   `available_date` date NOT NULL DEFAULT '0000-00-00',

---

>   `available_date` date NOT NULL,

1564c1564

<   `available_date` date NOT NULL DEFAULT '0000-00-00',

---

>   `available_date` date NOT NULL,

2628c2628

<   `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

---

>   `last_update` datetime NOT NULL,

2634c2634

<   `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

---

>   `last_flush` datetime NOT NULL,

 

This got me to 45% when again the installation stopped.  

 

Hope this helps.