<div dir="ltr"><div class="gmail_default" style="color:#0b5394">About the mail I've just sent, I'm definitely wrong because queries are working with other corpus...</div><div class="gmail_default" style="color:#0b5394"><br clear="all"></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span style="color:rgb(0,0,255)"><i><span style="font-family:trebuchet ms,sans-serif">... Andrés Chandía</span></i></span><br></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Missatge de Andrés Chandía <<a href="mailto:andres.chandia@upf.edu">andres.chandia@upf.edu</a>> del dia dj., 20 d’abr. 2023 a les 18:14:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="color:rgb(11,83,148)">Hi Andrew, error seems to be generated on the sql query:</div><div class="gmail_default" style="color:rgb(11,83,148)"><br></div><div class="gmail_default" style="color:rgb(11,83,148)"><pre>About to run SQL:
SELECT * from saved_queries
where corpus = 'bnc'
and query_mode = 'sq_nocase'
and cqp_query = '[word=\"word\"%c]'
and query_scope = ''
and postprocess = ''
and saved = 0
limit 1
/* from User: admin | Function: load_from_params() | 2023-Apr-20 18:01 */</pre></div><div class="gmail_default" style="color:rgb(11,83,148)"><br></div><div class="gmail_default" style="color:rgb(11,83,148)">cqp_query goes '[word=\"word\"%c]' where the characters <b>%c</b> are added generating the error (at least that seems to me) so, if this is the cause of the error, any idea on how to clean that or fix it,</div><div class="gmail_default" style="color:rgb(11,83,148)">I see that %c characters in many files, so there is probably a typo in one of those files, which one? how could I get the file generating the problem?</div><div class="gmail_default" style="color:rgb(11,83,148)">Again, I'm probably wrong... so I better add the complete php debugging...</div><div class="gmail_default" style="color:rgb(11,83,148)"><br></div><div class="gmail_default" style="color:rgb(11,83,148)"><pre>array(6) {
[1]=>
array(4) {
["file"]=>
string(55) "/mnt/vmdata/corptedig-glif/cqpweb/lib/exiterror-lib.php"
["line"]=>
int(380)
["function"]=>
string(9) "exiterror"
["args"]=>
array(1) {
[0]=>
array(7) {
[0]=>
string(69) "CQP reports an error! The CQP program sent back these error messages:"
[1]=>
string(19) "**** CQP ERROR ****"
[2]=>
string(10) "CQP Error:"
[3]=>
string(60) "CQP Syntax Error: syntax error, unexpected ';', expecting ID"
[4]=>
string(18) "show +word + ; <--"
[5]=>
string(43) "Ignoring subsequent input until next ';'..."
[6]=>
string(11) "PARSE ERROR"
}
}
}
[2]=>
array(4) {
["file"]=>
string(45) "/mnt/vmdata/corptedig-glif/cqpweb/lib/cqp.php"
["line"]=>
int(1798)
["function"]=>
string(13) "exiterror_cqp"
["args"]=>
array(1) {
[0]=>
array(6) {
[0]=>
string(19) "**** CQP ERROR ****"
[1]=>
string(10) "CQP Error:"
[2]=>
string(60) "CQP Syntax Error: syntax error, unexpected ';', expecting ID"
[3]=>
string(18) "show +word + ; <--"
[4]=>
string(43) "Ignoring subsequent input until next ';'..."
[5]=>
string(11) "PARSE ERROR"
}
}
}
[3]=>
array(7) {
["file"]=>
string(45) "/mnt/vmdata/corptedig-glif/cqpweb/lib/cqp.php"
["line"]=>
int(1850)
["function"]=>
string(11) "shout_error"
["class"]=>
string(3) "CQP"
["object"]=>
object(CQP)#84 (21) {
["has_been_disconnected":"CQP":private]=>
bool(false)
["process":"CQP":private]=>
resource(5) of type (process)
["pipe":"CQP":private]=>
array(3) {
[0]=>
resource(2) of type (stream)
[1]=>
resource(3) of type (stream)
[2]=>
resource(4) of type (stream)
}
["last_registry_invoked":"CQP":private]=>
string(48) "/mnt/vmdata/corptedig-glif/corpora/cqp/registry/"
["major_version"]=>
int(3)
["minor_version"]=>
int(5)
["revision_version"]=>
int(0)
["revision_version_flagged_beta":"CQP":private]=>
bool(false)
["compile_date"]=>
NULL
["version_string"]=>
string(17) "CQP version 3.5.0"
["status":"CQP":private]=>
int(1)
["error_handler":"CQP":private]=>
string(13) "exiterror_cqp"
["error_message":"CQP":private]=>
array(6) {
[0]=>
string(19) "**** CQP ERROR ****"
[1]=>
string(10) "CQP Error:"
[2]=>
string(60) "CQP Syntax Error: syntax error, unexpected ';', expecting ID"
[3]=>
string(18) "show +word + ; <--"
[4]=>
string(43) "Ignoring subsequent input until next ';'..."
[5]=>
string(11) "PARSE ERROR"
}
["EOL":"CQP":private]=>
string(1) "
"
["progress_handler":"CQP":private]=>
bool(false)
["gzip_path":"CQP":private]=>
string(0) ""
["debug_mode":"CQP":private]=>
bool(true)
["unbuffered_output_pending":"CQP":private]=>
bool(false)
["pretty_suspended":"CQP":private]=>
bool(false)
["corpus_charset":"CQP":private]=>
int(1)
["last_set_corpus":"CQP":private]=>
string(3) "BNC"
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[4]=>
array(7) {
["file"]=>
string(45) "/mnt/vmdata/corptedig-glif/cqpweb/lib/cqp.php"
["line"]=>
int(1101)
["function"]=>
string(20) "check_pipe_for_error"
["class"]=>
string(3) "CQP"
["object"]=>
object(CQP)#84 (21) {
["has_been_disconnected":"CQP":private]=>
bool(false)
["process":"CQP":private]=>
resource(5) of type (process)
["pipe":"CQP":private]=>
array(3) {
[0]=>
resource(2) of type (stream)
[1]=>
resource(3) of type (stream)
[2]=>
resource(4) of type (stream)
}
["last_registry_invoked":"CQP":private]=>
string(48) "/mnt/vmdata/corptedig-glif/corpora/cqp/registry/"
["major_version"]=>
int(3)
["minor_version"]=>
int(5)
["revision_version"]=>
int(0)
["revision_version_flagged_beta":"CQP":private]=>
bool(false)
["compile_date"]=>
NULL
["version_string"]=>
string(17) "CQP version 3.5.0"
["status":"CQP":private]=>
int(1)
["error_handler":"CQP":private]=>
string(13) "exiterror_cqp"
["error_message":"CQP":private]=>
array(6) {
[0]=>
string(19) "**** CQP ERROR ****"
[1]=>
string(10) "CQP Error:"
[2]=>
string(60) "CQP Syntax Error: syntax error, unexpected ';', expecting ID"
[3]=>
string(18) "show +word + ; <--"
[4]=>
string(43) "Ignoring subsequent input until next ';'..."
[5]=>
string(11) "PARSE ERROR"
}
["EOL":"CQP":private]=>
string(1) "
"
["progress_handler":"CQP":private]=>
bool(false)
["gzip_path":"CQP":private]=>
string(0) ""
["debug_mode":"CQP":private]=>
bool(true)
["unbuffered_output_pending":"CQP":private]=>
bool(false)
["pretty_suspended":"CQP":private]=>
bool(false)
["corpus_charset":"CQP":private]=>
int(1)
["last_set_corpus":"CQP":private]=>
string(3) "BNC"
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[5]=>
array(7) {
["file"]=>
string(56) "/mnt/vmdata/corptedig-glif/cqpweb/lib/concordance-ui.php"
["line"]=>
int(770)
["function"]=>
string(7) "execute"
["class"]=>
string(3) "CQP"
["object"]=>
object(CQP)#84 (21) {
["has_been_disconnected":"CQP":private]=>
bool(false)
["process":"CQP":private]=>
resource(5) of type (process)
["pipe":"CQP":private]=>
array(3) {
[0]=>
resource(2) of type (stream)
[1]=>
resource(3) of type (stream)
[2]=>
resource(4) of type (stream)
}
["last_registry_invoked":"CQP":private]=>
string(48) "/mnt/vmdata/corptedig-glif/corpora/cqp/registry/"
["major_version"]=>
int(3)
["minor_version"]=>
int(5)
["revision_version"]=>
int(0)
["revision_version_flagged_beta":"CQP":private]=>
bool(false)
["compile_date"]=>
NULL
["version_string"]=>
string(17) "CQP version 3.5.0"
["status":"CQP":private]=>
int(1)
["error_handler":"CQP":private]=>
string(13) "exiterror_cqp"
["error_message":"CQP":private]=>
array(6) {
[0]=>
string(19) "**** CQP ERROR ****"
[1]=>
string(10) "CQP Error:"
[2]=>
string(60) "CQP Syntax Error: syntax error, unexpected ';', expecting ID"
[3]=>
string(18) "show +word + ; <--"
[4]=>
string(43) "Ignoring subsequent input until next ';'..."
[5]=>
string(11) "PARSE ERROR"
}
["EOL":"CQP":private]=>
string(1) "
"
["progress_handler":"CQP":private]=>
bool(false)
["gzip_path":"CQP":private]=>
string(0) ""
["debug_mode":"CQP":private]=>
bool(true)
["unbuffered_output_pending":"CQP":private]=>
bool(false)
["pretty_suspended":"CQP":private]=>
bool(false)
["corpus_charset":"CQP":private]=>
int(1)
["last_set_corpus":"CQP":private]=>
string(3) "BNC"
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(13) "show +word + "
}
}
[6]=>
array(4) {
["file"]=>
string(53) "/mnt/vmdata/corptedig-glif/cqpweb/exe/concordance.php"
["line"]=>
int(1)
["args"]=>
array(1) {
[0]=>
string(56) "/mnt/vmdata/corptedig-glif/cqpweb/lib/concordance-ui.php"
}
["function"]=>
string(7) "require"
}
}
<br><br></pre></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Missatge de Andrés Chandía <<a href="mailto:andres.chandia@upf.edu" target="_blank">andres.chandia@upf.edu</a>> del dia dj., 20 d’abr. 2023 a les 14:57:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="color:rgb(11,83,148)">Sorry Josep, maybe Andrew is asking about cqpweb, if so....<br></div><div class="gmail_default" style="color:rgb(11,83,148)">CQPweb v3.2.43 © 2008-2020
</div><div class="gmail_default" style="color:rgb(11,83,148)"><br clear="all"></div><div><div dir="ltr"><div dir="ltr"><span style="color:rgb(0,0,255)"><i><span style="font-family:trebuchet ms,sans-serif">... Andrés Chandía</span></i></span><br></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Missatge de Josep M. Fontana <<a href="mailto:josepm.fontana@upf.edu" target="_blank">josepm.fontana@upf.edu</a>> del dia dj., 20 d’abr. 2023 a les 14:55:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>OK. In the error message I see a reference to version 3.50 of
CQP. I'm not sure whether that also corresponds to the version of
CQPWeb.<br>
</p>
<p>```<br>
NULL
</p>
<pre> ["version_string"]=>
string(17) "CQP version 3.5.0"
["status":"CQP":private]=>
int(1)</pre>
<p>```<br>
<br>
JM<br>
</p>
<div>On 20/4/23 14:38, Hardie, Andrew wrote:<br>
</div>
<blockquote type="cite">
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Hi
Josep,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">what
version are you running?
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>
<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><cwb-bounces@sslmit.unibo.it></a>
<b>On Behalf Of </b>Josep M. Fontana<br>
<b>Sent:</b> Thursday, April 20, 2023 1:28 PM<br>
<b>To:</b> <a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a><br>
<b>Subject:</b> [CWB] Problems exporting<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p>Hi there,<u></u><u></u></p>
<p>I'm having problems using the 'Export corpus' functionality
in cqpWeb. <br>
<br>
When I try:<br>
<br>
Corpus queries > Export corpus > Choose an export
format: > Word-and-tag format (joined with forward-slash)<u></u><u></u></p>
<p>or <br>
<br>
Corpus queries > Export corpus > Choose an export
format: > Columnar with all tags (CWB input format)<u></u><u></u></p>
<p>Whether it is as a 'single text file' or as 'zip file with
separate files for each corpus text' , I always get a pop-up
window with the message 'CQPweb is processing your request.
Please wait.'<u></u><u></u></p>
<p>This never goes away, though. Nothing seems to be exported.
I don't know whether there is a connection, but in one of
the attempts to export a corpus, the particular corpus I
tried to export ceased to work and now I'm get this error
message when I try to do a search:<u></u><u></u></p>
<p>```<u></u><u></u></p>
<p>CQP reports an error! The CQP program
sent back these error messages:<u></u><u></u></p>
<p>**** CQP ERROR ****<u></u><u></u></p>
<p>CQP Error:<u></u><u></u></p>
<p>CQP Syntax Error: syntax error,
unexpected ';', expecting ID<u></u><u></u></p>
<p>show +word + ; <--<u></u><u></u></p>
<p>Ignoring subsequent input until next
';'...<u></u><u></u></p>
<p>PARSE ERROR<u></u><u></u></p>
<p><br>
```<u></u><u></u></p>
<p>This didn't happen before I try to export this corpus.<u></u><u></u></p>
<p>I also don't know whether this is related but, whatever of
our corpora I'm using, I often get this error message:<u></u><u></u></p>
<p style="margin-bottom:12pt"><br>
ERROR: Redirect type unrecognised.<br>
<br>
Please reload CQPweb.<br>
<br>
The problem gets solved by clicking on the link to reload
CQPweb but it looks like this is a sign that something is
wrong with our installation.
<br>
<br>
I'm aware that there are a few different issues here and I
will appreciate any help you can provide to solve them. My
most pressing issue, though, is that I need to urgently
export one of our corpora. We are working on a project where
we need to process the tagged corpus outside CQPweb. The
problem is that we cannot find the files with the tagged
texts that were the basis for the CQPWeb installation of the
corpus.
<br>
<br>
I have browsed through the different folders connected to
the CQPWeb installation in our server and I haven't been
able to find any text files that would contain the word and
the tag whether it is in the columnar 'CWB input format' or
'joined with forward-slash'.
<br>
<br>
So, any help with being able to export the corpus via the
CQPWeb interface or with identifying the relevant text files
in the folder structure associated with the CQPWeb
installation (would these files, if they do exist, have a
specific extension that would help identifying them?) would
be especially appreciated. <br>
<br>
Josep M.<br>
<u></u><u></u></p>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
CWB mailing list
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</blockquote></div>
</blockquote></div>
</blockquote></div>