[CWB] [CQPweb latest] SQL errores
Scott Sadowsky
ssadowsky at gmail.com
Tue Jul 9 16:55:20 CEST 2019
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190709/4945758b/attachment-0001.html>
More information about the CWB
mailing list