[CWB] [CQPweb] Collocations error for CQPweb v3.2.43
wu liangping
liangpingwu at 126.com
Sat Aug 7 14:34:13 CEST 2021
Dear all,
After the concordancing of a word in CQPweb, the next action of Collocations runs into an error (CQPweb v3.2.43 and MySQL 5.7.28), which is consistent for corpora big and small. However, an installation of CQPweb v3.2.42 has no such a problem.
Any hint is appreciated.
Here is the dump of the output:
array(4) {
[1]=>
array(4) {
["file"]=>
string(54) "/usr/local/apache2/htdocs/cqpweb/lib/exiterror-lib.php"
["line"]=>
int(367)
["function"]=>
string(9) "exiterror"
["args"]=>
array(3) {
[0]=>
array(3) {
[0]=>
string(38) "An SQL query did not run successfully!"
[1]=>
string(2356) "Original query:
select `db_colloc_gt8hk7kp1nl`.`word`, count(`db_colloc_gt8hk7kp1nl`.`word`) as observed, (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121) as expected,
log2( (1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) / 582) / (IF(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)), 0.5) / 225539) ) as significance ,
sign(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) - (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)) * 2 * (
IF(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) > 0, 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) * log(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) / (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)), 0) +
IF((582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, (582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) * log((582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) / (582 * (226121 - (freq_sc_guardian_gt8hk7kp1nl_word.freq)) / 226121)), 0) +
IF(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) * log(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) / (225539 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)), 0) +
IF((225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) > 0, (225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) * log((225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) / (225539 * (226121 - (freq_sc_guardian_gt8hk7kp1nl_word.freq)) / 226121)), 0)
) as LogLikelihood,
freq_sc_guardian_gt8hk7kp1nl_word.freq, count(distinct(text_id)) as text_id_count
from db_colloc_gt8hk7kp1nl, freq_sc_guardian_gt8hk7kp1nl_word
where `db_colloc_gt8hk7kp1nl`.`word` = freq_sc_guardian_gt8hk7kp1nl_word.`item`
and dist between -3 and 3
and freq_sc_guardian_gt8hk7kp1nl_word.`freq` >= 5
group by `db_colloc_gt8hk7kp1nl`.`word`
having LogLikelihood >= and observed >= 5
order by significance desc
LIMIT 0, 50
/* from User: cqpweb | Function: require() | 2021-Aug-07 12:23 */
"
[2]=>
string(242) "Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and observed >= 5
order by significance desc
LIMIT 0, 50
/* from Use' at line 16 "
}
[1]=>
NULL
[2]=>
NULL
}
}
[2]=>
array(4) {
["file"]=>
string(48) "/usr/local/apache2/htdocs/cqpweb/lib/sql-lib.php"
["line"]=>
int(216)
["function"]=>
string(18) "exiterror_sqlquery"
["args"]=>
array(3) {
[0]=>
int(1064)
[1]=>
string(227) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and observed >= 5
order by significance desc
LIMIT 0, 50
/* from Use' at line 16"
[2]=>
string(2336) "select `db_colloc_gt8hk7kp1nl`.`word`, count(`db_colloc_gt8hk7kp1nl`.`word`) as observed, (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121) as expected,
log2( (1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) / 582) / (IF(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)), 0.5) / 225539) ) as significance ,
sign(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) - (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)) * 2 * (
IF(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) > 0, 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) * log(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) / (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)), 0) +
IF((582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, (582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) * log((582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) / (582 * (226121 - (freq_sc_guardian_gt8hk7kp1nl_word.freq)) / 226121)), 0) +
IF(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) * log(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) / (225539 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)), 0) +
IF((225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) > 0, (225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) * log((225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) / (225539 * (226121 - (freq_sc_guardian_gt8hk7kp1nl_word.freq)) / 226121)), 0)
) as LogLikelihood,
freq_sc_guardian_gt8hk7kp1nl_word.freq, count(distinct(text_id)) as text_id_count
from db_colloc_gt8hk7kp1nl, freq_sc_guardian_gt8hk7kp1nl_word
where `db_colloc_gt8hk7kp1nl`.`word` = freq_sc_guardian_gt8hk7kp1nl_word.`item`
and dist between -3 and 3
and freq_sc_guardian_gt8hk7kp1nl_word.`freq` >= 5
group by `db_colloc_gt8hk7kp1nl`.`word`
having LogLikelihood >= and observed >= 5
order by significance desc
LIMIT 0, 50
/* from User: cqpweb | Function: require() | 2021-Aug-07 12:23 */"
}
}
[3]=>
array(4) {
["file"]=>
string(55) "/usr/local/apache2/htdocs/cqpweb/lib/collocation-ui.php"
["line"]=>
int(512)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(2336) "select `db_colloc_gt8hk7kp1nl`.`word`, count(`db_colloc_gt8hk7kp1nl`.`word`) as observed, (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121) as expected,
log2( (1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) / 582) / (IF(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)), 0.5) / 225539) ) as significance ,
sign(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) - (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)) * 2 * (
IF(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) > 0, 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) * log(1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`) / (582 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)), 0) +
IF((582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, (582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) * log((582 - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) / (582 * (226121 - (freq_sc_guardian_gt8hk7kp1nl_word.freq)) / 226121)), 0) +
IF(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) > 0, ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) * log(((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`)) / (225539 * (freq_sc_guardian_gt8hk7kp1nl_word.freq) / 226121)), 0) +
IF((225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) > 0, (225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) * log((225539 - ((freq_sc_guardian_gt8hk7kp1nl_word.freq) - 1e0 * COUNT(`db_colloc_gt8hk7kp1nl`.`word`))) / (225539 * (226121 - (freq_sc_guardian_gt8hk7kp1nl_word.freq)) / 226121)), 0)
) as LogLikelihood,
freq_sc_guardian_gt8hk7kp1nl_word.freq, count(distinct(text_id)) as text_id_count
from db_colloc_gt8hk7kp1nl, freq_sc_guardian_gt8hk7kp1nl_word
where `db_colloc_gt8hk7kp1nl`.`word` = freq_sc_guardian_gt8hk7kp1nl_word.`item`
and dist between -3 and 3
and freq_sc_guardian_gt8hk7kp1nl_word.`freq` >= 5
group by `db_colloc_gt8hk7kp1nl`.`word`
having LogLikelihood >= and observed >= 5
order by significance desc
LIMIT 0, 50
/* from User: cqpweb | Function: require() | 2021-Aug-07 12:23 */"
}
}
[4]=>
array(4) {
["file"]=>
string(52) "/usr/local/apache2/htdocs/cqpweb/exe/collocation.php"
["line"]=>
int(1)
["args"]=>
array(1) {
[0]=>
string(55) "/usr/local/apache2/htdocs/cqpweb/lib/collocation-ui.php"
}
["function"]=>
string(7) "require"
}
}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20210807/b953ecb6/attachment-0001.html>
More information about the CWB
mailing list