[CWB] Problems exporting
Andrés Chandía
andres.chandia at upf.edu
Thu Apr 20 18:17:45 CEST 2023
About the mail I've just sent, I'm definitely wrong because queries are
working with other corpus...
*... Andrés Chandía*
Missatge de Andrés Chandía <andres.chandia at upf.edu> del dia dj., 20 d’abr.
2023 a les 18:14:
> Hi Andrew, error seems to be generated on the sql query:
>
> 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 */
>
>
> cqp_query goes '[word=\"word\"%c]' where the characters *%c* 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,
> 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?
> Again, I'm probably wrong... so I better add the complete php debugging...
>
> 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"
> }
> }
>
>
> Missatge de Andrés Chandía <andres.chandia at upf.edu> del dia dj., 20
> d’abr. 2023 a les 14:57:
>
>> Sorry Josep, maybe Andrew is asking about cqpweb, if so....
>> CQPweb v3.2.43 © 2008-2020
>>
>> *... Andrés Chandía*
>>
>>
>> Missatge de Josep M. Fontana <josepm.fontana at upf.edu> del dia dj., 20
>> d’abr. 2023 a les 14:55:
>>
>>> 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.
>>>
>>> ```
>>> NULL
>>>
>>> ["version_string"]=>
>>> string(17) "CQP version 3.5.0"
>>> ["status":"CQP":private]=>
>>> int(1)
>>>
>>> ```
>>>
>>> JM
>>> On 20/4/23 14:38, Hardie, Andrew wrote:
>>>
>>> Hi Josep,
>>>
>>>
>>>
>>> what version are you running?
>>>
>>>
>>>
>>> best
>>>
>>>
>>>
>>> Andrew.
>>>
>>>
>>>
>>> *From:* cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it>
>>> <cwb-bounces at sslmit.unibo.it> *On Behalf Of *Josep M. Fontana
>>> *Sent:* Thursday, April 20, 2023 1:28 PM
>>> *To:* cwb at sslmit.unibo.it
>>> *Subject:* [CWB] Problems exporting
>>>
>>>
>>>
>>> Hi there,
>>>
>>> I'm having problems using the 'Export corpus' functionality in cqpWeb.
>>>
>>> When I try:
>>>
>>> Corpus queries > Export corpus > Choose an export format: > Word-and-tag
>>> format (joined with forward-slash)
>>>
>>> or
>>>
>>> Corpus queries > Export corpus > Choose an export format: > Columnar
>>> with all tags (CWB input format)
>>>
>>> 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.'
>>>
>>> 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:
>>>
>>> ```
>>>
>>> CQP reports an error! The CQP program sent back these error messages:
>>>
>>> **** CQP ERROR ****
>>>
>>> CQP Error:
>>>
>>> CQP Syntax Error: syntax error, unexpected ';', expecting ID
>>>
>>> show +word + ; <--
>>>
>>> Ignoring subsequent input until next ';'...
>>>
>>> PARSE ERROR
>>>
>>>
>>> ```
>>>
>>> This didn't happen before I try to export this corpus.
>>>
>>> I also don't know whether this is related but, whatever of our corpora
>>> I'm using, I often get this error message:
>>>
>>>
>>> ERROR: Redirect type unrecognised.
>>>
>>> Please reload CQPweb.
>>>
>>> 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.
>>>
>>> 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.
>>>
>>> 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'.
>>>
>>> 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.
>>>
>>> Josep M.
>>>
>>>
>>> _______________________________________________
>>> CWB mailing listCWB at sslmit.unibo.ithttp://liste.sslmit.unibo.it/mailman/listinfo/cwb
>>>
>>> _______________________________________________
>>> CWB mailing list
>>> CWB at sslmit.unibo.it
>>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20230420/3d1506ca/attachment-0001.html>
More information about the CWB
mailing list