[CWB] Solved! Re: Problems after upgrade from cqpweb 3.2.42 to 3.3.17

[Jörg Knappen]

Finally, the problem is solved, it was in the mysql configuration where 
I add to add

local_infile    = TRUE

to the file

/etc/mysql/mysql.conf.d/mysqld.cnf

Frequency breakdown and distribution are working again now!

Greetings from Saarbrücken,

Jörg Knappen

Am 2022-11-11 14:28, schrieb Jörg Knappen:
> More details on the problem:
> 
> The cqpweb is installed on a brand new server running Ubuntu 22.04 LTS
> and php version 8.1
> I checked that the configuration
> mysqli.allow_local_infile = On
> is set both in /etc/php/8.1/apache2/php.ini and 
> /etc/php/8.1/cli/php.ini
> 
> cqp, cqp-perl, and cqpweb are installed from the most recent trunk
> (revision 1826).
> 
> I re-generated the frequency tables for the corpus in question, with
> no change of the results
> 
> Still stuck ...
> 
> Jörg Knappen
> 
> Am 2022-11-11 12:17, schrieb Jörg Knappen:
>> I have (on a test server) just upgraded our cqpweb installation with
>> quite a history from version 3.2.42 to 3.3.17.
>> 
>> After the upgrade, I run into the following problem:
>> 
>> Frequency Breakdown and Distribution do not work any longer,
>> 
>> Frequency Breakdown throws an error:
>> 
>> CQPweb encountered an error and could not continue.
>> 
>> Your frequency breakdown request produced no results (possible
>> database error; if so, contact the system administrator).
>> 
>> Back to main query page
>> 
>> And Distribution just produces this output:
>> 
>> Distribution of hits for query “[word="[Oo]ptic.*"]” returned 2,358
>> matches in 699 different texts
>> Currently displaying distribution across text classifications.
>> Display distribution of:
>> Show as:
>> Cross-tabulating against:
>> Other actions:
>> Based on classification: Century of publication
>> Category [↓] 	Words in category 	Hits in category 	Dispersion
>> (no. texts with 1+ hits) 	Frequency [↓]
>> per million words in category
>> Total: 	0 	0 	0 out of 0 	ERROR: cannot calculate
>> Based on classification: Decade of publication
>> Category [↓] 	Words in category 	Hits in category 	Dispersion
>> (no. texts with 1+ hits) 	Frequency [↓]
>> per million words in category
>> Total: 	0 	0 	0 out of 0 	ERROR: cannot calculate
>> Based on classification: 50-year period of publication
>> Category [↓] 	Words in category 	Hits in category 	Dispersion
>> (no. texts with 1+ hits) 	Frequency [↓]
>> per million words in category
>> Total: 	0 	0 	0 out of 0 	ERROR: cannot calculate
>> 
>> I am stuck here ...
>> 
>> Jörg Knappen
>> _______________________________________________
>> 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