<div dir="ltr">Good morning!<div><br><div>Trying to run collocations on a corpus in Spanish, I've got an error.</div><div><br></div><div>Somehow, the word frequency list wasn't generated.</div><div><br></div><div>I tried to generate it again but the process fails and I get the traceback that I copy/paste below.</div><div><br></div><div>Is this a CQPweb issue or should I check some settings of the MySQL database?</div><div><br></div><div>Cheers,</div><div><br></div><div>jmm</div><div><br></div><div>--- TRACEBACK ---</div><div><br></div><div><div>CQPweb encountered an error and could not continue.</div><div> </div><div><br></div><div>A MySQL query did not run successfully!</div><div><br></div><div> </div><div><br></div><div> </div><div><br></div><div>Original query: LOAD DATA LOCAL INFILE '/data/cqpweb/tmp/______tempfreq_spanish.tbl' INTO TABLE `__tempfreq_spanish` FIELDS ESCAPED BY '' /* from User: datamaran | Function: corpus_make_freqtables() | 2018-Aug-03 12:41:27 */</div><div><br></div><div> </div><div><br></div><div> </div><div><br></div><div>Error # 1300: Invalid utf8 character string: ''</div><div><br></div><div> </div><div><br></div><div>PHP debugging backtrace</div><div>array(6) {</div><div> [1]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(40) "/var/www/html/cqpweb/lib/library.inc.php"</div><div> ["line"]=></div><div> int(286)</div><div> ["function"]=></div><div> string(20) "exiterror_mysqlquery"</div><div> ["args"]=></div><div> array(3) {</div><div> [0]=></div><div> int(1300)</div><div> [1]=></div><div> string(33) "Invalid utf8 character string: ''"</div><div> [2]=></div><div> string(210) "LOAD DATA LOCAL INFILE '/data/cqpweb/tmp/______tempfreq_spanish.tbl' INTO TABLE `__tempfreq_spanish` FIELDS ESCAPED BY '' </div><div><span style="white-space:pre">        </span>/* from User: datamaran | Function: corpus_make_freqtables() | 2018-Aug-03 12:41:27 */"</div><div> }</div><div> }</div><div> [2]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(40) "/var/www/html/cqpweb/lib/library.inc.php"</div><div> ["line"]=></div><div> int(410)</div><div> ["function"]=></div><div> string(14) "do_mysql_query"</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> &string(210) "LOAD DATA LOCAL INFILE '/data/cqpweb/tmp/______tempfreq_spanish.tbl' INTO TABLE `__tempfreq_spanish` FIELDS ESCAPED BY '' </div><div><span style="white-space:pre">        </span>/* from User: datamaran | Function: corpus_make_freqtables() | 2018-Aug-03 12:41:27 */"</div><div> }</div><div> }</div><div> [3]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(42) "/var/www/html/cqpweb/lib/freqtable.inc.php"</div><div> ["line"]=></div><div> int(124)</div><div> ["function"]=></div><div> string(21) "do_mysql_infile_query"</div><div> ["args"]=></div><div> array(3) {</div><div> [0]=></div><div> string(18) "__tempfreq_spanish"</div><div> [1]=></div><div> string(43) "/data/cqpweb/tmp/______tempfreq_spanish.tbl"</div><div> [2]=></div><div> bool(true)</div><div> }</div><div> }</div><div> [4]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(42) "/var/www/html/cqpweb/lib/admin-lib.inc.php"</div><div> ["line"]=></div><div> int(838)</div><div> ["function"]=></div><div> string(22) "corpus_make_freqtables"</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> string(7) "spanish"</div><div> }</div><div> }</div><div> [5]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(47) "/var/www/html/cqpweb/lib/metadata-admin.inc.php"</div><div> ["line"]=></div><div> int(179)</div><div> ["function"]=></div><div> string(40) "create_text_metadata_auto_freqlist_calls"</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> string(7) "spanish"</div><div> }</div><div> }</div><div> [6]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(43) "/var/www/html/cqpweb/exe/metadata-admin.php"</div><div> ["line"]=></div><div> int(3)</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> string(47) "/var/www/html/cqpweb/lib/metadata-admin.inc.php"</div><div> }</div><div> ["function"]=></div><div> string(7) "require"</div><div> }</div><div>}</div></div><div><br></div><div><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>--</div><div><div>José Manuel Martínez Martínez</div><div><a href="https://chozelinek.github.io" target="_blank">https://chozelinek.github.io</a></div></div></div></div></div></div></div></div>
</div></div></div>