[ 29] Opened mysql connection to localhost
[ 30] !WARN! PERL: _ListTables is deprecated, use $dbh->tables() at /usr/lib/perl5/DBD/mysql.pm line 368.
[ 31] Tables: 0
[ 32] checkTables: creating new table botmail...
[ 33] !WARN! PERL: DBD::mysql::st execute failed: Invalid default value for 'time' at ./src/dbi.pl line 440, <IN> line 8.
[ 34] !ERROR! Raw(sqlCreateTable(botmail)): !execute => 'CREATE TABLE botmail ( srcwho VARCHAR(20) NOT NULL, dstwho VARCHAR(20) NOT NULL, srcuh VARCHAR(80) NOT NULL, time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()', msg TEXT NOT NULL, PRIMARY KEY (srcwho,dstwho));'
[ 35] checkTables: creating new table connections...
[ 36] !WARN! PERL: DBD::mysql::st execute failed: Invalid default value for 'ircname' at ./src/dbi.pl line 440, <IN> line 17.
[ 37] !ERROR! Raw(sqlCreateTable(connections)): !execute => 'CREATE TABLE connections ( server VARCHAR(30) NOT NULL, port INT NOT NULL DEFAULT '6667', nick VARCHAR(20) NOT NULL, nickservpass VARCHAR(8) NOT NULL, ircname VARCHAR (20) NOT NULL DEFAULT 'infobot experimental bot', timeadded INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()', PRIMARY KEY (server,port,nick));'
[ 38] checkTables: creating new table factoids...
[ 39] checkTables: creating new table rootwarn...
[ 40] checkTables: creating new table seen...
[ 41] checkTables: creating new table stats...
[ 42] !WARN! PERL: DBD::mysql::st execute failed: Invalid default value for 'time' at ./src/dbi.pl line 440, <IN> line 55.
[ 43] !ERROR! Raw(sqlCreateTable(stats)): !execute => 'CREATE TABLE stats ( nick VARCHAR(20) NOT NULL, type VARCHAR(8) NOT NULL, channel VARCHAR(30) NOT NULL DEFAULT "PRIVATE", time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()', counter SMALLINT UNSIGNED DEFAULT '0', PRIMARY KEY (nick,type,channel));'
[ 44] checkTables: creating new table onjoin...