Hi,
I encountered this error while trying to open Sent Items
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'databasename.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /srv/users/serverpilot/apps/appname/public/sources/subs/PersonalMessage.subs.php
Line: 1034
Note: Your database version is 1.0.10.
after a litte search I found that I must disable MySQL strict mode (https://serverpilot.io/community/articles/how-to-disable-strict-mode-in-mysql-5-7.html) on my serverpilot's VPS
AFAIK MySQL strict mode was enabled by default since MySQL 5.7, should Elkarte aware of this?
Regards,
Lukas
Try replacing the:
'sort' => $pm_options['sort_by_query'],
of the query, with:
'sort' => $pm_options['sort_by_query'] === 'pm.id_pm' ? 'MAX(pm.id_pm)' : $pm_options['sort_by_query'],
Done
Nice to know, reenabled MySQL strict mode now...
Thanks
Let me know if it works! :)
Something similar was already reported here http://www.elkarte.net/community/index.php?topic=4185.0
it works :)
you're right it's similar, I wonder why I did not see your thread at first search... :-*
Tracked https://github.com/elkarte/Elkarte/issues/2926