<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Dear Andrew,<div class=""><br class=""></div><div class="">I encounter an error trying to create collocations on CQPweb 3.2.42. I haven’t used our CQPweb install in a while and it is possible that the server environment (Mariadb version?) has changed. But this segment of the SQL statement also looks suspicious to me: "having LogLikelihood >= and observed >= 5“ (missing value after LogLikelihood?). </div><div class=""><br class=""></div><div class="">Thanks so much for your help!</div><div class="">Thilo</div><div class=""><br class=""></div><div class=""><table class="concordtable fullwidth" style="background-color: rgb(231, 236, 247); border-collapse: collapse; border: none; padding: 5px; font-family: Verdana; font-size: 13.333333015441895px; caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34);"><tbody class=""><tr class=""><th class="concordtable" style="background-color: var(--color_bg_strong); border-collapse: collapse; border: none; padding: 5px; font-size: 15.333332061767578px; vertical-align: bottom;">CQPweb encountered an error and could not continue.</th></tr><tr class=""><td class="concorderror" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;"><p class="errormessage" style="font-size: large;">An SQL query did not run successfully!</p><p class="errormessage" style="font-size: large;">Original query: select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected, log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance , sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * ( IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) + IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) + IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) + IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) ) as LogLikelihood, freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item` and dist between -3 and 3 and freq_corpus_tagesschau_word.`freq` >= 5 group by `db_colloc_glri2o63ehp`.`word` having LogLikelihood >= and observed >= 5 order by significance desc LIMIT 0, 50 /* from User: thilo | Function: require() | 2020-Dec-17 21:35 */</p><p class="errormessage" style="font-size: large;">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</p></td></tr><tr class=""><th class="concordtable" style="background-color: var(--color_bg_strong); border-collapse: collapse; border: none; padding: 5px; font-size: 15.333332061767578px; vertical-align: bottom;">PHP debugging backtrace</th></tr><tr class=""><td class="concorderror" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;"><pre class="">array(4) {
[1]=>
array(4) {
["file"]=>
string(43) "/var/www/html/diskurs/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(2291) "Original query:
select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected,
log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance ,
sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * (
IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +
IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) +
IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +
IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0)
) as LogLikelihood,
freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count
from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word
where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item`
and dist between -3 and 3
and freq_corpus_tagesschau_word.`freq` >= 5
group by `db_colloc_glri2o63ehp`.`word`
having LogLikelihood >= and observed >= 5
order by significance desc
LIMIT 0, 50
/* from User: thilo | Function: require() | 2020-Dec-17 21:35 */
"
[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(37) "/var/www/html/diskurs/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(2271) "select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected,
log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance ,
sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * (
IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +
IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) +
IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +
IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0)
) as LogLikelihood,
freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count
from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word
where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item`
and dist between -3 and 3
and freq_corpus_tagesschau_word.`freq` >= 5
group by `db_colloc_glri2o63ehp`.`word`
having LogLikelihood >= and observed >= 5
order by significance desc
LIMIT 0, 50
/* from User: thilo | Function: require() | 2020-Dec-17 21:35 */"
}
}
[3]=>
array(4) {
["file"]=>
string(44) "/var/www/html/diskurs/lib/collocation-ui.php"
["line"]=>
int(512)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(2271) "select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected,
log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance ,
sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * (
IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +
IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) +
IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +
IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0)
) as LogLikelihood,
freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count
from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word
where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item`
and dist between -3 and 3
and freq_corpus_tagesschau_word.`freq` >= 5
group by `db_colloc_glri2o63ehp`.`word`
having LogLikelihood >= and observed >= 5
order by significance desc
LIMIT 0, 50
/* from User: thilo | Function: require() | 2020-Dec-17 21:35 */"
}
}
[4]=>
array(4) {
["file"]=>
string(41) "/var/www/html/diskurs/exe/collocation.php"
["line"]=>
int(1)
["args"]=>
array(1) {
[0]=>
string(44) "/var/www/html/diskurs/lib/collocation-ui.php"
}
["function"]=>
string(7) "require"
}
}
</pre></td></tr></tbody></table><hr style="border: 0px; height: 3px; background: var(--color_border); caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34); font-family: Verdana; font-size: 13.333333015441895px;" class=""><table class="concordtable fullwidth" style="background-color: rgb(231, 236, 247); border-collapse: collapse; border: none; padding: 5px; font-family: Verdana; font-size: 13.333333015441895px; caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34);"><tbody class=""><tr class=""><td align="left" class="cqpweb_copynote" width="33%" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;">CQPweb v3.2.42 © 2008-2020</td><td align="center" class="cqpweb_copynote" width="33%" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;"><a class="cqpweb_copynote_link" href="https://diskurs.geographie.uni-freiburg.de/tagesschau/help.php?ui=hello" target="cqpweb_help_browser" style="color: var(--color_link, #4D4FE5);">Help! on CQPweb</a></td><td align="right" class="cqpweb_copynote" width="33%" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;">You are logged in as user [thilo]</td></tr></tbody></table><div id="templateForToolTip" class="floatingToolTip" style="caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34); font-family: Verdana; font-size: 13.333333015441895px; background-color: rgb(231, 236, 247);"><table class="floatingToolTipFrame" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;"><tbody class=""><tr class=""><td class="floatingToolTipTarget" style="background-color: var(--color_bg); border-collapse: collapse; border: none; padding: 5px; font-size: 10pt;"> </td></tr></tbody></table></div><div class=""><br class=""></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></body></html>