ok you can download the debug file from here:
http://parles.upf.edu/llocs/cqp/wikifr/cqp.execute.php.debug.html.tar.gz<br />and the query
says this:<br /><br />
<div class="success">MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003
sec )</div>
<code class="sql"><span class="syntax"><span class="syntax_alpha
syntax_alpha_reservedWord">SELECT</span> <span class="syntax_punct">*</span> <br /><span
class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_quote
syntax_quote_backtick">`text_metadata_for_wikifr`</span> <span class="syntax_white
syntax_white_newline"></span><br /><span class="syntax_alpha
syntax_alpha_reservedWord">LIMIT</span> <span class="syntax_digit
syntax_digit_integer">0</span> <span class="syntax_punct syntax_punct_listsep">,</span> <span
class="syntax_digit syntax_digit_integer">30</span></span></code><br /><br />El Vie, 24 de
Enero de 2014, 13:08, Hardie, Andrew escribió:<br /> <!-- begin sanitized html -->
<style type="text/css">-></style>
<div class="bodyclass">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Almost
certainly there is a deeper problem here, since clicking that button ought always to result in
the metadata table containing begin-end points. If it doesn’t, something is clearly
very askew. </span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I
suggest you turn on debug message printing in the config file, then press the button again,
and see if you get any useful hints from the debug messages.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Second
suggestion: copy-paste the output of <strong>select * from {your text metadata table}</strong>
into a text file and send it me off list.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><strong><span lang="EN-US"
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></strong><span
lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it] <strong>On Behalf Of
</strong>Andres Chandia<br /> <strong>Sent:</strong> 24 January 2014 11:55<br />
<strong>To:</strong> Open source development of the Corpus WorkBench<br />
<strong>Subject:</strong> Re: [CWB] CWB Digest, Vol 84, Issue 20</span></p>
<p class="MsoNormal"> </p>
<pre>As I told you, now I get no error, but still the <span style="color:black">text
metadata</span></pre>
<pre><span style="color:black">table</span> does not get populated,<br />I press the button
"Generate CWB text-position</pre>
<pre>records", the browser show as it is in process, but <br />when it finishes, it still
say</pre>
<pre>"The text metadata table <strong><span style="font-family:"Courier
New"">has not yet been populated"</span></strong> and</pre>
<pre>checking<br />the db I see there is nothing.<br />can I populated from command line?
how?<br /><br /><br />Hi, It maybe a problem due to disk space. You may check if the system
files and</pre>
<pre>user files are in different partitions. df -h will give a details. If you don't have
enough</pre>
<pre>disk space for mysql temporary files in the partition that mysql uses, try changing
/tmp</pre>
<pre>location in my.conf to another location. Best On 01/24/2014 01:00 PM, <a title="Este
enlace externo se abrirá en una nueva ventana" target="_blank"
href="http://mail.chandia.net/src/compose.php?send_to=cwb-request%40sslmit.unibo.it">cwb-request@sslmit.unibo.it</a></pre>
<pre>wrote: <span style="color:black">> Send CWB mailing list submissions to</span> <span
style="color:black">> <a title="Este enlace externo se abrirá en una nueva ventana"
target="_blank"
href="http://mail.chandia.net/src/compose.php?send_to=cwb%40sslmit.unibo.it">cwb@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">> To subscribe or
unsubscribe via</span></pre>
<pre><span style="color:black">the World Wide Web, visit</span> <span style="color:black">>
<a title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></span></pre>
<pre><span style="color:black">> or, via email, send a message with subject or body 'help'
to</span></pre>
<pre><span style="color:black">> <a title="Este enlace externo se abrirá en una
nueva ventana" target="_blank"
href="http://mail.chandia.net/src/compose.php?send_to=cwb-request%40sslmit.unibo.it">cwb-request@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">> You can reach the
person managing</span></pre>
<pre><span style="color:black">the list at</span> <span style="color:black">> <a
title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="http://mail.chandia.net/src/compose.php?send_to=cwb-owner%40sslmit.unibo.it">cwb-owner@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">> When replying,
please edit your</span></pre>
<pre><span style="color:black">Subject line so it is more specific</span> <span
style="color:black">> than "Re: Contents</span></pre>
<pre><span style="color:black">of CWB digest..."</span> <span
style="color:black">></span> <span style="color:black">></span> <span
style="color:black">> Today's Topics:</span> <span style="color:black">></span> <span
style="color:black">> 1. text metadata table population</span></pre>
<pre><span style="color:black">(Andres Chandia)</span> <span style="color:black">></span>
<span style="color:black">></span></pre>
<pre><span style="color:black">> </span></pre>
<pre><span
style="color:black">----------------------------------------------------------------------</span>
<span style="color:black">></span> <span style="color:black">> Message: 1</span> <span
style="color:black">> Date: Fri, 24 Jan 2014 11:49:50 +0100</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">From: "Andres Chandia"
andres@chandia.net></span></pre>
<pre><span style="color:black">> To: "Open source development of the Corpus</span></pre>
<pre><span style="color:black">WorkBench"</span> <span style="color:black">>
cwb@sslmit.unibo.it></span></pre>
<pre><span style="color:black">> Subject: [CWB] text metadata table population</span> <span
style="color:black">> Message-ID:</span> <span style="color:black">>
b5b32fb6ac80f2d9e0716eab4b4369b9.squirrel@mail.chandia.net></span></pre>
<pre><span style="color:black">> Content-Type: text/plain;
charset="iso-8859-1"</span></pre>
<pre><span style="color:black">></span> <span style="color:black">></span> <span
style="color:black">></span> <span style="color:black">> Hi there again,</span> <span
style="color:black">></span> <span style="color:black">> text metadata table never
gets</span></pre>
<pre><span style="color:black">populated, I think it is because the</span> <span
style="color:black">> corpuse is too big, as</span></pre>
<pre><span style="color:black">a consequence (myabe I'm wrong) I get this error when I go to
"View corpus</span></pre>
<pre><span style="color:black">metadata":</span> <span style="color:black">></span>
<span style="color:black">> A mySQL</span></pre>
<pre><span style="color:black">query did not run successfully!</span> <span
style="color:black">> Error # 3: Error writing</span></pre>
<pre><span style="color:black">file '/tmp/MYMRH0KR' (Errcode: 28)</span> <span
style="color:black">> How can I solve</span></pre>
<pre><span style="color:black">this?</span> <span style="color:black">></span> <span
style="color:black">> thanks</span> <span style="color:black">></span> <span
style="color:black">> _______________________</span> <span style="color:black">>
????????????????????????andr??s</span> <span style="color:black">></span></pre>
<pre><span style="color:black">chand??a</span> <span style="color:black">></span> <span
style="color:black">> administrador</span></pre>
<pre><span style="color:black">de</span> <span style="color:black">> parles.upf.edu</span>
<span style="color:black">></span></pre>
<pre><span style="color:black">psicoaching.net</span> <span style="color:black">> mapuche
koyaktu</span> <span style="color:black">> ong mapuche koyaktu</span> <span
style="color:black">> P No imprima</span></pre>
<pre><span style="color:black">innecesariamente. ??Cuide el medio ambiente!</span> <span
style="color:black">> --------------</span></pre>
<pre><span style="color:black">next part --------------</span> <span style="color:black">>
An HTML attachment was</span></pre>
<pre><span style="color:black">scrubbed...</span> <span style="color:black">> URL:
http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20140124/d70439b8/attachment-0001.html></span></pre>
<pre><span style="color:black">></span> <span style="color:black">></span></pre>
<pre><span style="color:black">------------------------------</span> <span
style="color:black">></span> <span style="color:black">>
_______________________________________________</span> <span style="color:black">> CWB
mailing list</span> <span style="color:black">> <a title="Este enlace externo se abrirá en
una nueva ventana" target="_blank"
href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it">CWB@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">> <a title="Este enlace externo se abrirá en una nueva
ventana" target="_blank"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">></span> <span
style="color:black">></span></pre>
<pre><span style="color:black">End of CWB Digest, Vol 84, Issue 20</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">***********************************</span>
_______________________________________________</pre>
<pre>CWB mailing list <a title="Este enlace externo se abrirá en una nueva ventana"
target="_blank"
href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it">CWB@sslmit.unibo.it</a></pre>
<pre><a title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></pre>
<p class="MsoNormal"><br /> <br /> <br /> <br /> _______________________<br />
andrés chandía<br /> <a title="Este enlace externo se abrirá en una nueva
ventana" target="_blank" href="http://www.chandia.net"><span style="border:solid windowtext
1.0pt;padding:0cm;text-decoration:none">[IMAGE REMOVED]</span></a><br /> administrador de<br /> <a title="Este enlace externo se
abrirá en una nueva ventana" target="_blank"
href="http://parles.upf.edu">parles.upf.edu</a><br /> <a title="Este enlace externo se abrirá
en una nueva ventana" target="_blank" href="http://psicoaching.net">psicoaching.net</a><br />
<a title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="http://koyaktumapuche.net">mapuche koyaktu</a><br /> <a title="Este enlace externo se
abrirá en una nueva ventana" target="_blank" href="http://corporacionkoyaktu.net">ong mapuche
koyaktu</a><br /> <span style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P
</span><span style="font-size:10.0pt;color:#4F6228">No imprima innecesariamente. ¡Cuide
el medio ambiente!</span></p>
</div>
</div>
<!-- end sanitized html --> <br /><br /><br />_______________________<br
/> andrés
chandía<br /><a target="_blank" href="http://www.chandia.net"><img border="0"
alt="chandia.net" src="http://www.chandia.net/sites/default/files/images/chandia.netd.png"
/></a><a target="_blank" href="https://twitter.com/andreschandia"><img
src="http://www.upf.edu/universitat/_img/ico_tw.png" alt="" /></a><br />administrador de<br
/><a href="http://parles.upf.edu">parles.upf.edu</a><br /><a
href="http://psicoaching.net">psicoaching.net</a><br /><a
href="http://koyaktumapuche.net">mapuche koyaktu</a><br /><a
href="http://corporacionkoyaktu.net">ong mapuche koyaktu</a><br /><span style="font-size:
18pt; color: rgb(79, 98, 40); font-family: Webdings;">P </span><span style="font-size: 10pt;
color: rgb(79, 98, 40);">No imprima innecesariamente. ¡Cuide el medio ambiente!</span>