It looks like you're new here. If you want to get involved, click one of these buttons!
Hi, After installing the latest copy of Yaga from GitHub (including the date fixes), we get the following error when trying to access the admin profile page:
In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column '*****.Reaction.ReactionID'; this is incompatible with sql_mode=only_full_group_by
Application Version: 2.6.4
PHP Version: 7.1.26
Operating System: Linux
Server Software: Apache/2.4.6 (CentOS)
Request Uri: /profile
We are running mysql as follows: 5.7.23-23-57-log - Percona XtraDB Cluster (GPL), Release rel23, Revision f5578f0, WSREP version 31.31, wsrep_31.31
The issue is probably due to Percona's strictness with regards to SQL statements, but is nonetheless a sign that the query is incorrect. We are not familiar enough with vanilla or Yaga to be able to fix this, but if the author can do so it would be very much appreciated.
This StackOverflow page explains the problem in detail and the steps needed to fix it > https://stackoverflow.com/questions/43481869/aggregated-query-without-group-by
Thanks in anticipation