https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22812
--- Comment #27 from Marcel de Rooy <[email protected]> --- (In reply to Jonathan Druart from comment #16) > MariaDB [koha_kohadev]> SET sql_mode = > 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, > ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; > Query OK, 0 rows affected (0.01 sec) > > MariaDB [koha_kohadev]> SELECT count(routingid) routingids FROM subscription > LEFT JOIN subscriptionroutinglist ON subscription.subscriptionid = > subscriptionroutinglist.subscriptionid WHERE subscription.subscriptionid = 1 > ORDER BY ranking ASC; > ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with > no GROUP columns is illegal if there is no GROUP BY clause OK Confirmed -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
