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.

OS: El Capitan Apache MySQL I was drawn to the nature of the error in my case. All pointed to SQL restrictions. Primary Key not being able to have a NULL value and incorrect date format. I made changes to the SQL file: file is: ~/install/data/db_structure.sql The number is the line number in the file. The first line is the original text, followed by a separator and the next line is the new text. This got me past the database issues. 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,

Background: Server: Mac Mini OS: El Capitan 10.11.2 php: 5.5.30, Zend 2.50 mysql: 5.7.10 apache: 2.4.16 The prestashop installation assistant stops at 45%. There are ticks against: Create settings.inc file Create database tables Create default shop and languages Populate database tables Configure shop information has the following error An error occurred during installation ... Does anyone have any ideas on how to solve this? Everything I've tried to date has not advanced the install beyond this point. My apache log shows the following: [Fri Dec 18 08:55:48.998831 2015] [:error] [pid 362] [client ::1:52602] PHP Warning: Invalid argument supplied for foreach() in /Library/WebServer/Documents/prestashop/install/models/install.php on line 513, referer: http://localhost/prestashop/install/index.php 18/12/215 OK, so this piece of code, at line 513 reads: 509 $states = Db::getInstance()->executeS('SELECT `id_order_state` FROM '._DB_PREFIX_.'order_state ORDER by `id_order_state`'); 510 $states_default = Db::getInstance()->executeS('SELECT MIN(`id_configuration`), `name` FROM '._DB_PREFIX_.'configuration WHERE `name` LIKE "PS_OS_%" GROUP BY `value` ORDER BY`id_configuration`'); 511 512 foreach ($states_default as &$state_default) { 513 if (is_array($state_default) && isset($state_default['name'])) { 514 $state_default = $state_default['name']; 515 } 516 } If I take line 510 and make the SQL query using mysql, I get: SQL query: Documentation SELECT MIN(`id_configuration`), `name` FROM `ps_configuration` WHERE `name` LIKE "PS_OS_%" GROUP BY `value` ORDER BY`id_configuration` LIMIT 0, 25 MySQL said: Documentation #1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myprestashop.ps_configuration.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by From my journey, it seems that there is a major incompatability issue with my combination of products. That is OK but I'd like to know or get stopped early on in the install i.e. at the System Compatibility step of the Installation Assistant. I've already hacked the db_structure to get this far. thanks in advance but getting less impressed by the hour. I think i may have to abandon my local install. Rob