[CWB] [CQPweb latest] SQL errores
Hardie, Andrew
a.hardie at lancaster.ac.uk
Thu Jul 11 07:24:02 CEST 2019
Will be fixed in next commit to the branch. Meanwhile, can I suggest just deleting line 37.
best
Andrew.
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Scott Sadowsky
Sent: 11 July 2019 06:06
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] [CQPweb latest] SQL errores
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<mailto: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<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto: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<mailto: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<mailto: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/d5b4dbf5/attachment-0001.html>
More information about the CWB
mailing list