Hi Philippe, See bug 21622. It is necessary to not explode with "$field is not in group by" (when sql_mode has ONLY_FULL_GROUP_BY) However we may need to discuss the need of this flag if it brings us performance issues. Cheers, Jonathan Le jeu. 12 déc. 2019 à 23:23, Philippe Blouin <philippe.blouin@inlibro.com> a écrit :
Good morning Koha,
Newbie question: why do we have 16 fields in GROUP BYs ? Are they really all necessary to eliminate duplicate lines in budgets? Genuine question.
When in acqui-home.pl, clicking certain entries linking to spent.pl just crashes with the error listed in the mail's object: Out of memory. Although I hate that solution, I went with it, increased sort_buffer_size 64x fold (I'm a generous guy). Still not enough.
Removing most lines in GROUP BY of spent.pl solves it all, of course.
-- Philippe Blouin, Directeur de la technologie
Tél. : (833) 465-4276, poste 230 philippe.blouin@inLibro.com
inLibro | pour esprit libre | www.inLibro.com _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/