hang during installation at 2-nd phase

Shopify December 04, 2016 / 00:00

‌ hi there,

trying to install 1.0.7 version, but stop on 2-nd phase ("Setting up database")

the partial log
```
[2016-12-04 09:57:16] production.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'demo-shop-db.demo__modules.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/demo/vendor/laravel/framework/src/Illuminate/Database/Connection.php:288
```

the full log
https://gist.github.com/hbakhtiyor/81a541bdc2351bc798954986a65ecb14

any advices?

Comments for hang during installation at 2-nd phase

Peter Ivanov 2017-08-10 12:22:16

Hi,

Do you by chance use Postgres SQL server ?

Peter Ivanov 2017-08-10 12:22:16

Hi, i found that this error is because of the new MYSQL version 5.7 which changed the GROUP BY behavior

http://www.tocker.ca/2014/01/24/proposal-to-enable-sql-mode-only-full-group-by-by-default.html

http://johnemb.blogspot.bg/2014/09/adding-or-removing-individual-sql-modes.html

https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/

http://mysqlserverteam.com/mysql-5-7-only_full_group_by-improved-recognizing-functional-dependencies-enabled-by-default/

We will try to fix this for Microweber 1.0.8 release

You have to log in or register to post a comment:

‹ Multi-site on subdomain

Module "Comments" ›