<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Thanks,</p>
<p>Ok, I've never seen the "$field is not in group by" error.
Interesting.<br>
</p>
<p>I've followed the bread crumbs: 21622 -> 20182 -> 21723
-> 22260... read it all. It's "damned if you do, damned if you
don't".</p>
<p>ONLY_FULL_GROUP_BY mode is the SQL Standard, I don't think it
would be wise to stray from that. (I can do it locally, but I
don't think Koha should, philosophically)<br>
</p>
<p>But my client can't click on spent.pl. And no memory setting
seems to fix it. So what's my solution? Could the query be
reworked in two steps? This is not a screen where 0.2s will make
a difference in the user experience.</p>
<p>Suggestions welcomed.<br>
</p>
<div class="moz-signature">
<style type="text/css">
.moz-signature {
color: #FFFFFF;
}
.sig_inlibro {
padding-top : 2px;
color: #888888;
font-family : "Trebuchet MS", verdana;
font-size: 90%;
}
.sig_content {
border-top: 2px solid #DDDDDD;
border-bottom: 2px solid #BFD13D;
background-color : #F6F6F6;
padding-left:10px;
}
.sig_inlibro a:visited, .sig_inlibro a:hover, .sig_inlibro a:link {
text-decoration: none;
color: #005B85;
}
.nom {
color: #005B85;
font-weight : bold;
}
.inlibro, .in {
color: #BFD13D;
}
.libro {
color: #005B85;
}
.in, .libro {
font-size : 120%;
}
.desc {
margin-bottom: 0;
padding-bottom: 5px;
}
.small {
font-size: 80%;
}
.tagline {
color : #00BCE4;
}
.sig_footer {
padding-left : 10px;
background-color : #EEEFEA;
}
</style>
<div class="sig_inlibro">
<div class="sig_content"> <span class="nom">Philippe Blouin,</span><br>
<span class="tagline small">Directeur de la technologie</span><br>
<p class="desc small"> Tél. : (833) 465-4276, poste 230<br>
<!--
Tél. : (888) 604-2627<br/>
--> <a href="mailto:philippe.blouin@inLibro.com">philippe.blouin@inLibro.com</a>
</p>
</div>
<div class="sig_footer"> <span class="in">in</span><span
class="libro">Libro</span> <span class="tagline small">|
pour esprit libre |</span> <a class="small"
href="http://www.inLibro.com">www.inLibro.com</a> </div>
</div>
</div>
<div class="moz-cite-prefix">On 2019-12-13 4:33 a.m., Jonathan
Druart wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAJzKNY4qLWX4PujoXRhdtsbd92NtaY0Ca62C4kh6zHHZpX4sPw@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">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
<a class="moz-txt-link-rfc2396E" href="mailto:philippe.blouin@inlibro.com"><philippe.blouin@inlibro.com></a> a écrit :
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
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
<a class="moz-txt-link-abbreviated" href="mailto:philippe.blouin@inLibro.com">philippe.blouin@inLibro.com</a>
inLibro | pour esprit libre | <a class="moz-txt-link-abbreviated" href="http://www.inLibro.com">www.inLibro.com</a>
_______________________________________________
Koha-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a>
<a class="moz-txt-link-freetext" href="https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="moz-txt-link-freetext" href="http://www.koha-community.org/">http://www.koha-community.org/</a>
git : <a class="moz-txt-link-freetext" href="http://git.koha-community.org/">http://git.koha-community.org/</a>
bugs : <a class="moz-txt-link-freetext" href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a>
</pre>
</blockquote>
</blockquote>
</body>
</html>