[CWB] [CQPweb latest] SQL errores
Scott Sadowsky
ssadowsky at gmail.com
Thu Jul 11 07:06:24 CEST 2019
Hi Andrew,
Thanks! There's one small issue remaining in 1274 -- here's the error
message:
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
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
Cheers,
Scott
On Wed, Jul 10, 2019 at 7:36 PM Hardie, Andrew <a.hardie at lancaster.ac.uk>
wrote:
> 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.
>
>
>
> *From:* cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> *On
> Behalf Of *Scott Sadowsky
> *Sent:* 09 July 2019 15:55
> *To:* Open source development of the Corpus WorkBench <
> CWB at liste.sslmit.unibo.it>
> *Subject:* [CWB] [CQPweb latest] SQL errores
>
>
>
> 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).
>
>
>
> Just in case it's relevant, I'm using the CQPweb repo here...
>
> - https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest
>
> ...but the CQP, CQP-DOC and CQP-PERL repos here...
>
> - http://svn.code.sf.net/p/cwb/code/cwb/trunk cwb
> - http://svn.code.sf.net/p/cwb/code/doc cwb-doc
> - http://svn.code.sf.net/p/cwb/code/perl/trunk cwb-perl
>
> Best wishes,
>
> Scott
>
>
>
> The error follows:
>
>
>
> Now finalising setup for this installation of CQPweb....
> Installing database structure; please wait.
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined offset: 3 in /var/www/html/cqpweb/lib/sql-lib.php
> on line 167
> PHP Notice: Undefined property: NotAFullConfig::$Api in
> /var/www/html/cqpweb/lib/exiterror-lib.php on line 262
> An SQL query did not run successfully!
> Original query:
> CREATE TABLE `user_info` (
> `id` int unsigned NOT NULL AUTO_INCREMENT,
> `username` varchar(64) CHARSET ascii COLLATE ascii_bin
> NOT NULL,
> `realname` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `email` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `affiliation` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `country` char(2) CHARSET ascii COLLATE ascii_bin
> default '00',
> `passhash` char(61) CHARSET ascii COLLATE ascii_bin
> default '',
> `acct_status` tinyint(2) unsigned NOT NULL default 0,
> `verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin
> default NULL,
> `expiry_time` int unsigned NOT NULL default 0,
> `password_locked` tinyint(1) NOT NULL default 0,
> `password_expiry_time` int unsigned NOT NULL default 0,
> `last_seen_time` timestamp NOT NULL default "1970-01-01
> 00:00:00", ### TODO rename to date_last_visited
> `acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
> ### TODO rename to date_acct_created
> `conc_kwicview` tinyint(1) NOT NULL default 1,
> `conc_corpus_order` tinyint(1) NOT NULL default 1,
> `cqp_syntax` tinyint(1) NOT NULL default 0,
> `context_with_tags` tinyint(1) NOT NULL default 0,
> `use_tooltips` tinyint(1) NOT NULL default 1,
> `css_monochrome` tinyint(1) NOT NULL default 0,
> `thin_default_reproducible` tinyint(1) NOT NULL default 1,
> `coll_statistic` tinyint(2) unsigned NOT NULL default 0,
> ##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0
> ## the collocation prefs default to 0 because their defaults are set in
> config.php, and imported into new user records.
> `coll_freqtogether` smallint unsigned NOT NULL default 0,
> `coll_freqalone` smallint unsigned NOT NULL default 0,
> `coll_from` tinyint NOT NULL default 0,
> `coll_to` tinyint NOT NULL default 0,
> `max_dbsize` int unsigned default NULL,
> `freqlist_altstyle` tinyint(1) NOT NULL default 0,
> `linefeed` enum ("au", "a", "d", "da") NOT NULL,
> unique key (`username`),
> primary key (`id`)
> ) ENGINE=InnoDB
> /* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */
> Error # 1067: Invalid default value for 'last_seen_time'
> PHP debugging backtrace
> =======================
> array(4) {
> [1]=>
> array(4) {
> ["file"]=>
> string(42) "/var/www/html/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(2543) "Original query:
> CREATE TABLE `user_info` (
> `id` int unsigned NOT NULL AUTO_INCREMENT,
> `username` varchar(64) CHARSET ascii COLLATE ascii_bin
> NOT NULL,
> `realname` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `email` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `affiliation` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `country` char(2) CHARSET ascii COLLATE ascii_bin
> default '00',
> `passhash` char(61) CHARSET ascii COLLATE ascii_bin
> default '',
> `acct_status` tinyint(2) unsigned NOT NULL default 0,
> `verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin
> default NULL,
> `expiry_time` int unsigned NOT NULL default 0,
> `password_locked` tinyint(1) NOT NULL default 0,
> `password_expiry_time` int unsigned NOT NULL default 0,
> `last_seen_time` timestamp NOT NULL default "1970-01-01
> 00:00:00", ### TODO rename to date_last_visited
> `acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
> ### TODO rename to date_acct_created
> `conc_kwicview` tinyint(1) NOT NULL default 1,
> `conc_corpus_order` tinyint(1) NOT NULL default 1,
> `cqp_syntax` tinyint(1) NOT NULL default 0,
> `context_with_tags` tinyint(1) NOT NULL default 0,
> `use_tooltips` tinyint(1) NOT NULL default 1,
> `css_monochrome` tinyint(1) NOT NULL default 0,
> `thin_default_reproducible` tinyint(1) NOT NULL default 1,
> `coll_statistic` tinyint(2) unsigned NOT NULL default 0,
> ##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0
> ## the collocation prefs default to 0 because their defaults are set in
> config.php, and imported into new user records.
> `coll_freqtogether` smallint unsigned NOT NULL default 0,
> `coll_freqalone` smallint unsigned NOT NULL default 0,
> `coll_from` tinyint NOT NULL default 0,
> `coll_to` tinyint NOT NULL default 0,
> `max_dbsize` int unsigned default NULL,
> `freqlist_altstyle` tinyint(1) NOT NULL default 0,
> `linefeed` enum ("au", "a", "d", "da") NOT NULL,
> unique key (`username`),
> primary key (`id`)
> ) ENGINE=InnoDB
> /* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */
> "
> [2]=>
> string(57) "Error # 1067: Invalid default value for 'last_seen_time' "
> }
> [1]=>
> NULL
> [2]=>
> NULL
> }
> }
> [2]=>
> array(4) {
> ["file"]=>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
> ["line"]=>
> int(213)
> ["function"]=>
> string(18) "exiterror_sqlquery"
> ["args"]=>
> array(3) {
> [0]=>
> int(1067)
> [1]=>
> string(42) "Invalid default value for 'last_seen_time'"
> [2]=>
> string(2523) "CREATE TABLE `user_info` (
> `id` int unsigned NOT NULL AUTO_INCREMENT,
> `username` varchar(64) CHARSET ascii COLLATE ascii_bin
> NOT NULL,
> `realname` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `email` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `affiliation` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `country` char(2) CHARSET ascii COLLATE ascii_bin
> default '00',
> `passhash` char(61) CHARSET ascii COLLATE ascii_bin
> default '',
> `acct_status` tinyint(2) unsigned NOT NULL default 0,
> `verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin
> default NULL,
> `expiry_time` int unsigned NOT NULL default 0,
> `password_locked` tinyint(1) NOT NULL default 0,
> `password_expiry_time` int unsigned NOT NULL default 0,
> `last_seen_time` timestamp NOT NULL default "1970-01-01
> 00:00:00", ### TODO rename to date_last_visited
> `acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
> ### TODO rename to date_acct_created
> `conc_kwicview` tinyint(1) NOT NULL default 1,
> `conc_corpus_order` tinyint(1) NOT NULL default 1,
> `cqp_syntax` tinyint(1) NOT NULL default 0,
> `context_with_tags` tinyint(1) NOT NULL default 0,
> `use_tooltips` tinyint(1) NOT NULL default 1,
> `css_monochrome` tinyint(1) NOT NULL default 0,
> `thin_default_reproducible` tinyint(1) NOT NULL default 1,
> `coll_statistic` tinyint(2) unsigned NOT NULL default 0,
> ##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0
> ## the collocation prefs default to 0 because their defaults are set in
> config.php, and imported into new user records.
> `coll_freqtogether` smallint unsigned NOT NULL default 0,
> `coll_freqalone` smallint unsigned NOT NULL default 0,
> `coll_from` tinyint NOT NULL default 0,
> `coll_to` tinyint NOT NULL default 0,
> `max_dbsize` int unsigned default NULL,
> `freqlist_altstyle` tinyint(1) NOT NULL default 0,
> `linefeed` enum ("au", "a", "d", "da") NOT NULL,
> unique key (`username`),
> primary key (`id`)
> ) ENGINE=InnoDB
> /* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */"
> }
> }
> [3]=>
> array(4) {
> ["file"]=>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
> ["line"]=>
> int(1091)
> ["function"]=>
> string(12) "do_sql_query"
> ["args"]=>
> array(1) {
> [0]=>
> string(2523) "CREATE TABLE `user_info` (
> `id` int unsigned NOT NULL AUTO_INCREMENT,
> `username` varchar(64) CHARSET ascii COLLATE ascii_bin
> NOT NULL,
> `realname` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `email` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `affiliation` varchar(255) CHARSET utf8 COLLATE
> utf8_general_ci default '',
> `country` char(2) CHARSET ascii COLLATE ascii_bin
> default '00',
> `passhash` char(61) CHARSET ascii COLLATE ascii_bin
> default '',
> `acct_status` tinyint(2) unsigned NOT NULL default 0,
> `verify_key` varchar(32) CHARSET ascii COLLATE ascii_bin
> default NULL,
> `expiry_time` int unsigned NOT NULL default 0,
> `password_locked` tinyint(1) NOT NULL default 0,
> `password_expiry_time` int unsigned NOT NULL default 0,
> `last_seen_time` timestamp NOT NULL default "1970-01-01
> 00:00:00", ### TODO rename to date_last_visited
> `acct_create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
> ### TODO rename to date_acct_created
> `conc_kwicview` tinyint(1) NOT NULL default 1,
> `conc_corpus_order` tinyint(1) NOT NULL default 1,
> `cqp_syntax` tinyint(1) NOT NULL default 0,
> `context_with_tags` tinyint(1) NOT NULL default 0,
> `use_tooltips` tinyint(1) NOT NULL default 1,
> `css_monochrome` tinyint(1) NOT NULL default 0,
> `thin_default_reproducible` tinyint(1) NOT NULL default 1,
> `coll_statistic` tinyint(2) unsigned NOT NULL default 0,
> ##TODO,`key_statistic` tinyint(2) unsigned NOT NULL default 0
> ## the collocation prefs default to 0 because their defaults are set in
> config.php, and imported into new user records.
> `coll_freqtogether` smallint unsigned NOT NULL default 0,
> `coll_freqalone` smallint unsigned NOT NULL default 0,
> `coll_from` tinyint NOT NULL default 0,
> `coll_to` tinyint NOT NULL default 0,
> `max_dbsize` int unsigned default NULL,
> `freqlist_altstyle` tinyint(1) NOT NULL default 0,
> `linefeed` enum ("au", "a", "d", "da") NOT NULL,
> unique key (`username`),
> primary key (`id`)
> ) ENGINE=InnoDB
> /* from User: ??? | In file: @ line | 2019-Jul-09 11:38 */"
> }
> }
> [4]=>
> array(4) {
> ["file"]=>
> string(38) "/var/www/html/cqpweb/bin/autosetup.php"
> ["line"]=>
> int(94)
> ["function"]=>
> string(18) "do_sql_total_reset"
> ["args"]=>
> array(0) {
> }
> }
> }
> PHP Notice: Undefined property: NotAFullConfig::$Api in
> /var/www/html/cqpweb/lib/environment.php on line 1350
> PHP Fatal error: Uncaught Error: Call to undefined method
> NotAFullConfig::disconnect_slave_program() in
> /var/www/html/cqpweb/lib/environment.php:1354
> Stack trace:
> #0 /var/www/html/cqpweb/lib/exiterror-lib.php(284):
> cqpweb_shutdown_environment()
> #1 /var/www/html/cqpweb/lib/exiterror-lib.php(367): exiterror(Array, NULL,
> NULL)
> #2 /var/www/html/cqpweb/lib/sql-lib.php(213): exiterror_sqlquery(1067,
> 'Invalid default...', 'CREATE TABLE `u...')
> #3 /var/www/html/cqpweb/lib/sql-lib.php(1091): do_sql_query('CREATE TABLE
> `u...')
> #4 /var/www/html/cqpweb/bin/autosetup.php(94): do_sql_total_reset()
> #5 {main}
> thrown in /var/www/html/cqpweb/lib/environment.php on line 1354
>
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
--
Dr. Scott Sadowsky
Profesor Asistente de Lingüística
Pontificia Universidad Católica de Chile
ssadowsky gmail com
scsadowsky uc cl
http://sadowsky.cl/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190711/ba73005e/attachment-0001.html>
More information about the CWB
mailing list