On the new version (v3.1.9) of cqp I've found the next behaviour, which I don't know if it's
normal or it is a misconfiguration I've done or it is a bug.<br />When logging in to the
interface with any user, either old or a brand new one, it requires a second authentication in
the form of a httpass dialog, if the user is not included in the httpass and httgroup files,
then can not browse or query the corpus that cqp is showing to this very same user as
accessible<br /><br /><br />El Sab, 19 de Julio de 2014, 17:17, Hardie, Andrew
escribió:<br /> <!-- begin sanitized html --> <style type="text/css">-></style>
<div class="bodyclass">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">The
table entry represents an ongoing process (probably one that has crashed). Since you have
upgraded your code, you know no user is currently running a process (because they
can’t). So it is safe to do the following:</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">delete
from mysql_processes;</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 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"">
Andres Chandia [mailto:andres@chandia.net] <br /> <strong>Sent:</strong> 19 July 2014 16:13<br
/> <strong>To:</strong> Hardie, Andrew<br /> <strong>Cc:</strong> Open source development of
the Corpus WorkBench<br /> <strong>Subject:</strong> RE: [CWB] updating cqp web from v3.0.16
to v3.1.9</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Ok, now it tells me:<br /> <br /> A mySQL query did not run
successfully!<br /> <br /> Original query: <br /> <br /> alter table mysql_processes add
primary key (`dbname`)<br /> <br /> <br /> Error # 1062: Duplicate entry 'db_dist_ehkrjl4cltR'
for key 'PRIMARY' <br /> <br /> PHP Notice: Undefined property:
stdClass::$all_users_see_backtrace in /srv/web/llocs/cqp/lib/exiterror.inc.php on line 113<br
/> <br /> <br /> do I delete the duplicate entry manually?<br /> <br /> <br /> On Sat, July
19, 2014 17:09, Hardie, Andrew wrote:</p>
<div>
<div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">The
binary scripts need to be run a subdirectory of the root directory. </span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">IE
cd bin first. Then run it.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">This
is covered in the manual, I think.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><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"">
Andres Chandia [<a title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="mailto:andres@chandia.net">mailto:andres@chandia.net</a>] <br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 19 July
2014 16:07<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> RE:
[CWB] updating cqp web from v3.0.16 to v3.1.9</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal">I'm trying but
it tells me:<br /> <br /> php bin/upgrade-database.php <br /> PHP Warning:
require(../lib/environment.inc.php): failed to open stream: No such file or directory in
/srv/web/llocs/cqp/bin/upgrade-database.php on line 38<br /> PHP Fatal error: require():
Failed opening required '../lib/environment.inc.php'
(include_path='.:/usr/share/php:/usr/share/pear') in
/srv/web/llocs/cqp/bin/upgrade-database.php on line 38<br /> <br /> <br /> On Sat, July 19,
2014 17:03, Hardie, Andrew wrote:</p>
<div>
<div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Have
you run the upgrade database script?</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><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"">
<a title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [<a title="Este
enlace externo se abrirá en una nueva ventana" target="_blank"
href="mailto:cwb-bounces@sslmit.unibo.it">mailto:cwb-bounces@sslmit.unibo.it</a>]
<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> 19 July
2014 15:56<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> [CWB]
updating cqp web from v3.0.16 to v3.1.9</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal">Hi there, I'm
getting this error when trying to acces the updated version: <br /> <br /> A mySQL query did
not run successfully!<br /> Error # 1146: Table 'cqp.corpus_info' doesn't exist <br /> <br />
I guess I have to create this table, but I can not find the current script to do it, can you
refer me to that file and if any other too....<br /> <br /> thanks a lot<br /> <br />
_______________________<br /> andrés chandía<br /> <a target="_blank"
title="Este enlace externo se abrirá en una nueva ventana" href="http://www.chandia.net"><span
style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none">[IMAGE
REMOVED]</span></a><br /> administrador de<br /> <a target="_blank" title="Este enlace externo
se abrirá en una nueva ventana" href="http://parles.upf.edu">parles.upf.edu</a><br /> <a
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
href="http://psicoaching.net">psicoaching.net</a><br /> <a target="_blank" title="Este enlace
externo se abrirá en una nueva ventana" href="http://koyaktumapuche.net">mapuche
koyaktu</a><br /> <a target="_blank" title="Este enlace externo se abrirá en una nueva
ventana" 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></p>
</div>
</div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><br /> <br />
<br /> _______________________<br /> andrés chandía<br /> <a target="_blank"
title="Este enlace externo se abrirá en una nueva ventana" href="http://www.chandia.net"><span
style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none">[IMAGE
REMOVED]</span></a><br /> administrador de<br /> <a target="_blank" title="Este enlace externo
se abrirá en una nueva ventana" href="http://parles.upf.edu">parles.upf.edu</a><br /> <a
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
href="http://psicoaching.net">psicoaching.net</a><br /> <a target="_blank" title="Este enlace
externo se abrirá en una nueva ventana" href="http://koyaktumapuche.net">mapuche
koyaktu</a><br /> <a target="_blank" title="Este enlace externo se abrirá en una nueva
ventana" 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></p>
</div>
</div>
<p class="MsoNormal"><br /> <br /> <br /> _______________________<br />
andrés chandía<br /> <a title="Este enlace externo se abrirá en una nueva
ventana" target="_blank" href="http://www.chandia.net"><span style="text-decoration:none"><img
border="0" alt="chandia.net" src="../images/sec_remove_es_ES.png" id="_x0000_i1025"
/></span></a><a title="Este enlace externo se abrirá en una nueva ventana" target="_blank"
href="https://twitter.com/andreschandia"><span style="text-decoration:none"><img border="0"
src="../images/sec_remove_es_ES.png" id="_x0000_i1026" alt="" /></span></a><br />
administrador de<br /> <a title="Este enlace externo se abrirá en una nueva ventana"
target="_blank" href="http://parles.upf.edu">parles.upf.edu</a><br /> <a title="Este enlace
externo se abrirá en una nueva ventana" target="_blank"
href="http://psicoaching.net">psicoaching.net</a><br /> <a title="Este enlace externo se
abrirá en una nueva ventana" target="_blank" href="http://koyaktumapuche.net">mapuche
koyaktu</a><br /> <a title="Este enlace externo se abrirá en una nueva ventana"
target="_blank" 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></p>
</div>
</div>
<!-- end sanitized html --> <br /><br /><br />_______________________<br
/> andrés
chandía<br /><a target="_blank" href="http://www.chandia.net"><img border="0"
alt="chandia.net" src="http://www.chandia.net/sites/default/files/images/chandia.netd.png"
/></a><a target="_blank" href="https://twitter.com/andreschandia"><img
src="http://www.upf.edu/universitat/_img/ico_tw.png" alt="" /></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:
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>