[CWB] Is someone else running cqpweb under Ubuntu 18.04 LTS?

[Hardie, Andrew]

I don't know if you can revise that bug report, but I doubt it will get a hearing in its present form, since what you have actually pasted in is the CQPweb message. When CQPweb detects a MySQL request has not worked, it prints the following block  which embeds the two error indicators from the mysqli module:

=========================
A MySQL query did not run successfully!

Original query: LOAD DATA LOCAL INFILE '/data2/cqpweb/cach/tab_dist_fycel9oplk' INTO TABLE `db_dist_g2f3ndxf40` FIELDS ESCAPED BY '' /* from User: knappen |
 Function: create_db() | 2019-Apr-25 11:23:01 */

Error # XXXXXXXXXXXXXXXXXXXXXXXXXX: YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY
=========================

Everything above is generated by CQPweb except XXXXXXXX - which is the integer error code supplied by MySQL - and YYYY - which is the corresponding error message text. So, for instance, you might get  1026 with the error message, "Error writing file ".

CQPweb can only convey the error message it gets. In this case, there *is no* error code (it's 0, which means "no error", which is why the YYYYYY message is empty) because the PHP config itself intervened to stop the query being executed. 

I suggest you revise the bug to make it clear that the problem is that mysqli_errnbo returns 0 and mysqli_error returns an empty string on this condition rather than some meaningful error.  Otherwise, the presence of CQPweb-specific material will likely lead the PHP devs to ignore it. 

best

Andrew.

(Ubuntu is great. Until you need to upgrade. Then, heaven protect you.)

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Jörg Knappen
Sent: 01 May 2019 15:41
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Is someone else running cqpweb under Ubuntu 18.04 LTS?

Hallo Andrew,

I don't think that Ubuntu sucks (at least not in this case). But I  
definetely think that the current behaviour of php is a bug because  
the error message is not informative at all. I filed a php bug report  
on this issue here

https://bugs.php.net/bug.php?id=77956

--Jörg Knappen

Zitat von "Hardie, Andrew" <a.hardie at lancaster.ac.uk>:

> Ubuntu does suck. If you're setting up a box primarily to run  
> CQPweb, Debian stable (stretch) is a better choice.
>
>
> -----Original Message-----
> From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On  
> Behalf Of Stefan Evert
> Sent: 30 April 2019 11:47
> To: CWBdev Mailing List <cwb at sslmit.unibo.it>; Jörg Knappen  
> <j.knappen at mx.uni-saarland.de>
> Subject: Re: [CWB] Is someone else running cqpweb under Ubuntu 18.04 LTS?
>
> Hi Jörg,
>
> I have recently set up a Ubuntu 18.04 VM (a kind of updated  
> CQPwebInABox) and can reproduce the problem after updating the  
> Ubuntu system.
>
> First conclusion: Ubuntu sucks.
>
> I'll see if I can investigate the problem.  CQPweb is still at  
> 3.2.31 in this machine, so it's clearly not related to CQPweb version.
>
> Best,
> Stefan
>
>
>
>
>> On 29 Apr 2019, at 23:23, Jörg Knappen <j.knappen at mx.uni-saarland.de> wrote:
>>
>> Is someone else running a cqpweb installation under Ubuntu 18.04  
>> LTS and using Apache as a web server? Did you encounter problems  
>> with "Frequency breakdown" and/or "Distribution"?
>>
>> PLease answer also when you have encountered no problems.
>>
>> The problem I reported earlier on this list is also present on a  
>> second server that is set up for test
>> purpose, and I suspect something on Ubuntu causing it. This  
>> installation is really small, and size cannot be a problem
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb



_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://liste.sslmit.unibo.it/mailman/listinfo/cwb