· 8 years ago · Jul 06, 2018, 10:28 PM
12012/03/14-23:22:48 [48581] info Started with [ /usr/bin/perl ./crawler.pl drop install ] version: 0.19.1_4770
22012/03/14-23:22:48 [48581] info Dropping wordstat banned querystat ranges host resource filestat filebase
32012/03/14-23:22:48 [48581] info install database prosearch = 0
42012/03/14-23:22:48 [48581] err SQL: error[1064,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`added` INT UNSIGNED NOT NULL DEFAULT '0' ,PRIMARY KEY (`id`),INDEX `prot_i` (' at line 1,syntax,42000] on executing {CREATE TABLE IF NOT EXISTS `filebase` (`id` BIGINT UNSIGNED AUTO_INCREMENT ,`prot` VARCHAR (5) DEFAULT '' ,`host` VARCHAR (64) DEFAULT '' ,`path` VARCHAR (130) DEFAULT '' ,`name` VARCHAR (93) DEFAULT '' ,`ext` VARCHAR (16) DEFAULT '' ,`type` INT UNSIGNED NOT NULL DEFAULT '0' ,`size` BIGINT UNSIGNED NOT NULL DEFAULT '0' ,`time` INT UNSIGNED NOT NULL DEFAULT '0' ,`desc` VARCHAR (20454) NOT NULL DEFAULT '' ,`meta` VARCHAR (1024) NOT NULL DEFAULT '' ,`scan` INT UNSIGNED NOT NULL DEFAULT '0' ,`dl` INT UNSIGNED NOT NULL DEFAULT '0' ,`voteu` INT UNSIGNED NOT NULL DEFAULT '0' ,`voted` INT UNSIGNED NOT NULL DEFAULT '0' ,`lastip` VARCHAR (15) NOT NULL DEFAULT '' ,`content` ,`added` INT UNSIGNED NOT NULL DEFAULT '0' ,PRIMARY KEY (`id`),INDEX `prot_i` (`prot`(3)),INDEX `host_i` (`host`(16)),INDEX `path_i` (`path`(128)),INDEX `name_i` (`name`(32)),INDEX `ext_i` (`ext`(8)),INDEX `size_i` (`size`),INDEX `time_i` (`time`),INDEX `scan_i` (`scan`),INDEX `dl_i` (`dl`),INDEX `voteu_i` (`voteu`),INDEX `voted_i` (`voted`),INDEX `lastip_i` (`lastip`),UNIQUE `uniq` (`prot`,`host`,`path`,`name`,`ext`)) ENGINE = MYISAM DELAY_KEY_WRITE=1 DEFAULT CHARACTER SET 'utf8' ;} [sleep:3600] dbh=[DBI::db=HASH(0x803270c30)]
52012/03/14-23:22:48 [48581] info tryweb #Result
6
72012/03/14-23:22:48 [48581] info Finished [ install drop ] [run time 0.536s ] [ sqlstat: connect_tried=1; connects=1; queries=17; queries_avg=0.002s;