No I haven't because I have done it from 3.2.1 to 3.2.11 but after taht version in the manual of 3.2.23 says nothing about running the upgrade-database.php<br />Now I have done it, and all seems to go smoothly<br /><br /><br />On Wed, October 12, 2016 19:08, Hardie, Andrew wrote:<br /> <!-- begin sanitized html --><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Did you run upgrade-database.php ?</span>
<div class="bodyclass">
<div class="WordSection1">
<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 18:07<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, <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 */<br /> </p>
<p> </p>
<p class="MsoNormal">Error # 1054: Unknown column 'size_bytes_index' in 'field list'<br /> </p>
<p> </p>
<p class="MsoNormal"><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></p>
<div><br />
<div><br />
<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">are you running?</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">On the metadata issue: Consider upgrading all the way. Even 3.2.11 is pretty old now. I suspect some<br /> of these bugs will vanish.</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 /> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank" title="This external link will open in a new window">cwb-bounces@sslmit.unibo.it</a> [<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank" title="This external link will open in a new window">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 17: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">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<br /> 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 /> <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 />
<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">Ah, looks like you need to manually clean annotation_metadata too.</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">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?<br /> 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" border="0" alt="" /></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 /> <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 /> <br /> Amind terapia</a> | <a href="http://koyaktumapuche.net" title="This external link will open in a new window" target="_blank"><br /> <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 /> <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 /> <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 /> <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" border="0" alt="" /></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_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" border="0" alt="" /></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_i1031" 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_i1032" src="../images/spacer.png" border="0" alt="" /></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> |<br /> <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"><br /> 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"><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 /> Psicoaching</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><br /> </p>
</div>
<br /> </div>
<br /> <br /> <!-- end sanitized html --> <br /><br /><br />_______________________<br /> andrés chandía<br /><a href="http://www.chandia.net" target="_blank"><img src="http://www.chandia.net/sites/default/files/images/chandia.netd.png" alt="chandia.net" border="0" /></a><a href="https://twitter.com/andreschandia" target="_blank"><img src="http://www.upf.edu/universitat/_img/ico_tw.png" alt="" /></a><br /><a href="http://chandia.net/content/nmt" title="Unificador ortogràfico de mapudungun">NMT</a> | <a href="http://chandia.net/content/dungupeyem" title="Analizador y generador mofológico de mapudungun">Dungupeyem</a> | <a href="http://chandia.net/corlexim" title="Corpus lexicográfico de mapudungun">Corlexim</a><br /><br />administrador de:<br /><a href="http://parles.upf.edu">Parles.upf</a> | <a href="http://www.delingua.es">Delingua</a> | <a href="http://amindterapia.com">Amind terapia</a> | <a href="http://koyaktumapuche.net">Mapuche koyaktu</a> | <a href="http://parles.upf.edu/llocs/nocando">Nocando</a> |<br />mail: <a href="http://mail.corporacionkoyaktu.net">ONG Mapuche koyaktu</a> | <a href="http://mail.psicoaching.net">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>