search

RedpointArchive / phabricator

A Docker image that runs Phabricator, an open source software engineering tool
https://hub.docker.com/r/redpointgames/phabricator/
307 stars 98 forks source link

email address add error #85

Closed liujiaxian closed 7 years ago

liujiaxian commented 7 years ago

Settings > Email Addresses > add new address

Unhandled Exception ("AphrontQueryException")

1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'phabricator_system.system_actionlog.actorIdentity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

hach-que commented 7 years ago

It sounds like your MySQL instance is in the wrong SQL mode, which is preventing things from working.

As far as I'm aware, sql_mode should be set to STRICT_ALL_TABLES not ONLY_FULL_GROUP_BY.