<div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div style="margin: 0;">Dear all,</div><div style="margin: 0;"><br></div><div style="margin: 0;">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. </div><div style="margin: 0;">Any hint is appreciated.</div><div style="margin: 0;">Here is the dump of the output:</div><div style="margin: 0;"><br></div><div style="margin: 0;"><pre style="font-size: 13.3333px;">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"
}
}</pre></div><div style="margin: 0;"> </div><blockquote id="isReplyContent" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><div class="WordSection1"><div><div><blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm" id="isReplyContent"><div><div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote><style><!--
_font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
_font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
_font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
_font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
_page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style></div>