diff options
| author | 2016-04-22 13:55:24 +0200 | |
|---|---|---|
| committer | 2016-04-22 13:55:24 +0200 | |
| commit | 89cc2aa3d0d2d3faeaf4b7d4ada11e3cd904bea3 (patch) | |
| tree | 4fb0cc2d047ed1ca123633691115c12fb166109d | |
| parent | fc4cd60191ab57240566641bd03c848af7dbd8f0 (diff) | |
MySQL compatibility only_full_group_by
Fix MySQL error, which appeared in MySQL 5.7:
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY
clause and contains nonaggregated column 'freshrss.c.id' which is not
functionally dependent on columns in GROUP BY clause; this is
incompatible with sql_mode=only_full_group_by
| -rw-r--r-- | app/Models/CategoryDAO.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/Models/CategoryDAO.php b/app/Models/CategoryDAO.php index b5abac519..fc431553e 100644 --- a/app/Models/CategoryDAO.php +++ b/app/Models/CategoryDAO.php @@ -103,7 +103,7 @@ class FreshRSS_CategoryDAO extends Minz_ModelPdo implements FreshRSS_Searchable . ($details ? 'f.* ' : 'f.id, f.name, f.url, f.website, f.priority, f.error, f.cache_nbEntries, f.cache_nbUnreads ') . 'FROM `' . $this->prefix . 'category` c ' . 'LEFT OUTER JOIN `' . $this->prefix . 'feed` f ON f.category=c.id ' - . 'GROUP BY f.id ' + . 'GROUP BY f.id, c_id ' . 'ORDER BY c.name, f.name'; $stm = $this->bd->prepare($sql); $stm->execute(); |
