[CWB] Some problems installing a new corpus at cqpweb

Hardie, Andrew a.hardie at lancaster.ac.uk
Wed Oct 12 19:08:05 CEST 2016


Did you run upgrade-database.php ?

best

Andrew

From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of "Andrés Chandía"
Sent: 12 October 2016 18:07
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] Some problems installing a new corpus at cqpweb

Ok,
PHP 5.6.24-0+deb8u1 (cli) (built: Jul 26 2016 08:17:07)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies

now I have CQPweb v3.2.23

but I get this error when installing the corpus:

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 */


Error # 1054: Unknown column 'size_bytes_index' in 'field list'




On Wed, October 12, 2016 18:50, Hardie, Andrew wrote:
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
are you running?
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.
best
Andrew.
From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> [mailto:cwb-bounces at sslmit.unibo.it]
On Behalf Of "Andrés Chandía"
Sent: 12 October 2016 17:44
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] Some problems installing a new corpus at cqpweb
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.
At the apache error log I get a good amount of this line:

Undefined offset: 0 in .../cqp/lib/user-lib.inc.php on line 628, referer:
http://parles.upf.edu/llocs/cqp/adm/index.php?thisF=installCorpusIndexed&uT=y




On Wed, October 12, 2016 17:46, Hardie, Andrew wrote:


Ah, looks like you need to manually clean annotation_metadata too.
Sorry – the corpus delete function was v buggy in the low-numbered 3.2 versions.
Andrew.
From:
cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> [mailto:cwb-bounces at sslmit.unibo.it]
On Behalf Of "Andrés Chandía"
Sent: 12 October 2016 16:44
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] Some problems installing a new corpus at cqpweb
I updated to CQPweb v3.2.11
I manually cleaned xml_metadata, xml_metadata_values and corpus_info but still I get this error

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 */

Error # 1062: Duplicate entry 'corpglicom-lema' for key 'PRIMARY'
On Tue, October 11, 2016 20:40, Hardie, Andrew wrote:


The duplicate key entries that are failing to be deleted are in the xml_metadata and/or xml_metadata_values
tables.
This suggests that the problem is that your corpus deletion process is aborting before it gets to
the point of deleting those keys.
You should check your http error log after such a deletion to check whether there is a report of
what the problem is.
You should, likewise, check your http error log after trying and failing to install metadata. A blank
screen will usually lead to an entry there that will be
at least a little informative.
Re >>
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...
I don’t get what the problem is, isn’t this the expected behaviour? Perhaps I’m
not following
what you mean by “using an uploaded file”â€Â¦
best
Andrew.
From:
"Andrés Chandía" [mailto:andres at chandia.net]

Sent: 11 October 2016 19:32
To: Hardie, Andrew
Cc: Open source development of the Corpus WorkBench
Subject: Some problems installing a new corpus at cqpweb
Hi there, I have some problems installing a preindexed corpus in cqpweb interface
1.when clicking the button to set metadata, it only shows a blank oage, either using a given table or installing a minimalist set
2.I delete the corpus to try again
3, On second try I get this error:
Error # 1062: Duplicate entry 'corpglicom-p' for key 'corpus'
eventhough I have deleted the previous installation and reindexed the corpus with cwb.
4. moving the corpus to the uploaded file and deleting previous installation does not help, I get same error:
Error # 1062: Duplicate entry 'corpglicom-text' for key 'corpus'

The only way to start over is changing corpus name, but I have again the same problems...
Any suggestion?

Thanks

_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> |

Dungupeyem<http://chandia.net/content/dungupeyem> |


Corlexim<http://chandia.net/corlexim>

administrador de:
Parles.upf<http://parles.upf.edu> |


Delingua<http://www.delingua.es> |

Amind terapia<http://amindterapia.com> |


Mapuche koyaktu<http://koyaktumapuche.net> |

Nocando<http://parles.upf.edu/llocs/nocando> |
mail:

ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> |


Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!







_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> |

Dungupeyem<http://chandia.net/content/dungupeyem> |

Corlexim<http://chandia.net/corlexim>

administrador de:
Parles.upf<http://parles.upf.edu> |


Delingua<http://www.delingua.es> |
Amind terapia<http://amindterapia.com> |

Mapuche koyaktu<http://koyaktumapuche.net> |
Nocando<http://parles.upf.edu/llocs/nocando> |
mail:
ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> |

Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!







_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> |

Dungupeyem<http://chandia.net/content/dungupeyem> |
Corlexim<http://chandia.net/corlexim>

administrador de:
Parles.upf<http://parles.upf.edu> |
Delingua<http://www.delingua.es> | Amind terapia<http://amindterapia.com> |
Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> |
Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!






_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> | Dungupeyem<http://chandia.net/content/dungupeyem> | Corlexim<http://chandia.net/corlexim>

administrador de:
Parles.upf<http://parles.upf.edu> | Delingua<http://www.delingua.es> | Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> | Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20161012/1a19deb4/attachment-0001.html>


More information about the CWB mailing list