<div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div style="margin: 0px;">Hi <span style="font-family: arial; white-space: pre-wrap;">Stefan,</span></div><div style="margin: 0px;"><span style="font-family: arial; white-space: pre-wrap;"><br></span></div><div style="margin: 0px;"><span style="font-family: arial; white-space: pre-wrap;">You are right and great! My two versions of CQPweb are on two separate machines, one with R and the other not.</span></div><div style="margin: 0px;"><span style="font-family: arial; white-space: pre-wrap;">Problem solved. </span></div><div style="margin: 0px;"><span style="font-family: arial; white-space: pre-wrap;">Thanks a lot!</span></div><div style="margin: 0px;"><span style="font-family: arial; white-space: pre-wrap;"><br></span></div><div style="margin: 0px;"><span style="font-family: arial; white-space: pre-wrap;">Best,</span></div><div style="position: relative; zoom: 1;"><span style="color: rgb(128, 128, 128);"><span style="color: rgb(0, 0, 0);">WU Liangping</span></span><span style="color: rgb(128, 128, 128);"><br></span> </div><div style="position:relative;zoom:1"><div style="clear:both"></div></div><div id="divNeteaseMailCard"></div><p style="margin: 0;"><br></p><pre><br>At 2021-08-07 21:21:17, "Stefan Evert" <stefanML@collocations.de> wrote:
>
>
>> On 7 Aug 2021, at 14:34, wu liangping <liangpingwu@126.com> wrote:
>>
>> fter 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.
>
>If I remember correctly, that indicates a problem with your R installation (or the PHP / R interface). Did you follow all steps to set up R for CQPweb?
>
>The problem is that on this line of the SQL command:
>
>> having LogLikelihood >= and observed >= 5
>
>the appropriate log-likelihood threshold (calculated via R) is missing, leading to a syntax error in the SQL.
>
>Best,
>Stefan
>
>
</pre></div>