Issue with mysql 5.7 running with sql_mode=only_full_group_by (temporary workaround) #20

Closed
stripthis opened this Issue Sep 21, 2016 · 1 comment

Projects

None yet

2 participants

@stripthis
Contributor
stripthis commented Sep 21, 2016 edited

Currently passbolt permissions views are not SQL99 compliant and triggering the following errors when mysql sql_mode contains only_full_group_by (a default setting since 5.7):

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'UserResourcePermission.permission_id'; this is incompat\
ible with sql_mode=only_full_group_by

In order to run passbolt on mysql5.7 you will still need to disable the sql_mode only_full_group_by with for example the following command:

SET global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

This is a temporary workaround, we’ll try to address this in a future release.
ref. PASSBOLT-1646

@stripthis stripthis added the bug label Sep 21, 2016
@cedricalfonsi
Contributor

Fixed with v1.4.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment