<html><head></head><body><div><span>Dear All<br></span></div><div> </div><div><span>I also got the same problems in installation and post-installation of Koha 3.22.06 on Ubuntu 16.04 (MySQL 5.7.12). I followed the following steps to get rid of the situation in our departmental ICT lab.</span></div><div> </div><div><span>Installation </span></div><div> </div><div><span>1. Off default sql_mode;</span></div><div><span>2. Web installer still fails in step 3;</span></div><div><span>3. Changed Kohastructue.sql (Tables letter and permissions)</span></div><div><span>4. Imported kohastructure.sql manually to Koha_instancename db (after vacating it)</span></div><div><span>5. Altered Koha_instancename db to make it Unicode compatible as we are using multilingual records (ALTER DATABASE `koha_instancaname` CHARACTER SET utf8 COLLATE utf8_unicode_ci;)</span></div><div><span>6. Again started web installer and this time it worked</span></div><div><span>7. Finished installation and logged on to koha for post installation works</span></div><div><span>6. Retured to default sql_mode</span></div><div> </div><div><span>Post installtion work</span></div><div> </div><div><span>1. Tried all basic operations in post installation phase - all worked except add patron (always says no patron category thoug it is present there) </span></div><div><span>2. Again set off ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES in sql_mode</span></div><div><span>3. Recheked and found everything is working</span></div><div> </div><div><span>Questions</span></div><div><span>1. Is it safe and secured to keep ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES off in MySQL 5.7.12 (or latter versions)?</span></div><div><span>2. Is it wise to use Koha 3.22.06 or 16.05 vesion (having same problems) on ubuntu 16.04 (with MySQL 5.7.12) in production mode?</span></div><div> </div><div> </div><div><span>The entire process in step-step manner has alreday been documented and uploaed in github. Those who are facing same problems and wish to have a solution may check it from here:</span></div><div> </div><div><span>https://github.com/psmukhopadhyay/OLS</span></div><div> </div><div><span>https://github.com/psmukhopadhyay/OLS/blob/master/Koha%203.22.x%20on%20Ubuntu%2016.04%28psm%29.pdf</span></div><div> </div><div> </div><div><span>But a caution: I'm no DBMS expert (a teacher in LIS by profession to be exact) and the entire process requires authentication and clearence by Koha experts working DBMS domain.</span></div><div> </div><div> </div><div><span>Regards </span></div><div> </div><div><span>----------------------------------------------------<br><br>Dr. Parthasarathi Mukhopadhyay<br><br>Associate Professor<br><br>Department of Library and Information Science<br><br>University of Kalyani (WB, India)<br><br>------------------------------------------</span></div><div>
<br><br>At 30 May 2016 09:32:09 +0000 (+00:00) from Juan Francisco Romay Sieira <juan.sieira@xercode.es>:</div><blockquote style="margin-left: 10px; padding-left: 10px; border-left: 3px solid #FFCC33;">
<div>Hello,
<div>we found this issue some days ago, and this is what we do:</div>
<div> </div>
<div>
<pre style="margin-top: 0.0px; margin-bottom: 0.0px; padding: 0.0px; font-size: 12.0px; line-height: 1.4; color: #333333;"><span style="font-family: monospace,monospace;"><span class="" style="font-weight: bold;">sub </span><span class="" style="color: #990000; font-weight: bold;">_new_schema</span> <span class="">{</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-49"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-50"></a> <span class="" style="color: #999999;">require</span> <span class="" style="color: #555555;">Koha::</span><span class="">Schema</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-51"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-52"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$context</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #555555;">C4::</span><span class="">Context</span><span class="" style="font-weight: bold;">-></span><span class="" style="font-weight: bold;">new</span><span class="">();</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-53"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-54"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$db_driver</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$context</span><span class="" style="font-weight: bold;">-></span><span class="">{</span><span class="">db_driver</span><span class="">};</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-55"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-56"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$db_name</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$context</span><span class="" style="font-weight: bold;">-></span><span class="">config</span><span class="">(</span><span class="" style="color: #bb8844;">"database"</span><span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-57"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$db_host</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$context</span><span class="" style="font-weight: bold;">-></span><span class="">config</span><span class="">(</span><span class="" style="color: #bb8844;">"hostname"</span><span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-58"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$db_port</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$context</span><span class="" style="font-weight: bold;">-></span><span class="">config</span><span class="">(</span><span class="" style="color: #bb8844;">"port"</span><span class="">)</span> <span class="" style="font-weight: bold;">||</span> <span class="" style="color: #bb8844;">''</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-59"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$db_user</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$context</span><span class="" style="font-weight: bold;">-></span><span class="">config</span><span class="">(</span><span class="" style="color: #bb8844;">"user"</span><span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-60"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$db_passwd</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$context</span><span class="" style="font-weight: bold;">-></span><span class="">config</span><span class="">(</span><span class="" style="color: #bb8844;">"pass"</span><span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-61"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-62"></a> <span class="" style="font-weight: bold;">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 style="color: #3572b0;" target="_blank" name="Database.pm-63"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$tz</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$ENV</span><span class="">{</span><span class="">TZ</span><span class="">};</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-64"></a> <span class="" style="font-weight: bold;">if</span> <span class="">(</span> <span class="" style="color: teal;">$db_driver</span> <span class="" style="font-weight: bold;">eq</span> <span class="" style="color: #bb8844;">'mysql'</span> <span class="">)</span> <span class="">{</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-65"></a> <span class="" style="color: teal;">%encoding_attr</span> <span class="" style="font-weight: bold;">=</span> <span class="">(</span> <span class="">mysql_enable_utf8</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: #009999;">1</span> <span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-66"></a> <span class="" style="color: teal;">$encoding_query</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #bb8844;">"set NAMES 'utf8'"</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-67"></a> <span class="" style="color: teal;">$tz_query</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #bb8844;">qq(SET time_zone = "$tz")</span> <span class="" style="font-weight: bold;">if</span> <span class="" style="color: teal;">$tz</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-68"></a> <span class="" style="color: teal;">$sql_mode</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #bb8844;">"set sql_mode = ''"</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-69"></a> <span class="">}</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-70"></a> <span class="" style="font-weight: bold;">elsif</span> <span class="">(</span> <span class="" style="color: teal;">$db_driver</span> <span class="" style="font-weight: bold;">eq</span> <span class="" style="color: #bb8844;">'Pg'</span> <span class="">)</span> <span class="">{</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-71"></a> <span class="" style="color: teal;">$encoding_query</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #bb8844;">"set client_encoding = 'UTF8';"</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-72"></a> <span class="" style="color: teal;">$tz_query</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #bb8844;">qq(SET TIME ZONE = "$tz")</span> <span class="" style="font-weight: bold;">if</span> <span class="" style="color: teal;">$tz</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-73"></a> <span class="">}</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-74"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$schema</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #555555;">Koha::</span><span class="">Schema</span><span class="" style="font-weight: bold;">-></span><span class="" style="color: #999999;">connect</span><span class="">(</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-75"></a> <span class="">{</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-76"></a> <span class="">dsn</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: #bb8844;">"dbi:$db_driver:database=$db_name;host=$db_host;port=$db_port"</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-77"></a> <span class="">user</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: teal;">$db_user</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-78"></a> <span class="">password</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: teal;">$db_passwd</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-79"></a> <span class="" style="color: teal;">%encoding_attr</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-80"></a> <span class="">RaiseError</span> <span class="" style="font-weight: bold;">=></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: #009999;">1</span> <span class="">:</span> <span class="" style="color: #009999;">0</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-81"></a> <span class="">PrintError</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: #009999;">1</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-82"></a> <span class="">unsafe</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: #009999;">1</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-83"></a> <span class="">quote_names</span> <span class="" style="font-weight: bold;">=></span> <span class="" style="color: #009999;">1</span><span class="">,</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-84"></a> <span class="">on_connect_do</span> <span class="" style="font-weight: bold;">=></span> <span class="">[</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-85"></a> <span class="" style="color: teal;">$encoding_query</span> <span class="" style="font-weight: bold;">||</span> <span class="">(),</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-86"></a> <span class="" style="color: teal;">$tz_query</span> <span class="" style="font-weight: bold;">||</span> <span class="">(),</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-87"></a> <span class="" style="color: teal;">$sql_mode</span> <span class="" style="font-weight: bold;">||</span> <span class="">(),</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-88"></a> <span class="">]</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-89"></a> <span class="">}</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-90"></a> <span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-91"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-92"></a> <span class="" style="font-weight: bold;">my</span> <span class="" style="color: teal;">$dbh</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: teal;">$schema</span><span class="" style="font-weight: bold;">-></span><span class="">storage</span><span class="" style="font-weight: bold;">-></span><span class="">dbh</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-93"></a> <span class="" style="color: #999999;">eval</span> <span class="">{</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-94"></a> <span class="" style="color: teal;">$dbh</span><span class="" style="font-weight: bold;">-></span><span class="">{</span><span class="">RaiseError</span><span class="">}</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #009999;">1</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-95"></a> <span class="" style="color: teal;">$dbh</span><span class="" style="font-weight: bold;">-></span><span class="" style="font-weight: bold;">do</span><span class="">(</span><span class="" style="color: #bb8844;">q|</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-96"></a><span class="" style="color: #bb8844;"> SELECT * FROM systempreferences WHERE 1 = 0 |</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-97"></a> <span class="">);</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-98"></a> <span class="" style="color: teal;">$dbh</span><span class="" style="font-weight: bold;">-></span><span class="">{</span><span class="">RaiseError</span><span class="">}</span> <span class="" style="font-weight: bold;">=</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: #009999;">1</span> <span class="">:</span> <span class="" style="color: #009999;">0</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-99"></a> <span class="">};</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-100"></a> <span class="" style="color: teal;">$dbh</span><span class="" style="font-weight: bold;">-></span><span class="">{</span><span class="">RaiseError</span><span class="">}</span> <span class="" style="font-weight: bold;">=</span> <span class="" style="color: #009999;">0</span> <span class="" style="font-weight: bold;">if</span> <span class="" style="color: teal;">$@</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-101"></a>
<a style="color: #3572b0;" target="_blank" name="Database.pm-102"></a> <span class="" style="font-weight: bold;">return</span> <span class="" style="color: teal;">$schema</span><span class="">;</span>
<a style="color: #3572b0;" target="_blank" name="Database.pm-103"></a><span class="">}</span></span></pre>
</div>
<div> </div>
<div>Regards,</div>
<div> </div>
</div>
<div class="gmail_extra">
<br>
<div class="gmail_quote">2016-05-26 17:59 GMT+02:00 Tomas Cohen Arazi <<a href="mailto:tomascohen@gmail.com" target="_blank">tomascohen@gmail.com</a>>:<br>
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex; border-left: 1.0px #cccccc solid; padding-left: 1.0ex;">
<div>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>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ó:</div>
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex; border-left: 1.0px #cccccc solid; padding-left: 1.0ex;">
<div>Hi,
<div>testing things on MySQL 5.7 - Koha 3.22, found a new problem:</div>
<div> </div>
<div>
<span style="font-family: monospace; color: #000000;"><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>
</div>
<div> </div>
<div>This comes trying to add a patron after fresh install, 3.22+marc21+all sample data</div>
<div> </div>
<div>Can we change sql_mode for Koha?</div>
<div> </div>
<div>Regards</div>
<div>Bernardo</div>
<div> </div>
<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>
</div>
<span class="HOEnZb"><span style="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" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br> website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br> git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br> bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></span></span>
</blockquote>
</div>
<div>-- </div>
<div>
<div>
<div style="color: #757575; font-family: 'helvetica neue' , helvetica , arial , sans-serif; font-size: 12.8px;">Tomás Cohen Arazi</div>
<div style="color: #757575; 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 target="_blank">+54 9351 3513384</a><br>GPG: B2F3C15F</div>
</div>
</div>
<br>_______________________________________________<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" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br> website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br> git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br> bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a>
</blockquote>
</div>
<br><br clear="all">
<div> </div>
-- <br>
<div class="gmail_signature">
<div>
<div>
<div>
<div>
<div>
<span style="text-indent: 0.0px;"><span style="text-indent: 0.0px;"><br clear="all"><br><span style="color: #000000; 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><span style="color: #000000; 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: 0.0px; font-family: arial;"> </span><br></span></span>
<div><strong> </strong></div>
<span style="text-indent: 0.0px;"><span style="text-indent: 0.0px;"><strong style="color: #000000; 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: 0.0px; font-family: arial;">Juan Francisco Romay Sieira</strong><br><span style="color: #000000; 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></span></span>
<div>
<div style="color: #000000; 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: 0.0px; font-family: arial;">
<em>Chief Technology Officer</em><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: #000000; 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: 0.0px; font-family: arial;">Tel. (+34) 881 975 576<br> </div>
<div style="color: #000000; 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: 0.0px; font-family: arial;"><img src="http://xercode.es/wp-content/uploads/2015/07/Xercode.png" alt="" width="200" height="38"></div>
<div style="color: #000000; 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: 0.0px; font-family: arial;">
<br><span style="font-family: arial , helvetica , sans-serif; font-size: 10.0pt; color: #222222; 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>
</div>
<div>
<p style="color: #222222; 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: 0.0px; text-align: justify;"><span style="font-size: 10.0pt;"><span style="font-family: arial,helvetica,sans-serif;"> </span></span></p>
<p style="color: #222222; 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: 0.0px; text-align: justify;"><span style="font-size: 10.0pt;"><span style="font-family: 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></span></span></p>
<p style="color: #222222; 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: 0.0px; text-align: justify;"> </p>
<div><span style="font-family: arial,helvetica,sans-serif;"><span style="text-align: justify;"><span style="font-size: 10.0pt;">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: 10.0pt;"> , 15895, Milladoiro -</span></span><span style="color: #222222; font-size: 10.0pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0.0px; text-align: justify;"> </span><span style="color: #222222; font-size: 10.0pt; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0.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></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote><div>--</div><div> </div></body></html>