<div dir="ltr"><div>Thanks Andrew for your answer, but I'm sorry to say, that when I detected the problem i had<br></div><div>;mysqli.local_infile_directory = <br></div><div><br></div><div>then, as suggested by the error log, I activate it, but nothing changed, I have commented out already...</div><div><br></div><div>thanks again...</div><div><br></div><div><br></div><div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span style="color:rgb(0,0,255)"><i><span style="font-family:trebuchet ms,sans-serif">... Andrés Chandía</span></i></span><br></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> del dia dl., 19 de set. 2022 a les 17:03:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-1970036168755361599">
<div lang="EN-GB">
<div class="m_-8441327975158671966WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">My guess: You’ve caused it by setting local-infile-directory.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">That’s a string setting, which if set limits LOCAL INFILE to a particular directory. You’ve set it to Boolean true, which translates
to string “1”. Obviously this will block infile from working anywhere.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><a href="https://www.php.net/manual/en/mysqli.configuration.php#ini.mysqli.local-infile-directory" target="_blank">https://www.php.net/manual/en/mysqli.configuration.php#ini.mysqli.local-infile-directory</a>
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">I suggest leaving it unset.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 18 September 2022 16:03<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] CQPWeb Create minimal metadata table crashes<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">CQPWeb: v3.2.43<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Php 8.1<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysql Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: LOAD DATA LOCAL INFILE is forbidden, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory or PDO::MYSQL_ATTR_LOCAL_INFILE|PDO::MYSQL_ATTR_LOCAL_INFILE_DIRECTORY
in /corptedig-glif/cqpweb/lib/sql-lib.php:211\nStack trace:\n#0 /corptedig-glif/cqpweb/lib/sql-lib.php(211): mysqli_query()\n#1 /corptedig-glif/cqpweb/lib/sql-lib.php(350): do_sql_query()\n#2 /corptedig-glif/cqpweb/lib/metadata-lib.php(1050): do_sql_infile_query()\n#3
/corptedig-glif/cqpweb/lib/metadata-act.php(191): create_text_metadata_minimalist()\n#4 /corptedig-glif/cqpweb/exe/metadata-act.php(1): require('...')\n#5 {main}\n thrown in /corptedig-glif/cqpweb/lib/sql-lib.php on line 211', referer:
<a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcorptedig-glif.upf.edu%2Fcqpweb%2Fbnc%2Findex.php%3Fui%3DmanageMetadata&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ccb24eb819b0741389a6808da9986f4a7%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991102569802980%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=h2ogmx6DvH%2FWGgbac49Bn%2BrAY4gCR%2FNLtAuKOnxSeYI%3D&reserved=0" target="_blank">
http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">/etc/php/8.1/apache2/php.ini <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysqli.allow_local_infile = On<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysqli.local_infile_directory = On<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">/etc/mysql/mysql.conf.d/mysqld.cnf<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">local_infile = true<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks<u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<table style="width:100%" width="100%" cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:12%;padding:0cm" width="12%">
<p><img style="width: 1.6875in; height: 0.6458in;" id="m_-8441327975158671966_x0000_i1034" src="https://www.upf.edu/documents/10193/6775906/signatura-correu.png" alt="https://www.upf.edu/documents/10193/6775906/signatura-correu.png" width="162" height="62" border="0"><u></u><u></u></p>
</td>
<td style="padding:0cm">
<p><b><span style="font-size:10pt;font-family:"Verdana",sans-serif" lang="ES">Andrés Chandía</span></b><span lang="ES"><br>
</span><span style="font-size:10pt;font-family:"Verdana",sans-serif" lang="ES">Unitat de Traducció i Ciències del Llenguatge<br>
Roc Boronat 138, C. P.: 08018, Barcelona<br>
Tel.: 935 055 722 - </span><a href="mailto:andres.chandia@upf.edu" target="_blank"><span style="font-size:10pt;font-family:"Verdana",sans-serif" lang="ES">mail:andres.chandia@upf.edu</span></a><span lang="ES"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="padding:1.5pt">
<p class="MsoNormal"><a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.chandia.net%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ccb24eb819b0741389a6808da9986f4a7%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991102569802980%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=C%2F%2Bj%2FNbG%2B%2F%2FHEJaDvLAOhcstsJ%2FSfHDIFUxH5i%2FZkHw%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 1.0208in; height: 0.4583in;" id="m_-8441327975158671966_x0000_i1033" src="http://mail.chandia.net/images/chandia_net.png" alt="chandia.net" width="98" height="44" border="0"></span></a><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fchandianet&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ccb24eb819b0741389a6808da9986f4a7%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991102569802980%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=VEaIJDzB8u7W00lk0eXv3Kr0ho1R5vglRWo9qvNh270%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 0.2083in; height: 0.2083in;" id="m_-8441327975158671966_x0000_i1032" src="http://mail.chandia.net/images/ico_tw.png" alt="http://mail.chandia.net/images/ico_tw.png" width="20" height="20" border="0"></span></a><u></u><u></u></p>
</td>
<td style="padding:1.5pt">
<p class="MsoNormal"><a href="mailto:andres@chandia.net" target="_blank"><span style="font-size:10pt;font-family:"Verdana",sans-serif">mail:andres@chandia.net</span></a><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<div class="MsoNormal" style="text-align:center" align="center">
<hr style="color:rgb(200,16,46)" width="100%" size="1" noshade align="center">
</div>
<p class="MsoNormal"><img style="width: 3.4583in; height: 0.4479in;" id="m_-8441327975158671966_x0000_i1031" src="https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ" alt="https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ" width="332" height="43" border="0"><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</div></blockquote></div>