OK, taht did it<br /><br />El Vie, 24 de Enero de 2014, 17:29, 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">I
get an “archive corrupt” message when I try to download, but it doesn’t
matter, since the MySQL error message makes it clear that the “Generate CWB
text-position records” is <strong><u>not</u></strong> the problem.</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">The
problem is at the previous stage, i.e. creation of the text metadata table in the first place.
A table has been created, but no text information has been loaded. You need to delete the
existing metadata table, and the “manage metadata” page will revert back to its
initial state, offering you different options for creating & loading a text metadata
table.</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">Remember
you must either (a) have an actual metadata file to load, or else (b) create a
“minimal” table automatically using just the text id, or (c) have XML in your
corpus form which metadata can be extracted.</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"><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"">
Andres Chandia [mailto:andres@chandia.net] <br /> <strong>Sent:</strong> 24 January 2014
16:21<br /> <strong>To:</strong> Hardie, Andrew<br /> <strong>Cc:</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>
<p style="margin-bottom:12.0pt" class="MsoNormal">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:</p>
<div>
<p class="MsoNormal">MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003
sec )</p>
</div>
<p class="MsoNormal"><span class="syntaxalphasyntaxalphareservedword"><span
style="font-size:10.0pt;font-family:"Courier
New","serif"">SELECT</span></span><span class="syntax"><span
style="font-size:10.0pt;font-family:"Courier New","serif"">
</span></span><span class="syntaxpunct"><span
style="font-size:10.0pt;font-family:"Courier
New","serif"">*</span></span><span class="syntax"><span
style="font-size:10.0pt;font-family:"Courier New","serif"">
</span></span><span style="font-size:10.0pt;font-family:"Courier
New","serif""><br /> <span class="syntaxalpha">FROM</span><span class="syntax">
</span><span class="syntaxquotesyntaxquotebacktick">`text_metadata_for_wikifr`</span><span
class="syntax"> </span><br /> <span
class="syntaxalphasyntaxalphareservedword">LIMIT</span><span class="syntax"> </span><span
class="syntaxdigitsyntaxdigitinteger">0</span><span class="syntax"> </span> <span
class="syntaxpunct">,</span><span class="syntax"> </span><span
class="syntaxdigit">30</span></span><br /> <br /> El Vie, 24 de Enero de 2014, 13:08, Hardie,
Andrew escribió:</p>
<div>
<div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" 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 style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" 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 style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Second
suggestion: copy-paste the output of <strong><span
style="font-family:"Verdana","sans-serif"">select * from {your text
metadata table}</span></strong> into a text file and send it me off list.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" 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><span
style="font-family:"Tahoma","sans-serif"">On Behalf Of
</span></strong>Andres Chandia<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 24 January
2014 11:55<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">To:</span></strong> Open source
development of the Corpus WorkBench<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Subject:</span></strong> Re:
[CWB] CWB Digest, Vol 84, Issue 20</span></p>
<pre>As I told you, now I get no error, but still the <span style="color:black">text</span></pre>
<pre><span style="color:black">metadata</span></pre>
<pre><span style="color:black">table</span> does not get populated,<br />I press the button</pre>
<pre>"Generate CWB text-position</pre>
<pre>records", the browser show as it is in process, but <br />when it finishes, it
still</pre>
<pre>say</pre>
<pre>"The text metadata table <strong><span style="font-family:"Courier
New","serif"">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?</pre>
<pre>how?<br /><br /><br />Hi, It maybe a problem due to disk space. You may check if the
system</pre>
<pre>files and</pre>
<pre>user files are in different partitions. df -h will give a details. If you don't have</pre>
<pre>enough</pre>
<pre>disk space for mysql temporary files in the partition that mysql uses, try changing</pre>
<pre>/tmp</pre>
<pre>location in my.conf to another location. Best On 01/24/2014 01:00 PM, <a
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
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 target="_blank" title="Este enlace externo se abrirá en
una nueva ventana"
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</span></pre>
<pre><span style="color:black">unsubscribe via</span></pre>
<pre><span style="color:black">the World Wide Web, visit</span> <span
style="color:black">></span></pre>
<pre><span style="color:black"> <a target="_blank" title="Este enlace externo se abrirá
en una nueva ventana"
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'</span></pre>
<pre><span style="color:black">to</span></pre>
<pre><span style="color:black">> <a target="_blank" title="Este enlace externo se
abrirá en una nueva ventana"
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</span></pre>
<pre><span style="color:black">person managing</span></pre>
<pre><span style="color:black">the list at</span> <span style="color:black">> <a
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
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,</span></pre>
<pre><span style="color:black">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></pre>
<pre><span style="color:black">></span> </pre>
<pre><span style="color:black">> </span></pre>
<pre><span
style="color:black">----------------------------------------------------------------------</span></pre>
<pre><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"</span></pre>
<pre><span style="color:black">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">>
</span></pre>
<pre><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">>
</span></pre>
<pre><span
style="color:black">b5b32fb6ac80f2d9e0716eab4b4369b9.squirrel@mail.chandia.net></span></pre>
<pre><span style="color:black">> Content-Type: text/plain;</span></pre>
<pre><span style="color:black">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</span></pre>
<pre><span style="color:black">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</span></pre>
<pre><span style="color:black">"View corpus</span></pre>
<pre><span style="color:black">metadata":</span> <span style="color:black">></span></pre>
<pre><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">></span></pre>
<pre><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></pre>
<pre><span style="color:black">></span> </pre>
<pre><span style="color:black">psicoaching.net</span> <span style="color:black">>
mapuche</span></pre>
<pre><span style="color:black">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">></span></pre>
<pre><span style="color:black">An HTML attachment was</span></pre>
<pre><span style="color:black">scrubbed...</span> <span style="color:black">>
URL:</span></pre>
<pre><span
style="color:black">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></pre>
<pre><span style="color:black">_______________________________________________</span> <span
style="color:black">> CWB</span></pre>
<pre><span style="color:black">mailing list</span> <span style="color:black">> <a
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
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 target="_blank" title="Este enlace externo se abrirá en
una nueva ventana"
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>_______________________________________________</pre>
<pre>CWB mailing list <a target="_blank" title="Este enlace externo se abrirá en una nueva
ventana"
href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it">CWB@sslmit.unibo.it</a></pre>
<pre><a target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></pre>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><br /> <br />
<br /> <br /> _______________________<br /> andrés chandía<br /> <a
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
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 target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
href="http://parles.upf.edu">parles.upf.edu</a><br /> <a target="_blank" title="Este enlace
externo se abrirá en una nueva ventana" href="http://psicoaching.net">psicoaching.net</a><br
/> <a target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
href="http://koyaktumapuche.net">mapuche koyaktu</a><br /> <a target="_blank" title="Este
enlace externo se abrirá en una nueva ventana" 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>
<p class="MsoNormal"><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>