<div dir="ltr">Hello,<div>we found this issue some days ago, and this is what we do:</div><div><br></div><div><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><font face="monospace, monospace"><span class="" style="font-weight:700">sub </span><span class="" style="color:rgb(153,0,0);font-weight:700">_new_schema</span> <span class="">{</span>
<a name="Database.pm-49" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-50" style="color:rgb(53,114,176)"></a> <span class="" style="color:rgb(153,153,153)">require</span> <span class="" style="color:rgb(85,85,85)">Koha::</span><span class="">Schema</span><span class="">;</span>
<a name="Database.pm-51" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-52" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$context</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(85,85,85)">C4::</span><span class="">Context</span><span class="" style="font-weight:700">-></span><span class="" style="font-weight:700">new</span><span class="">();</span>
<a name="Database.pm-53" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-54" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$db_driver</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$context</span><span class="" style="font-weight:700">-></span><span class="">{</span><span class="">db_driver</span><span class="">};</span>
<a name="Database.pm-55" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-56" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$db_name</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$context</span><span class="" style="font-weight:700">-></span><span class="">config</span><span class="">(</span><span class="" style="color:rgb(187,136,68)">"database"</span><span class="">);</span>
<a name="Database.pm-57" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$db_host</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$context</span><span class="" style="font-weight:700">-></span><span class="">config</span><span class="">(</span><span class="" style="color:rgb(187,136,68)">"hostname"</span><span class="">);</span>
<a name="Database.pm-58" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$db_port</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$context</span><span class="" style="font-weight:700">-></span><span class="">config</span><span class="">(</span><span class="" style="color:rgb(187,136,68)">"port"</span><span class="">)</span> <span class="" style="font-weight:700">||</span> <span class="" style="color:rgb(187,136,68)">''</span><span class="">;</span>
<a name="Database.pm-59" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$db_user</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$context</span><span class="" style="font-weight:700">-></span><span class="">config</span><span class="">(</span><span class="" style="color:rgb(187,136,68)">"user"</span><span class="">);</span>
<a name="Database.pm-60" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$db_passwd</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$context</span><span class="" style="font-weight:700">-></span><span class="">config</span><span class="">(</span><span class="" style="color:rgb(187,136,68)">"pass"</span><span class="">);</span>
<a name="Database.pm-61" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-62" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="">(</span> <span class="" style="color:teal">%encoding_attr</span><span class="">,</span> <span class="" style="color:teal">$encoding_query</span><span class="">,</span> <span class="" style="color:teal">$tz_query</span><span class="">,</span> <span class="" style="color:teal">$sql_mode</span> <span class="">);</span>
<a name="Database.pm-63" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$tz</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$ENV</span><span class="">{</span><span class="">TZ</span><span class="">};</span>
<a name="Database.pm-64" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">if</span> <span class="">(</span> <span class="" style="color:teal">$db_driver</span> <span class="" style="font-weight:700">eq</span> <span class="" style="color:rgb(187,136,68)">'mysql'</span> <span class="">)</span> <span class="">{</span>
<a name="Database.pm-65" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">%encoding_attr</span> <span class="" style="font-weight:700">=</span> <span class="">(</span> <span class="">mysql_enable_utf8</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:rgb(0,153,153)">1</span> <span class="">);</span>
<a name="Database.pm-66" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$encoding_query</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(187,136,68)">"set NAMES 'utf8'"</span><span class="">;</span>
<a name="Database.pm-67" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$tz_query</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(187,136,68)">qq(SET time_zone = "$tz")</span> <span class="" style="font-weight:700">if</span> <span class="" style="color:teal">$tz</span><span class="">;</span>
<a name="Database.pm-68" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$sql_mode</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(187,136,68)">"set sql_mode = ''"</span><span class="">;</span>
<a name="Database.pm-69" style="color:rgb(53,114,176)"></a> <span class="">}</span>
<a name="Database.pm-70" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">elsif</span> <span class="">(</span> <span class="" style="color:teal">$db_driver</span> <span class="" style="font-weight:700">eq</span> <span class="" style="color:rgb(187,136,68)">'Pg'</span> <span class="">)</span> <span class="">{</span>
<a name="Database.pm-71" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$encoding_query</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(187,136,68)">"set client_encoding = 'UTF8';"</span><span class="">;</span>
<a name="Database.pm-72" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$tz_query</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(187,136,68)">qq(SET TIME ZONE = "$tz")</span> <span class="" style="font-weight:700">if</span> <span class="" style="color:teal">$tz</span><span class="">;</span>
<a name="Database.pm-73" style="color:rgb(53,114,176)"></a> <span class="">}</span>
<a name="Database.pm-74" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$schema</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(85,85,85)">Koha::</span><span class="">Schema</span><span class="" style="font-weight:700">-></span><span class="" style="color:rgb(153,153,153)">connect</span><span class="">(</span>
<a name="Database.pm-75" style="color:rgb(53,114,176)"></a> <span class="">{</span>
<a name="Database.pm-76" style="color:rgb(53,114,176)"></a> <span class="">dsn</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:rgb(187,136,68)">"dbi:$db_driver:database=$db_name;host=$db_host;port=$db_port"</span><span class="">,</span>
<a name="Database.pm-77" style="color:rgb(53,114,176)"></a> <span class="">user</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:teal">$db_user</span><span class="">,</span>
<a name="Database.pm-78" style="color:rgb(53,114,176)"></a> <span class="">password</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:teal">$db_passwd</span><span class="">,</span>
<a name="Database.pm-79" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">%encoding_attr</span><span class="">,</span>
<a name="Database.pm-80" style="color:rgb(53,114,176)"></a> <span class="">RaiseError</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:teal">$ENV</span><span class="">{</span><span class="">DEBUG</span><span class="">}</span> <span class="">?</span> <span class="" style="color:rgb(0,153,153)">1</span> <span class="">:</span> <span class="" style="color:rgb(0,153,153)">0</span><span class="">,</span>
<a name="Database.pm-81" style="color:rgb(53,114,176)"></a> <span class="">PrintError</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:rgb(0,153,153)">1</span><span class="">,</span>
<a name="Database.pm-82" style="color:rgb(53,114,176)"></a> <span class="">unsafe</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:rgb(0,153,153)">1</span><span class="">,</span>
<a name="Database.pm-83" style="color:rgb(53,114,176)"></a> <span class="">quote_names</span> <span class="" style="font-weight:700">=></span> <span class="" style="color:rgb(0,153,153)">1</span><span class="">,</span>
<a name="Database.pm-84" style="color:rgb(53,114,176)"></a> <span class="">on_connect_do</span> <span class="" style="font-weight:700">=></span> <span class="">[</span>
<a name="Database.pm-85" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$encoding_query</span> <span class="" style="font-weight:700">||</span> <span class="">(),</span>
<a name="Database.pm-86" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$tz_query</span> <span class="" style="font-weight:700">||</span> <span class="">(),</span>
<a name="Database.pm-87" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$sql_mode</span> <span class="" style="font-weight:700">||</span> <span class="">(),</span>
<a name="Database.pm-88" style="color:rgb(53,114,176)"></a> <span class="">]</span>
<a name="Database.pm-89" style="color:rgb(53,114,176)"></a> <span class="">}</span>
<a name="Database.pm-90" style="color:rgb(53,114,176)"></a> <span class="">);</span>
<a name="Database.pm-91" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-92" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">my</span> <span class="" style="color:teal">$dbh</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$schema</span><span class="" style="font-weight:700">-></span><span class="">storage</span><span class="" style="font-weight:700">-></span><span class="">dbh</span><span class="">;</span>
<a name="Database.pm-93" style="color:rgb(53,114,176)"></a> <span class="" style="color:rgb(153,153,153)">eval</span> <span class="">{</span>
<a name="Database.pm-94" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$dbh</span><span class="" style="font-weight:700">-></span><span class="">{</span><span class="">RaiseError</span><span class="">}</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(0,153,153)">1</span><span class="">;</span>
<a name="Database.pm-95" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$dbh</span><span class="" style="font-weight:700">-></span><span class="" style="font-weight:700">do</span><span class="">(</span><span class="" style="color:rgb(187,136,68)">q|</span>
<a name="Database.pm-96" style="color:rgb(53,114,176)"></a><span class="" style="color:rgb(187,136,68)"> SELECT * FROM systempreferences WHERE 1 = 0 |</span>
<a name="Database.pm-97" style="color:rgb(53,114,176)"></a> <span class="">);</span>
<a name="Database.pm-98" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$dbh</span><span class="" style="font-weight:700">-></span><span class="">{</span><span class="">RaiseError</span><span class="">}</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:teal">$ENV</span><span class="">{</span><span class="">DEBUG</span><span class="">}</span> <span class="">?</span> <span class="" style="color:rgb(0,153,153)">1</span> <span class="">:</span> <span class="" style="color:rgb(0,153,153)">0</span><span class="">;</span>
<a name="Database.pm-99" style="color:rgb(53,114,176)"></a> <span class="">};</span>
<a name="Database.pm-100" style="color:rgb(53,114,176)"></a> <span class="" style="color:teal">$dbh</span><span class="" style="font-weight:700">-></span><span class="">{</span><span class="">RaiseError</span><span class="">}</span> <span class="" style="font-weight:700">=</span> <span class="" style="color:rgb(0,153,153)">0</span> <span class="" style="font-weight:700">if</span> <span class="" style="color:teal">$@</span><span class="">;</span>
<a name="Database.pm-101" style="color:rgb(53,114,176)"></a>
<a name="Database.pm-102" style="color:rgb(53,114,176)"></a> <span class="" style="font-weight:700">return</span> <span class="" style="color:teal">$schema</span><span class="">;</span>
<a name="Database.pm-103" style="color:rgb(53,114,176)"></a><span class="">}</span></font></pre></div><div><br></div><div>Regards,</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-05-26 17:59 GMT+02:00 Tomas Cohen Arazi <span dir="ltr"><<a href="mailto:tomascohen@gmail.com" target="_blank">tomascohen@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Maybe it is worth checking if it can be configured client-side. As we do for UTF-8</div><br><div class="gmail_quote"><div dir="ltr">El jue., 26 may. 2016 a las 9:45, Bernardo Gonzalez Kriegel (<<a href="mailto:bgkriegel@gmail.com" target="_blank">bgkriegel@gmail.com</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div>testing things on MySQL 5.7 - Koha 3.22, found a new problem:</div><div><br></div><div><span style="font-family:monospace;color:rgb(0,0,0)"><a href="http://memberentry.pl" target="_blank">memberentry.pl</a>: DBD::mysql::st execute failed: Expression #1 of SELE</span><span style="font-family:monospace">CT list is not in GROUP BY clause and contains nonaggregated column 'kohadev.categories.categorycode' which is not functionally dependent on columns in GROUP BY clause; this is incompati</span><span style="font-family:monospace">ble with sql_mode=only_full_group_by ...</span><br></div><div><br></div><div>This comes trying to add a patron after fresh install, 3.22+marc21+all sample data</div><div><br></div><div>Can we change sql_mode for Koha?</div><div><br></div><div>Regards</div><div>Bernardo</div><div><br></div><span class="HOEnZb"><font color="#888888"><div><br clear="all"><div><div>-- <div>Bernardo Gonzalez Kriegel</div><div><a href="mailto:bgkriegel@gmail.com" target="_blank">bgkriegel@gmail.com</a></div></div></div>
</div></font></span></div><span class="HOEnZb"><font color="#888888">
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a></font></span></blockquote></div><span class="HOEnZb"><font color="#888888"><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><div dir="ltr"><div style="color:rgb(117,117,117);font-family:'helvetica neue',helvetica,arial,sans-serif;font-size:12.8px">Tomás Cohen Arazi</div><div style="color:rgb(117,117,117);font-family:'helvetica neue',helvetica,arial,sans-serif;font-size:12.8px">Theke Solutions (<a href="http://theke.io/" target="_blank">http://theke.io</a>)<br>✆ <a href="tel:%2B54%209351%203513384" value="+5493513513384" target="_blank">+54 9351 3513384</a><br>GPG: B2F3C15F</div></div></div>
</font></span><br>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><span style="text-align:-webkit-auto;text-indent:0px"><br clear="all"><br><font face="arial" style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px">--</font><span style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"> </span><br><b style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"><div><b> </b></div>Juan Francisco Romay Sieira</b><br><font face="arial" style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px"> </font><br><div><div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"><i>Chief Technology Officer</i><br><a href="mailto:juan.sieira@xercode.es" target="_blank">juan.sieira@xercode.es</a><br> <br>C/ Hedras, 4 2ºA | 15895 | Milladoiro - A Coruña - Spain<br><a href="http://www.xercode.es/" target="_blank">www.xercode.es</a> | <a href="mailto:info@xercode.es" target="_blank">info@xercode.es</a></div><div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial">Tel. (+34) 881 975 576<br><span style="text-align:-webkit-auto"> </span><br></div><div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"><img src="http://xercode.es/wp-content/uploads/2015/07/Xercode.png" width="200" height="38"><br></div><div style="color:rgb(0,0,0);font-size:small;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;font-family:arial"><br><span style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:rgb(34,34,34);text-align:justify">La información contenida en este mensaje de correo electrónico es confidencial y puede revestir el carácter de reservada. Está destinada exclusivamente a su destinatario. El acceso o uso de este mensaje, por parte de cualquier otra persona que no esté autorizada, puede ser ilegal. Si no es Ud. la persona destinataria, le rogamos que proceda a eliminar su contenido y comunicar dicha anomalía a su remitente.</span><br></div><div><p style="color:rgb(34,34,34);font-size:12.8px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;margin-bottom:0.0001pt;text-align:justify"><span style="font-size:10pt"><font face="arial, helvetica, sans-serif"><br></font></span></p><p style="color:rgb(34,34,34);font-size:12.8px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;margin-bottom:0.0001pt;text-align:justify"><span style="font-size:10pt"><font face="arial, helvetica, sans-serif">En cumplimiento de lo establecido por la LOPD 15/1999 le comunicamos que los datos personales contenidos en esta comunicación han sido recogidos de los contactos mantenidos por Ud. con personal de Xercode Media Software S.L. o de fuentes accesibles al público, y han sido incorporados a un fichero CLIENTES cuya finalidad es la de mantener con usted relaciones comerciales y/o profesionales.<br><br></font></span></p><p style="color:rgb(34,34,34);font-size:12.8px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;margin-bottom:0.0001pt;text-align:justify"></p><div><font face="arial, helvetica, sans-serif"><span style="text-align:justify"><span style="font-size:10pt">Asimismo, podrá ejercitar sus derechos de acceso, rectificación, cancelación y oposición enviando un escrito a </span><span style="font-size:13.3333px">C/ Hedras, 4 2ºA</span><span style="font-size:10pt"> , 15895, Milladoiro -</span></span><span style="color:rgb(34,34,34);font-size:10pt;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify"> </span><span style="color:rgb(34,34,34);font-size:10pt;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;text-align:justify">Ames, A Coruña – Spain, junto con prueba válida en derecho, como fotocopia del D.N.I. e indicando en el asunto "PROTECCIÓN DE DATOS".</span><span style="font-size:12.8px"> </span></font></div></div></div></span><br></div></div></div></div></div></div>
</div>