search

sonrac / ministra-docker-instructions

Installation ministra with docker
MIT License
4 stars 3 forks source link

sql_mode not set correctly in mysql docker image #3

Open 00Asgaroth00 opened 5 years ago

00Asgaroth00 commented 5 years ago

When you don't set 

echo "sql_mode=\"\"" >> /etc/mysql/mysql.conf.d/mysqld.cnf

For the docker mysql container, then you end up with the following types of errors:

[Wed Mar 13 12:39:23.088288 2019] [:error] [pid 16] [client 172.16.17.5:55641] Query failed by reason : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ministra.video.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SELECT *\nFROM (video)\nGROUP BY year\nORDER BY year ASC), referer: http://docker:880/stalker_portal/server/adm/
[Wed Mar 13 12:39:23.088715 2019] [:error] [pid 16] [client 172.16.17.5:55641] Query failed by reason : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ministra.video.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SELECT *\nFROM (video)\nGROUP BY year\nORDER BY year ASC), referer: http://docker:880/stalker_portal/server/adm/