after update to 2.0.14 i have a small database error

[naan]

I make a update to 2.0.14
Then i have to use a new database.
Now i use

mysql
Server-Version: 5.7.12 - MySQL Community Server (GPL)
Protokoll-Version: 10

And i use php7 with OPcache

Code Select Expand

Expression #1 of ORDER BY clause is not in SELECT list, references column 'usr_web309_3.t.id_last_msg' which is not in SELECT list; this is incompatible with DISTINCT
Datei: /www/naan/sevel/Sources/Recent.php
Zeile: 1103

I ask in the german here: https://www.simplemachines.org/community/index.php?topic=554883.0
i get one answer: my.cnf in sql_mode das  ONLY_FULL_GROUP_BY delete.

i can't change this.


Is this error only in mysql 5.7 ?
"Unread answers to your posts."
"Ungelesene Antworten zu Ihren Beiträgen."
i get this error

[vbgamer45]

Check out this post https://www.simplemachines.org/community/index.php?topic=554500.0

[naan]

Thank you.

When i use

Server-Version: 5.6.36 - MySQL Community Server (GPL)

The error is gone



When i use
Server-Version: 5.7.12 - MySQL Community Server (GPL)
error is there again.

I can't change my.cnf, this can only my provider.

Code Select Expand

[mysqld]
sql-mode=""

To:
/etc/mysql/my.cnf



So i will use mysql 5.6

[Steve]

Marking solved then. If you have any other questions regarding this topic, by all means, mark this unsolved and let us know.