piwigo mysql error 3065 解决方案

piwigo 做的图床，在升级了 MySQL（版本号 5.7.13）之后，某一天突然发现点进去相册就提示 MySQL error 3065，具体报错如下：

Warning: [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'pic.piwigo_images.date_available' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT(image_id)

FROM piwigo_image_category

INNER JOIN piwigo_images ON id = image_id

WHERE

category_id = 5

去 Google 搜索一番找到了这么个链接 https://github.com/Piwigo/Piwigo/issues/376

找到了解决方案，修改配置文件

vim /etc/my.cnf

在 mysqld 字段下增加如下一行

sql-mode=""

重启 MySQL 即可

systemctl restart mysql.service