[Koha-bugs] [Bug 22812] Cannot add new subscription with strict SQL modes turned on

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22812

--- Comment #27 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(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.