--- Comment #48 from Julian Maurice <> ---
Created attachment 71448
Bug 20144: [sql_modes] Fix GROUP BY clause in GetBasketsInfosByBookseller

This need to be tested from the interface!

Fix for:
'koha_kohadev.aqbasket.basketname' isn't in GROUP BY


We need this group by.
We should not need to list all fields, from mysql 5.7 doc:
"The query is valid if name is a primary key of t or is a unique NOT NULL
column. In such cases, MySQL recognizes that the selected column is
functionally dependent on a grouping column. "

However, MariaDB did not implemented yet:

Signed-off-by: Josef Moravec <>
Signed-off-by: Julian Maurice <>

You are receiving this mail because:
You are watching all bug changes.
Koha-bugs mailing list
website :
git :
bugs :

Reply via email to