<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New","serif";}
span.syntax
{mso-style-name:syntax;}
span.syntaxalphasyntaxalphareservedword
{mso-style-name:"syntax_alpha\000D\000Asyntax_alpha_reservedword";}
span.syntaxpunct
{mso-style-name:syntax_punct;}
span.syntaxalpha
{mso-style-name:syntax_alpha;}
span.syntaxquotesyntaxquotebacktick
{mso-style-name:"syntax_quote\000D\000Asyntax_quote_backtick";}
span.syntaxwhitesyntaxwhitenewline
{mso-style-name:"syntax_white\000D\000Asyntax_white_newline";}
span.syntaxdigitsyntaxdigitinteger
{mso-style-name:"syntax_digit\000D\000Asyntax_digit_integer";}
span.syntaxdigit
{mso-style-name:syntax_digit;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-GB;}
span.EmailStyle29
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<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 <b><u>not</u></b> the problem.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Andres Chandia [mailto:andres@chandia.net]
<br>
<b>Sent:</b> 24 January 2014 16:21<br>
<b>To:</b> Hardie, Andrew<br>
<b>Cc:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> RE: [CWB] CWB Digest, Vol 84, Issue 20<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">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:<o:p></o:p></p>
<div>
<p class="MsoNormal">MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec )<o:p></o:p></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ó:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<pre>As I told you, now I get no error, but still the <span style="color:black">text<o:p></o:p></span></pre>
<pre><span style="color:black">metadata</span><o:p></o:p></pre>
<pre><span style="color:black">table</span> does not get populated,<br>I press the button<o:p></o:p></pre>
<pre>"Generate CWB text-position<o:p></o:p></pre>
<pre>records", the browser show as it is in process, but <br>when it finishes, it still<o:p></o:p></pre>
<pre>say<o:p></o:p></pre>
<pre>"The text metadata table <strong><span style="font-family:"Courier New","serif"">has not yet been populated"</span></strong> and<o:p></o:p></pre>
<pre>checking<br>the db I see there is nothing.<br>can I populated from command line?<o:p></o:p></pre>
<pre>how?<br><br><br>Hi, It maybe a problem due to disk space. You may check if the system<o:p></o:p></pre>
<pre>files and<o:p></o:p></pre>
<pre>user files are in different partitions. df -h will give a details. If you don't have<o:p></o:p></pre>
<pre>enough<o:p></o:p></pre>
<pre>disk space for mysql temporary files in the partition that mysql uses, try changing<o:p></o:p></pre>
<pre>/tmp<o:p></o:p></pre>
<pre>location in my.conf to another location. Best On 01/24/2014 01:00 PM, <a href="http://mail.chandia.net/src/compose.php?send_to=cwb-request%40sslmit.unibo.it" target="_blank" title="Este
enlace externo se abrirá en una nueva ventana">cwb-request@sslmit.unibo.it</a><o:p></o:p></pre>
<pre>wrote: <span style="color:black">> Send CWB mailing list submissions to</span> <span style="color:black">> <a href="http://mail.chandia.net/src/compose.php?send_to=cwb%40sslmit.unibo.it" target="_blank" title="Este enlace externo se abrirá en una nueva ventana">cwb@sslmit.unibo.it</a></span><o:p></o:p></pre>
<pre><span style="color:black">></span> <span style="color:black">> To subscribe or<o:p></o:p></span></pre>
<pre><span style="color:black">unsubscribe via</span><o:p></o:p></pre>
<pre><span style="color:black">the World Wide Web, visit</span> <span style="color:black">><o:p></o:p></span></pre>
<pre><span style="color:black"> <a href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank" title="Este enlace externo se abrirá en una nueva ventana">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></span><o:p></o:p></pre>
<pre><span style="color:black">> or, via email, send a message with subject or body 'help'<o:p></o:p></span></pre>
<pre><span style="color:black">to</span><o:p></o:p></pre>
<pre><span style="color:black">> <a href="http://mail.chandia.net/src/compose.php?send_to=cwb-request%40sslmit.unibo.it" target="_blank" title="Este enlace externo se abrirá en una
nueva ventana">cwb-request@sslmit.unibo.it</a></span><o:p></o:p></pre>
<pre><span style="color:black">></span> <span style="color:black">> You can reach the<o:p></o:p></span></pre>
<pre><span style="color:black">person managing</span><o:p></o:p></pre>
<pre><span style="color:black">the list at</span> <span style="color:black">> <a href="http://mail.chandia.net/src/compose.php?send_to=cwb-owner%40sslmit.unibo.it" target="_blank" title="Este enlace externo se abrirá en una nueva ventana">cwb-owner@sslmit.unibo.it</a></span><o:p></o:p></pre>
<pre><span style="color:black">></span> <span style="color:black">> When replying,<o:p></o:p></span></pre>
<pre><span style="color:black">please edit your</span><o:p></o:p></pre>
<pre><span style="color:black">Subject line so it is more specific</span> <span style="color:black">> than "Re: Contents</span><o:p></o:p></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><o:p></o:p></pre>
<pre><span style="color:black">(Andres Chandia)</span> <span style="color:black">></span><o:p></o:p></pre>
<pre><span style="color:black">></span><o:p> </o:p></pre>
<pre><span style="color:black">> </span><o:p></o:p></pre>
<pre><span style="color:black">----------------------------------------------------------------------</span><o:p></o:p></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><o:p></o:p></pre>
<pre><span style="color:black">From: "Andres Chandia"<o:p></o:p></span></pre>
<pre><span style="color:black">andres@chandia.net></span><o:p></o:p></pre>
<pre><span style="color:black">> To: "Open source development of the Corpus</span><o:p></o:p></pre>
<pre><span style="color:black">WorkBench"</span> <span style="color:black">> <o:p></o:p></span></pre>
<pre><span style="color:black">cwb@sslmit.unibo.it></span><o:p></o:p></pre>
<pre><span style="color:black">> Subject: [CWB] text metadata table population</span> <span style="color:black">> Message-ID:</span> <span style="color:black">> <o:p></o:p></span></pre>
<pre><span style="color:black">b5b32fb6ac80f2d9e0716eab4b4369b9.squirrel@mail.chandia.net></span><o:p></o:p></pre>
<pre><span style="color:black">> Content-Type: text/plain;<o:p></o:p></span></pre>
<pre><span style="color:black">charset="iso-8859-1"</span><o:p></o:p></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<o:p></o:p></span></pre>
<pre><span style="color:black">gets</span><o:p></o:p></pre>
<pre><span style="color:black">populated, I think it is because the</span> <span style="color:black">> corpuse is too big, as</span><o:p></o:p></pre>
<pre><span style="color:black">a consequence (myabe I'm wrong) I get this error when I go to<o:p></o:p></span></pre>
<pre><span style="color:black">"View corpus</span><o:p></o:p></pre>
<pre><span style="color:black">metadata":</span> <span style="color:black">></span><o:p></o:p></pre>
<pre><span style="color:black">> A mySQL</span><o:p></o:p></pre>
<pre><span style="color:black">query did not run successfully!</span> <span style="color:black">> Error # 3: Error writing</span><o:p></o:p></pre>
<pre><span style="color:black">file '/tmp/MYMRH0KR' (Errcode: 28)</span> <span style="color:black">> How can I solve</span><o:p></o:p></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">><o:p></o:p></span></pre>
<pre><span style="color:black">????????????????????????andr??s</span> <span style="color:black">></span><o:p></o:p></pre>
<pre><span style="color:black">chand??a</span> <span style="color:black">></span> <span style="color:black">> administrador</span><o:p></o:p></pre>
<pre><span style="color:black">de</span> <span style="color:black">> parles.upf.edu</span><o:p></o:p></pre>
<pre><span style="color:black">></span><o:p> </o:p></pre>
<pre><span style="color:black">psicoaching.net</span> <span style="color:black">> mapuche<o:p></o:p></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><o:p></o:p></pre>
<pre><span style="color:black">innecesariamente. ??Cuide el medio ambiente!</span> <span style="color:black">> --------------</span><o:p></o:p></pre>
<pre><span style="color:black">next part --------------</span> <span style="color:black">><o:p></o:p></span></pre>
<pre><span style="color:black">An HTML attachment was</span><o:p></o:p></pre>
<pre><span style="color:black">scrubbed...</span> <span style="color:black">> URL:<o:p></o:p></span></pre>
<pre><span style="color:black">http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20140124/d70439b8/attachment-0001.html></span><o:p></o:p></pre>
<pre><span style="color:black">></span> <span style="color:black">></span><o:p></o:p></pre>
<pre><span style="color:black">------------------------------</span> <span style="color:black">></span> <span style="color:black">><o:p></o:p></span></pre>
<pre><span style="color:black">_______________________________________________</span> <span style="color:black">> CWB<o:p></o:p></span></pre>
<pre><span style="color:black">mailing list</span> <span style="color:black">> <a href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it" target="_blank" title="Este enlace externo se abrirá en
una nueva ventana">CWB@sslmit.unibo.it</a></span><o:p></o:p></pre>
<pre><span style="color:black">> <a href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank" title="Este enlace externo se abrirá en una nueva
ventana">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></span><o:p></o:p></pre>
<pre><span style="color:black">></span> <span style="color:black">></span> <span style="color:black">></span><o:p></o:p></pre>
<pre><span style="color:black">End of CWB Digest, Vol 84, Issue 20</span> <span style="color:black">></span><o:p></o:p></pre>
<pre><span style="color:black">***********************************</span> <o:p></o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>CWB mailing list <a href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it" target="_blank" title="Este enlace externo se abrirá en una nueva ventana">CWB@sslmit.unibo.it</a><o:p></o:p></pre>
<pre><a href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank" title="Este enlace externo se abrirá en una nueva ventana">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a><o:p></o:p></pre>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
<br>
<br>
<br>
_______________________<br>
andrés chandía<br>
<a href="http://www.chandia.net" target="_blank" title="Este enlace externo se abrirá en una nueva
ventana"><span style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none">[IMAGE REMOVED]</span></a><br>
administrador de<br>
<a href="http://parles.upf.edu" target="_blank" title="Este enlace externo se
abrirá en una nueva ventana">parles.upf.edu</a><br>
<a href="http://psicoaching.net" target="_blank" title="Este enlace externo se abrirá
en una nueva ventana">psicoaching.net</a><br>
<a href="http://koyaktumapuche.net" target="_blank" title="Este enlace externo se abrirá en una nueva ventana">mapuche koyaktu</a><br>
<a href="http://corporacionkoyaktu.net" target="_blank" title="Este enlace externo se
abrirá en una nueva ventana">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><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><br>
<br>
<br>
_______________________<br>
andrés chandía<br>
<a href="http://www.chandia.net" target="_blank"><span style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none"><img border="0" width="100" height="100" id="_x0000_i1025" src="cid:~WRD383.jpg" alt="Image removed by sender. chandia.net"></span></a><a href="https://twitter.com/andreschandia" target="_blank"><span style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none"><img border="0" width="100" height="100" id="_x0000_i1026" src="cid:~WRD383.jpg" alt="Image removed by sender."></span></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: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><o:p></o:p></p>
</div>
</body>
</html>