<div dir="ltr">Hi Andrew,<div><br></div><div>Thanks! There's one small issue remaining in 1274 -- here's the error message:</div><div><br></div><div><font face="courier new, monospace">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</font><br></div><div><br></div><div>Cheers,</div><div>Scott</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">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:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-GB">
<div class="gmail-m_448492500394989755WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11pt;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<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">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).<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Just in case it's relevant, I'm using the CQPweb repo here...<u></u><u></u></p>
</div>
<div>
<ul type="disc">
<li class="MsoNormal">
<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><u></u><u></u></li></ul>
<div>
<p class="MsoNormal">...but the CQP, CQP-DOC and CQP-PERL repos here...<u></u><u></u></p>
</div>
<ul type="disc">
<li class="MsoNormal">
<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><u></u><u></u></li><li class="MsoNormal">
<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><u></u><u></u></li><li class="MsoNormal">
<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><u></u><u></u></li></ul>
</div>
<div>
<p class="MsoNormal">Best wishes,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Scott<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">The error follows:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><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><u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<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" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div style="font-size:12.7273px">Dr. Scott Sadowsky<br>Profesor Asistente de Lingüística</div><div dir="ltr" style="font-size:12.7273px">Pontificia Universidad Católica de Chile<br></div><div dir="ltr" style="font-size:12.7273px"><br></div><div dir="ltr" style="font-size:12.7273px">ssadowsky gmail com</div><div dir="ltr" style="font-size:12.7273px">scsadowsky uc cl<br><a href="http://sadowsky.cl/" target="_blank">http://sadowsky.cl/</a></div><div dir="ltr" style="font-size:12.7273px"> </div></div></div></div></div></div></div></div></div></div></div>