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

[Stefan Evert]

> On 1 May 2019, at 16:51, Hardie, Andrew <a.hardie at lancaster.ac.uk> wrote:
> 
> 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. 

To expand on Andrew's explanation, the actual PHP "error" message appears in the server log.  It's a line like this:

[Tue Apr 30 17:53:45.655796 2019] [php7:warn] [pid 837] [client 127.0.0.1:50146] PHP Warning:  mysqli_query(): LOAD DATA LOCAL INFILE forbidden in /var/www/html/cqpweb/lib/fake-mysql.inc.php on line 195, referer: http://localhost/cqpweb/dickens/concordance.php?theData=%7Bboot%7D&qmode=sq_nocase&pp=50&del=begin&t=&del=end&uT=y


So PHP only gives a warning, but then fails to execute the SQL query without providing a reasonable error message.  (You might want to redact the message – I don't know how seriously the devs are going to take it if it comes from a PHP file named fake-mysql.inc.php. ;-)

Best,
Stefan