<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
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:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
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.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Verdana",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri",sans-serif;
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:236286642;
        mso-list-template-ids:-228133040;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:72.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:108.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:144.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:180.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:216.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:252.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:288.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:324.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1
        {mso-list-id:866602073;
        mso-list-template-ids:2072395140;}
@list l1:level1
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level2
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:72.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level3
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:108.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level4
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:144.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level5
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:180.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level6
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:216.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level7
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:252.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level8
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:288.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l1:level9
        {mso-level-number-format:bullet;
        mso-level-text:;
        mso-level-tab-stop:324.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Will be fixed in next commit to the branch. Meanwhile, can I suggest just deleting line 37.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 11 July 2019 06:06<br>
<b>To:</b> Open source development of the Corpus WorkBench <cwb@sslmit.unibo.it><br>
<b>Subject:</b> Re: [CWB] [CQPweb latest] SQL errores<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Andrew,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks! There's one small issue remaining in 1274 -- here's the error message:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">PHP Warning: require(../lib/admin-lib.php): failed to open stream: No such file or directory in /var/www/html/cqpweb/bin/autosetup.php on line 37<br>
PHP Fatal error: require(): Failed opening required '../lib/admin-lib.php' (include_path='.:/usr/share/php') in /var/www/html/cqpweb/bin/autosetup.php on line 37</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Scott<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Wed, Jul 10, 2019 at 7:36 PM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">Hi Scott, thanks for the report. This is an issue of code added to ensure compatibility with SQL “strict
mode”; I’d omitted a needed time zone tweak in the ./bin scripts, thus the bug. I fixed this last week, but it looks like I forgot to commit the changes - oops! will do so now. – Andrew.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">
<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 09 July 2019 15:55<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:CWB@liste.sslmit.unibo.it" target="_blank">CWB@liste.sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] [CQPweb latest] SQL errores</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I'm trying to install the new 3.2 latest branch of CQPweb, and I've run into a bunch of SQL errors (see below).<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Just in case it's relevant, I'm using the CQPweb repo here...<o:p></o:p></p>
</div>
<div>
<ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span style="font-family:"Courier New""><a href="https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest" target="_blank">https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest</a></span><o:p></o:p></li></ul>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">...but the CQP, CQP-DOC and CQP-PERL repos here...<o:p></o:p></p>
</div>
<ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<span style="font-family:"Courier New""><a href="http://svn.code.sf.net/p/cwb/code/cwb/trunk" target="_blank">http://svn.code.sf.net/p/cwb/code/cwb/trunk</a> cwb</span><o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<span style="font-family:"Courier New""><a href="http://svn.code.sf.net/p/cwb/code/doc" target="_blank">http://svn.code.sf.net/p/cwb/code/doc</a> cwb-doc</span><o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<span style="font-family:"Courier New""><a href="http://svn.code.sf.net/p/cwb/code/perl/trunk" target="_blank">http://svn.code.sf.net/p/cwb/code/perl/trunk</a> cwb-perl</span><o:p></o:p></li></ul>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Best wishes,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Scott<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">The error follows:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Courier New"">Now finalising setup for this installation of CQPweb....<br>
Installing database structure; please wait.<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php on line 167<br>
PHP Notice: Undefined property: NotAFullConfig::$Api in /var/www/html/cqpweb/lib/exiterror-lib.php on line 262<br>
An SQL query did not run successfully!<br>
Original query: <br>
CREATE TABLE `user_info` (<br>
`id` int unsigned NOT NULL AUTO_INCREMENT,<br>
`username` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,<br>
`realname` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`email` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`affiliation` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`country` char(2) CHARSET ascii COLLATE ascii_bin default '00',<br>
`passhash` char(61) CHARSET ascii COLLATE ascii_bin default '',<br>
`acct_status` tinyint(2) unsigned NOT NULL default 0, <br>
`verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin default NULL,<br>
`expiry_time` int unsigned NOT NULL default 0,<br>
`password_locked` tinyint(1) NOT NULL default 0,<br>
`password_expiry_time` int unsigned NOT NULL default 0,<br>
`last_seen_time` timestamp NOT NULL default "1970-01-01 00:00:00", ### TODO rename to date_last_visited<br>
`acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP, ### TODO rename to date_acct_created<br>
`conc_kwicview` tinyint(1) NOT NULL default 1,<br>
`conc_corpus_order` tinyint(1) NOT NULL default 1,<br>
`cqp_syntax` tinyint(1) NOT NULL default 0,<br>
`context_with_tags` tinyint(1) NOT NULL default 0,<br>
`use_tooltips` tinyint(1) NOT NULL default 1,<br>
`css_monochrome` tinyint(1) NOT NULL default 0,<br>
`thin_default_reproducible` tinyint(1) NOT NULL default 1,<br>
`coll_statistic` tinyint(2) unsigned NOT NULL default 0, <br>
##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0<br>
## the collocation prefs default to 0 because their defaults are set in config.php, and imported into new user records.
<br>
`coll_freqtogether` smallint unsigned NOT NULL default 0, <br>
`coll_freqalone` smallint unsigned NOT NULL default 0, <br>
`coll_from` tinyint NOT NULL default 0,<br>
`coll_to` tinyint NOT NULL default 0,<br>
`max_dbsize` int unsigned default NULL,<br>
`freqlist_altstyle` tinyint(1) NOT NULL default 0, <br>
`linefeed` enum ("au", "a", "d", "da") NOT NULL,<br>
unique key (`username`),<br>
primary key (`id`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */<br>
Error # 1067: Invalid default value for 'last_seen_time'<br>
PHP debugging backtrace<br>
=======================<br>
array(4) {<br>
[1]=><br>
array(4) {<br>
["file"]=><br>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"<br>
["line"]=><br>
int(367)<br>
["function"]=><br>
string(9) "exiterror"<br>
["args"]=><br>
array(3) {<br>
[0]=><br>
array(3) {<br>
[0]=><br>
string(38) "An SQL query did not run successfully!"<br>
[1]=><br>
string(2543) "Original query: <br>
CREATE TABLE `user_info` (<br>
`id` int unsigned NOT NULL AUTO_INCREMENT,<br>
`username` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,<br>
`realname` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`email` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`affiliation` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`country` char(2) CHARSET ascii COLLATE ascii_bin default '00',<br>
`passhash` char(61) CHARSET ascii COLLATE ascii_bin default '',<br>
`acct_status` tinyint(2) unsigned NOT NULL default 0, <br>
`verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin default NULL,<br>
`expiry_time` int unsigned NOT NULL default 0,<br>
`password_locked` tinyint(1) NOT NULL default 0,<br>
`password_expiry_time` int unsigned NOT NULL default 0,<br>
`last_seen_time` timestamp NOT NULL default "1970-01-01 00:00:00", ### TODO rename to date_last_visited<br>
`acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP, ### TODO rename to date_acct_created<br>
`conc_kwicview` tinyint(1) NOT NULL default 1,<br>
`conc_corpus_order` tinyint(1) NOT NULL default 1,<br>
`cqp_syntax` tinyint(1) NOT NULL default 0,<br>
`context_with_tags` tinyint(1) NOT NULL default 0,<br>
`use_tooltips` tinyint(1) NOT NULL default 1,<br>
`css_monochrome` tinyint(1) NOT NULL default 0,<br>
`thin_default_reproducible` tinyint(1) NOT NULL default 1,<br>
`coll_statistic` tinyint(2) unsigned NOT NULL default 0, <br>
##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0<br>
## the collocation prefs default to 0 because their defaults are set in config.php, and imported into new user records.
<br>
`coll_freqtogether` smallint unsigned NOT NULL default 0, <br>
`coll_freqalone` smallint unsigned NOT NULL default 0, <br>
`coll_from` tinyint NOT NULL default 0,<br>
`coll_to` tinyint NOT NULL default 0,<br>
`max_dbsize` int unsigned default NULL,<br>
`freqlist_altstyle` tinyint(1) NOT NULL default 0, <br>
`linefeed` enum ("au", "a", "d", "da") NOT NULL,<br>
unique key (`username`),<br>
primary key (`id`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */<br>
"<br>
[2]=><br>
string(57) "Error # 1067: Invalid default value for 'last_seen_time' "<br>
}<br>
[1]=><br>
NULL<br>
[2]=><br>
NULL<br>
}<br>
}<br>
[2]=><br>
array(4) {<br>
["file"]=><br>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<br>
["line"]=><br>
int(213)<br>
["function"]=><br>
string(18) "exiterror_sqlquery"<br>
["args"]=><br>
array(3) {<br>
[0]=><br>
int(1067)<br>
[1]=><br>
string(42) "Invalid default value for 'last_seen_time'"<br>
[2]=><br>
string(2523) "CREATE TABLE `user_info` (<br>
`id` int unsigned NOT NULL AUTO_INCREMENT,<br>
`username` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,<br>
`realname` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`email` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`affiliation` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`country` char(2) CHARSET ascii COLLATE ascii_bin default '00',<br>
`passhash` char(61) CHARSET ascii COLLATE ascii_bin default '',<br>
`acct_status` tinyint(2) unsigned NOT NULL default 0, <br>
`verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin default NULL,<br>
`expiry_time` int unsigned NOT NULL default 0,<br>
`password_locked` tinyint(1) NOT NULL default 0,<br>
`password_expiry_time` int unsigned NOT NULL default 0,<br>
`last_seen_time` timestamp NOT NULL default "1970-01-01 00:00:00", ### TODO rename to date_last_visited<br>
`acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP, ### TODO rename to date_acct_created<br>
`conc_kwicview` tinyint(1) NOT NULL default 1,<br>
`conc_corpus_order` tinyint(1) NOT NULL default 1,<br>
`cqp_syntax` tinyint(1) NOT NULL default 0,<br>
`context_with_tags` tinyint(1) NOT NULL default 0,<br>
`use_tooltips` tinyint(1) NOT NULL default 1,<br>
`css_monochrome` tinyint(1) NOT NULL default 0,<br>
`thin_default_reproducible` tinyint(1) NOT NULL default 1,<br>
`coll_statistic` tinyint(2) unsigned NOT NULL default 0, <br>
##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0<br>
## the collocation prefs default to 0 because their defaults are set in config.php, and imported into new user records.
<br>
`coll_freqtogether` smallint unsigned NOT NULL default 0, <br>
`coll_freqalone` smallint unsigned NOT NULL default 0, <br>
`coll_from` tinyint NOT NULL default 0,<br>
`coll_to` tinyint NOT NULL default 0,<br>
`max_dbsize` int unsigned default NULL,<br>
`freqlist_altstyle` tinyint(1) NOT NULL default 0, <br>
`linefeed` enum ("au", "a", "d", "da") NOT NULL,<br>
unique key (`username`),<br>
primary key (`id`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */"<br>
}<br>
}<br>
[3]=><br>
array(4) {<br>
["file"]=><br>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<br>
["line"]=><br>
int(1091)<br>
["function"]=><br>
string(12) "do_sql_query"<br>
["args"]=><br>
array(1) {<br>
[0]=><br>
string(2523) "CREATE TABLE `user_info` (<br>
`id` int unsigned NOT NULL AUTO_INCREMENT,<br>
`username` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,<br>
`realname` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`email` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`affiliation` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',<br>
`country` char(2) CHARSET ascii COLLATE ascii_bin default '00',<br>
`passhash` char(61) CHARSET ascii COLLATE ascii_bin default '',<br>
`acct_status` tinyint(2) unsigned NOT NULL default 0, <br>
`verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin default NULL,<br>
`expiry_time` int unsigned NOT NULL default 0,<br>
`password_locked` tinyint(1) NOT NULL default 0,<br>
`password_expiry_time` int unsigned NOT NULL default 0,<br>
`last_seen_time` timestamp NOT NULL default "1970-01-01 00:00:00", ### TODO rename to date_last_visited<br>
`acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP, ### TODO rename to date_acct_created<br>
`conc_kwicview` tinyint(1) NOT NULL default 1,<br>
`conc_corpus_order` tinyint(1) NOT NULL default 1,<br>
`cqp_syntax` tinyint(1) NOT NULL default 0,<br>
`context_with_tags` tinyint(1) NOT NULL default 0,<br>
`use_tooltips` tinyint(1) NOT NULL default 1,<br>
`css_monochrome` tinyint(1) NOT NULL default 0,<br>
`thin_default_reproducible` tinyint(1) NOT NULL default 1,<br>
`coll_statistic` tinyint(2) unsigned NOT NULL default 0, <br>
##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0<br>
## the collocation prefs default to 0 because their defaults are set in config.php, and imported into new user records.
<br>
`coll_freqtogether` smallint unsigned NOT NULL default 0, <br>
`coll_freqalone` smallint unsigned NOT NULL default 0, <br>
`coll_from` tinyint NOT NULL default 0,<br>
`coll_to` tinyint NOT NULL default 0,<br>
`max_dbsize` int unsigned default NULL,<br>
`freqlist_altstyle` tinyint(1) NOT NULL default 0, <br>
`linefeed` enum ("au", "a", "d", "da") NOT NULL,<br>
unique key (`username`),<br>
primary key (`id`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */"<br>
}<br>
}<br>
[4]=><br>
array(4) {<br>
["file"]=><br>
string(38) "/var/www/html/cqpweb/bin/autosetup.php"<br>
["line"]=><br>
int(94)<br>
["function"]=><br>
string(18) "do_sql_total_reset"<br>
["args"]=><br>
array(0) {<br>
}<br>
}<br>
}<br>
PHP Notice: Undefined property: NotAFullConfig::$Api in /var/www/html/cqpweb/lib/environment.php on line 1350<br>
PHP Fatal error: Uncaught Error: Call to undefined method NotAFullConfig::disconnect_slave_program() in /var/www/html/cqpweb/lib/environment.php:1354<br>
Stack trace:<br>
#0 /var/www/html/cqpweb/lib/exiterror-lib.php(284): cqpweb_shutdown_environment()<br>
#1 /var/www/html/cqpweb/lib/exiterror-lib.php(367): exiterror(Array, NULL, NULL)<br>
#2 /var/www/html/cqpweb/lib/sql-lib.php(213): exiterror_sqlquery(1067, 'Invalid default...', 'CREATE TABLE `u...')<br>
#3 /var/www/html/cqpweb/lib/sql-lib.php(1091): do_sql_query('CREATE TABLE `u...')<br>
#4 /var/www/html/cqpweb/bin/autosetup.php(94): do_sql_total_reset()<br>
#5 {main}<br>
thrown in /var/www/html/cqpweb/lib/environment.php on line 1354</span><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Dr. Scott Sadowsky<br>
Profesor Asistente de Lingüística<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Pontificia Universidad Católica de Chile<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">ssadowsky gmail com<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">scsadowsky uc cl<br>
<a href="http://sadowsky.cl/" target="_blank">http://sadowsky.cl/</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>