<div>Hi there,</div>
<div><br /></div>
<div>At a cqpweb installation (CQPweb v3.2.27)</div>
<div><br /></div>
<div>There is a corpus that I've been told it was working correctly, but all of a sudden
queries started to give back [UNREADABLE]</div>
<div><br /></div>
<div>Like:</div>
<div><br /></div>
<div> [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE]
[UNREADABLE] [UNREADABLE] [UNREADABLE]<strong><a class="nodelink"
href="http://corptedig-glif.upf.edu/cqpweb/coca/context.php?batch=0&qname=h1feli3mdi&uT=y">[UNREADABLE]
</a> <a class="nodelink"
href="http://corptedig-glif.upf.edu/cqpweb/coca/context.php?batch=0&qname=h1feli3mdi&uT=y">[UNREADABLE]</a></strong>
[UNREADABLE]
[UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE]
[UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] <br /></div>
<div><br /></div>
<div> So, my question is where and how should I start to try to find out the cause of this
problem?</div>
<div><br /></div>
<div>Things I've done/notice:</div>
<div><br /></div>
<div>If I click on the linked results and the switch to the alternative view (pos), I get:</div>
<div><br /></div>
<div>i ge mc fo ) rr , rr21 rr22 , pn1 vvd np1 np1 , cc np1
np1 vvd ii21 ii22 nn1 ii21 ii22 nnt1 cs pphs1 vdd xx vvi to vbi
rl to vvi ppge@_appge - appge nn1 vvg dd1 nn1 . <br /> <br /> rr
pph1 vbdz xx rr at1 nn1 nnt1 . <br /> <br /> ccb md - md_nnt1
nn2 vh0 vbn - vh0 vbn jj . <br /> <br /> cs ppis1 vbdr np1 ,
ppis1 vm xx vbi vvg_jj@ nn1 ii dd1 io dd2 nn2 . <br /> </div>
<div><br /></div>
<div>If I go to the Admin Control Panel I see:</div>
<div><br /></div>
<div> Corpus: coca | Indexing date: 2019-04-11 15:29:37 | Size Tokens: 0 | Types: 1,274,893 |
Texts: 0 | Disk space Indexes: 0.0 MB | Freq tables: 57.4 MB</div>
<div><br /></div>
<div>Frequency list search show results correctly: <br /></div>
<div> <strong>1 <a
href="http://corptedig-glif.upf.edu/cqpweb/coca/concordance.php?theData=%5Bword%3D%22king%22%25c%5D&qmode=cqp&uT=y">king</a></strong>
11,825 </div>
<div><br /></div>
<div>and all derived from king...</div>
<div><br /></div>
<div>A word lookup will fail giving this output: A MySQL query did not run successfully!</div>
<div>
<p>Original query: select count(concat(node,'_',tagnode)) as tokens,
count(distinct(concat(node,'_',tagnode))) as types from db_sort_h1fel9jyg4 /* from
User: admin | Function: require() | 2022-Apr-20 13:37:27 */ </p>
<p>Error # 1054: Unknown column 'tagnode' in 'field list' </p>
</div>
<div> </div>
Generate CWB text-position records outputs: A MySQL query did not run successfully!<br />
Original query: insert into `___temp_cqp_text_positions_for_coca` (text_id, cqp_begin,
cqp_end) VALUES ('4122770', 0, 5307), .... etc. a lot of numbers...<br /> Error # 1062:
Duplicate entry '4166449' for key 'PRIMARY'
<div><br /></div>
<div>Update Word and file counts outputs "the connections has expired", on retrying
page keeps loading until is done<br /></div>
<div><br /></div>
<div>Recreate CWB Frequency table outputs: "the connections has expired" on retrying
I get: CQPweb could not create a directory for the frequency index. Check filesystem
permissions!</div>
<div><br /></div>
<div>I've checked the directories and all of them are owned by www-data<br /></div>
<div><br /></div>
<div><br /></div>
<div>Recreate Frequency tables outpus: "the connections has expired" on retry
finally outpus;</div>
<div><br /></div>
<div>
<p>A MySQL query did not run successfully!</p>
<p>Original query: CREATE TABLE __tempfreq_coca ( freq int(11) unsigned default NULL,
word varchar(255) NOT NULL, lemma varchar(255) NOT NULL, pos varchar(255) NOT NULL,
key (word), key (lemma), key (pos) ) CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: admin | Function: corpus_make_freqtables() | 2022-Apr-20 13:53:57 */ </p>
<p>Error # 1050: Table '__tempfreq_coca' already exists </p>
</div>
<div><br /></div>
<div>I will appreciate any guidance, thanks a lot!!</div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
_______________________<br />
andrés
chandía<br /><a href="http://www.chandia.net" target="_blank"><img
src="http://mail.chandia.net/images/chandia_net.png" alt="chandia.net" border="0" /></a> <a
href="https://twitter.com/chandianet" target="_blank"><img
src="http://mail.chandia.net/images/ico_tw.png" alt="" width="20" height="20" /></a><br /><a
href="http://chandia.net/dungupeyem" title="Analizador y generador mofológico de
mapudüngun">Düngupeyem</a> | <a href="http://chandia.net/iecmap" title="Interfaz de
explotación de corpus del mapudüngun">IECMap</a> | <a href="http://chandia.net/isecmap"
title="Interfaz sencilla de explotación de corpus del mapudüngun">ISECMap</a> | <a
href="http://chandia.net/nmt-norwirin-mapudungun-trapumwe" title="Unificador ortográfico de
mapudüngun">NMT</a> | <a href="http://corlexim.cl" title="Corpus lexicográfico de
mapudüngun">Corlexim</a><br /><br />Desarrollador de:<br /><a
href="https://parles.upf.edu">Parles.upf</a> | <a href="https://iwch.upf.edu"
title="Interfície Web de Consulta d'Horaris UCA TCL UPF">IWCH</a> | <a
href="http://amindterapia.com">Amind terapia</a> | <a
href="https://parles.upf.edu/llocs/nocando">Nocando</a> | <a
href="https://iac.upf.edu">IAC</a> | <a href="https://iac.upf.edu/cddz">CddZ</a> | <a
href="https://iac.upf.edu/isac">ISAC</a> | <a href="http://catcg.upf.edu">CatCg</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>