Installation On Mac Stops At 45%

[prestaad]

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

Edited December 18, 2015 by prestaad (see edit history)

[Eder]

Hi Rob, you saved me some time. I was having the same problem.

 

The problem is in mysql actually, or PS relies too much in mysql. MySQL older versions have some options that you must turn off in the last version to behave as before. Try this please:

 

Create the file /usr/local/mysql/etc/my.cnf

 

Add those 2 lines:

[mysqld]

sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

 

Restart mysql

 

Recreate your schema and try again. I got Your installation is finished! 

 

I disabled some options for zeroed dates and group by from default options of MySQL 5.7

 

Eder