<!-- begin sanitized html --> Ok, <br />PHP 5.6.24-0+deb8u1 (cli) (built: Jul 26 2016
08:17:07) <br />Copyright (c) 1997-2016 The PHP Group<br />Zend Engine v2.6.0, Copyright (c)
1998-2016 Zend Technologies<br /> with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by
Zend Technologies<br /><br />now I have CQPweb v3.2.23<br /><br />but I get this error when
installing the corpus:<br /><br /> Original query: update corpus_info set size_bytes_index
= 0 where id = 108 /* from User: admin | Function: do_append_mysql_comment() | 2016-Oct-12
17:04:09 */
<p> </p>
Error # 1054: Unknown column 'size_bytes_index' in 'field list'
<p> </p>
<br /><br />On Wed, October 12, 2016 18:50, Hardie, Andrew wrote:<br /> <span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">That
error message is an encryption bug – not the same as what is causing the
metadata error. However, it’s interesting. Can you tell me, what version of
PHP</span><br />
<div class="bodyclass">
<div class="WordSection1"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"></span>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
are you running?</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">On
the metadata issue: Consider upgrading all the way. Even 3.2.11 is pretty old now. I suspect
some of these bugs will vanish.</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
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US">From:</span></strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">
cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]<br /> <strong>On Behalf Of
</strong>"Andrés Chandía"<br /> <strong>Sent:</strong> 12
October 2016 17:44<br /> <strong>To:</strong> Open source development of the Corpus
WorkBench<br /> <strong>Subject:</strong> Re: [CWB] Some problems installing a new corpus at
cqpweb</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Ok, cleaning that table allowed me to install the corpus again, but when
I click on the "Design and insert a text-metadata table for the corpus" link, it
sends me to a non found page.<br /> At the apache error log I get a good amount of this
line:<br /> <br /> Undefined offset: 0 in .../cqp/lib/user-lib.inc.php on line 628, referer:
<a href="http://parles.upf.edu/llocs/cqp/adm/index.php?thisF=installCorpusIndexed&uT=y"
title="This external link will open in a new window" target="_blank"><br />
http://parles.upf.edu/llocs/cqp/adm/index.php?thisF=installCorpusIndexed&uT=y</a><br />
<br /> <br /> <br /> <br /> On Wed, October 12, 2016 17:46, Hardie, Andrew wrote: </p>
<div><br />
<div><br />
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Ah,
looks like you need to manually clean annotation_metadata too.</span><br /> </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">Sorry
– the corpus delete function was v buggy
in the low-numbered 3.2 versions.</span></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></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US">From:</span></strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US"><br /> <a href="mailto:cwb-bounces@sslmit.unibo.it" title="This external link
will open in a new window" target="_blank">cwb-bounces@sslmit.unibo.it</a> [<a
href="mailto:cwb-bounces@sslmit.unibo.it" title="This external link will open in a new window"
target="_blank">mailto:cwb-bounces@sslmit.unibo.it</a>]<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">On Behalf Of
</span></strong>"Andrés
Chandía"<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 12 October
2016 16:44<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] Some problems installing a new corpus at cqpweb</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I updated to
CQPweb v3.2.11<br /> I manually cleaned xml_metadata, xml_metadata_values and corpus_info but
still I get this error<br /> <br /> Original query: insert into annotation_metadata (corpus,
handle, description, tagset, external_url, is_feature_set) values ('corpglicom', 'lema', '',
'', '', is_feature_set) /* from User: admin | Function: install_new_corpus() | 2016-Oct-12
15:40:45 */</p>
<p class="errormessage">Error # 1062: Duplicate entry 'corpglicom-lema' for key 'PRIMARY'</p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt">On Tue, October 11,
2016 20:40, Hardie, Andrew wrote:</p>
<div><br />
<p class="MsoNormal"> </p>
<div><br />
<p class="MsoNormal"> </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">The
duplicate key entries that are failing to be deleted are in the xml_metadata and/or
xml_metadata_values<br /> tables.</span></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">This
suggests that the problem is that your corpus deletion process is aborting before it gets
to<br /> the point of deleting those keys.</span></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">You
should check your http error log after such a deletion to check whether there is a report
of<br /> what the problem is.</span></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">You
should, likewise, check your http error log after trying and failing to install metadata. A
blank<br /> screen will usually lead to an entry there that will be<br /> at least a little
informative.</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Re
>><br /> </span>Yet another issue, if I delete from the interface the corpus I installed
using an uploaded file, then the whole data dir get deleted, fortunately I have a
backup...</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
donâ€ââ€Â¢t
get what the problem is,
isnâ€ââ€Â¢t
this the expected behaviour? Perhaps
Iâ€ââ€Â¢m<br
/> not following<br /> what you mean by
“using
an uploaded
fileâ€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"></span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">…</span></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></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></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US">From:</span></strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US"><br /> "Andrés
Chandía" [<a
href="mailto:andres@chandia.net" title="This external link will open in a new window"
target="_blank">mailto:andres@chandia.net</a>]<br /> <br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 11 October
2016 19:32<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">To:</span></strong> Hardie,
Andrew<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Cc:</span></strong> Open source
development of the Corpus WorkBench<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Subject:</span></strong> Some
problems installing a new corpus at cqpweb</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi there, I
have some problems installing a preindexed corpus in cqpweb interface<br /> 1.when clicking
the button to set metadata, it only shows a blank oage, either using a given table or
installing a minimalist set<br /> 2.I delete the corpus to try again<br /> 3, On second try I
get this error:<br /> Error # 1062: Duplicate entry 'corpglicom-p' for key 'corpus' <br />
eventhough I have deleted the previous installation and reindexed the corpus with cwb.<br />
4. moving the corpus to the uploaded file and deleting previous installation does not help, I
get same error:<br /> Error # 1062: Duplicate entry 'corpglicom-text' for key 'corpus' <br />
<br /> The only way to start over is changing corpus name, but I have again the same
problems...<br /> Any suggestion?<br /> <br /> Thanks<br /> <br /> _______________________<br
/> andrés
chandía<br /> <a
href="http://www.chandia.net" title="This external link will open in a new window"
target="_blank"><span style="text-decoration:none"><img id="_x0000_i1025"
src="../images/spacer.png" alt="chandia.net" border="0" /></span></a><a
href="https://twitter.com/andreschandia" title="This external link will open in a new window"
target="_blank"><span style="text-decoration:none"><img id="_x0000_i1026"
src="../images/spacer.png" alt="" border="0" /></span></a><br /> <a
href="http://chandia.net/content/nmt" title="This external link will open in a new window"
target="_blank">NMT</a> |<br /> <a href="http://chandia.net/content/dungupeyem" title="This
external link will open in a new window" target="_blank"><br /> Dungupeyem</a> | <a
href="http://chandia.net/corlexim" title="This external link will open in a new window"
target="_blank"><br /> <br /> <br /> Corlexim</a><br /> <br /> administrador de:<br /> <a
href="http://parles.upf.edu" title="This external link will open in a new window"
target="_blank">Parles.upf</a> |<br /> <a href="http://www.delingua.es" title="This external
link will open in a new window" target="_blank"><br /> <br /> Delingua</a> | <a
href="http://amindterapia.com" title="This external link will open in a new window"
target="_blank"><br /> <br /> Amind terapia</a> | <a href="http://koyaktumapuche.net"
title="This external link will open in a new window" target="_blank"><br /> <br /> <br />
Mapuche koyaktu</a> | <a href="http://parles.upf.edu/llocs/nocando" title="This external link
will open in a new window" target="_blank"><br /> <br /> Nocando</a> |<br /> mail: <a
href="http://mail.corporacionkoyaktu.net" title="This external link will open in a new window"
target="_blank"><br /> <br /> ONG Mapuche koyaktu</a> | <a href="http://mail.psicoaching.net"
title="This external link will open in a new window" target="_blank"><br /> <br /> <br />
Psicoaching</a> |<br /> <span style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P
</span><span style="font-size:10.0pt">No imprima innecesariamente.
¡Cuide el medio
ambiente!</span></p>
</div>
<br />
<p class="MsoNormal"> </p>
</div>
<br />
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br /> <br />
<br /> <br /> <br /> _______________________<br /> andrés
chandía<br /> <a href="http://www.chandia.net" title="This external
link will open in a new window" target="_blank"><span style="text-decoration:none"><img
id="_x0000_i1027" src="../images/spacer.png" alt="chandia.net" border="0" /></span></a><a
href="https://twitter.com/andreschandia" title="This external link will open in a new window"
target="_blank"><span style="text-decoration:none"><img id="_x0000_i1028"
src="../images/spacer.png" alt="" border="0" /></span></a><br /> <a
href="http://chandia.net/content/nmt" title="This external link will open in a new window"
target="_blank">NMT</a> |<br /> <a href="http://chandia.net/content/dungupeyem" title="This
external link will open in a new window" target="_blank"><br /> Dungupeyem</a> | <a
href="http://chandia.net/corlexim" title="This external link will open in a new window"
target="_blank"><br /> <br /> Corlexim</a><br /> <br /> administrador de:<br /> <a
href="http://parles.upf.edu" title="This external link will open in a new window"
target="_blank">Parles.upf</a> |<br /> <a href="http://www.delingua.es" title="This external
link will open in a new window" target="_blank"><br /> <br /> Delingua</a> | <a
href="http://amindterapia.com" title="This external link will open in a new window"
target="_blank"><br /> Amind terapia</a> | <a href="http://koyaktumapuche.net" title="This
external link will open in a new window" target="_blank"><br /> <br /> Mapuche koyaktu</a> |
<a href="http://parles.upf.edu/llocs/nocando" title="This external link will open in a new
window" target="_blank"><br /> Nocando</a> |<br /> mail: <a
href="http://mail.corporacionkoyaktu.net" title="This external link will open in a new window"
target="_blank"><br /> ONG Mapuche koyaktu</a> | <a href="http://mail.psicoaching.net"
title="This external link will open in a new window" target="_blank"><br /> <br />
Psicoaching</a> |<br /> <span style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P
</span><span style="font-size:10.0pt">No imprima innecesariamente.
¡Cuide el medio ambiente!</span></p>
</div>
<br />
<p class="MsoNormal"> </p>
</div>
<br />
<p class="MsoNormal"><br /> <br /> <br /> <br /> <br /> _______________________<br />
andrés chandía<br /> <a href="http://www.chandia.net" title="This
external link will open in a new window" target="_blank"><span
style="text-decoration:none"><img id="_x0000_i1029" src="../images/spacer.png"
alt="chandia.net" border="0" /></span></a><a href="https://twitter.com/andreschandia"
title="This external link will open in a new window" target="_blank"><span
style="text-decoration:none"><img id="_x0000_i1030" src="../images/spacer.png" alt=""
border="0" /></span></a><br /> <a href="http://chandia.net/content/nmt" title="This external
link will open in a new window" target="_blank">NMT</a> |<br /> <a
href="http://chandia.net/content/dungupeyem" title="This external link will open in a new
window" target="_blank"><br /> Dungupeyem</a> | <a href="http://chandia.net/corlexim"
title="This external link will open in a new window" target="_blank"><br /> Corlexim</a><br />
<br /> administrador de:<br /> <a href="http://parles.upf.edu" title="This external link will
open in a new window" target="_blank">Parles.upf</a> | <a href="http://www.delingua.es"
title="This external link will open in a new window" target="_blank"><br /> Delingua</a> | <a
href="http://amindterapia.com" title="This external link will open in a new window"
target="_blank">Amind terapia</a> | <a href="http://koyaktumapuche.net" title="This external
link will open in a new window" target="_blank"><br /> Mapuche koyaktu</a> | <a
href="http://parles.upf.edu/llocs/nocando" title="This external link will open in a new
window" target="_blank">Nocando</a> |<br /> mail: <a href="http://mail.corporacionkoyaktu.net"
title="This external link will open in a new window" target="_blank">ONG Mapuche koyaktu</a> |
<a href="http://mail.psicoaching.net" title="This external link will open in a new window"
target="_blank"><br /> Psicoaching</a> |<br /> <span
style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P </span><span
style="font-size:10.0pt">No imprima innecesariamente. ¡Cuide el medio
ambiente!</span></p>
</div>
<br /> </div>
<br /> <br /> <br /><br /><br />_______________________<br /> andrés
chandía<br /><a href="http://www.chandia.net" target="_blank" title="This external link
will open in a new window"><img src="../images/spacer.png" alt="chandia.net" border="0"
/></a><a href="https://twitter.com/andreschandia" target="_blank" title="This external link
will open in a new window"><img src="../images/spacer.png" alt="" /></a><br /><a
href="http://chandia.net/content/nmt" title="This external link will open in a new window"
target="_blank">NMT</a> | <a href="http://chandia.net/content/dungupeyem" title="This external
link will open in a new window" target="_blank">Dungupeyem</a> | <a
href="http://chandia.net/corlexim" title="This external link will open in a new window"
target="_blank">Corlexim</a><br /><br />administrador de:<br /><a href="http://parles.upf.edu"
target="_blank" title="This external link will open in a new window">Parles.upf</a> | <a
href="http://www.delingua.es" target="_blank" title="This external link will open in a new
window">Delingua</a> | <a href="http://amindterapia.com" target="_blank" title="This external
link will open in a new window">Amind terapia</a> | <a href="http://koyaktumapuche.net"
target="_blank" title="This external link will open in a new window">Mapuche koyaktu</a> | <a
href="http://parles.upf.edu/llocs/nocando" target="_blank" title="This external link will open
in a new window">Nocando</a> |<br />mail: <a href="http://mail.corporacionkoyaktu.net"
target="_blank" title="This external link will open in a new window">ONG Mapuche koyaktu</a> |
<a href="http://mail.psicoaching.net" target="_blank" title="This external link will open in a
new window">Psicoaching</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> <!-- end sanitized html -->