Tag Archives: Expression #1 of ORDER BY clause is not in SELECT list

Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xxxx’ which is not in SELECT list; this is incompatible with DISTINCT

Access system error after MySQL upgrade to 5.7.31.
Solution:
Modify /etc/my.cnf
file at the bottom to append :
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION