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

[Jörg Knappen]

This is an addendum to the problem:

Running offline-freqlists.php still triggers the error:

PHP Warning:  mysqli_query(): LOAD DATA LOCAL INFILE forbidden in  
/var/www/html/cqpweb/lib/fake-mysql.inc.php on line 195
A MySQL query did not run successfully!


To fix the isssue, the same change has also to be done in

/etc/php/7.2/cli/php.ini

>> uncomment the setting for mysqli.allow_local_infile:
>>
>> 	; http://php.net/mysqli.allow_local_infile
>> 	mysqli.allow_local_infile = On

--Jörg Knappen

P.S. The bug report to php is now assigned.

Quoting Jörg Knappen <j.knappen at mx.uni-saarland.de>:

> Thanks, Stefan,
>
> that solves the problem!
>
> Greetings from Saarbrücken,
>
> Jörg Knappen
>
> Quoting Stefan Evert <stefanML at collocations.de>:
>
>> TL;DR: Ubuntu sucks.
>>
>> In the file
>>
>> 	/etc/php/7.2/apache2/php.ini
>>
>> uncomment the setting for mysqli.allow_local_infile:
>>
>> 	; http://php.net/mysqli.allow_local_infile
>> 	mysqli.allow_local_infile = On
>>
>> I suspect that PHP's internal default has changed with the latest  
>> update, because I didn't need to set this before.
>>
>> @Andrew: shouldn't hurt in older PHP versions, so you may want to  
>> add it to the admin manual.  Feel free to quote me on "Ubuntu sucks".
>>
>> Best,
>> Stefan