peremr
Forum Replies Created
Viewing 1 replies (of 1 total)
-
Forum: Plugins
In reply to: [Broken Link Checker] ERROR: Database error : COLLATIONSame result with 1.11.9 :
hers the installation log:Plugin activated at 2020-09-23 11:15:33. Installation/update begins. Upgrading the database... ... SHOW TABLES (0.001 seconds) [ ] CREATE TABLE IF NOT EXISTSwp_blc_filters(idint(10) unsigned NOT NULL AUTO_INCREMENT,namevarchar(100) NOT NULL,paramstext NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1' [ ] CREATE TABLE IF NOT EXISTSwp_blc_instances(instance_idint(10) unsigned NOT NULL AUTO_INCREMENT,link_idint(10) unsigned NOT NULL,container_idint(10) unsigned NOT NULL,container_typevarchar(40) NOT NULL DEFAULT 'post',link_texttext NOT NULL DEFAULT '',parser_typevarchar(40) NOT NULL DEFAULT 'link',container_fieldvarchar(250) NOT NULL DEFAULT '',link_contextvarchar(250) NOT NULL DEFAULT '',raw_urltext NOT NULL, PRIMARY KEY (instance_id), KEYlink_id(link_id), KEYsource_id(container_type,container_id), KEYparser_type(parser_type) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1' [ ] CREATE TABLE IF NOT EXISTSwp_blc_links(link_idint(20) unsigned NOT NULL AUTO_INCREMENT,urltext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,first_failuredatetime NOT NULL DEFAULT '0000-00-00 00:00:00',last_checkdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',last_successdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',last_check_attemptdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',check_countint(4) unsigned NOT NULL DEFAULT '0',final_urltext CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,redirect_countsmallint(5) unsigned NOT NULL DEFAULT '0',logtext NOT NULL,http_codesmallint(6) NOT NULL DEFAULT '0',status_codevarchar(100) DEFAULT '',status_textvarchar(250) DEFAULT '',request_durationfloat NOT NULL DEFAULT '0',timeouttinyint(1) unsigned NOT NULL DEFAULT '0',brokentinyint(1) unsigned NOT NULL DEFAULT '0',warningtinyint(1) unsigned NOT NULL DEFAULT '0',may_rechecktinyint(1) NOT NULL DEFAULT '1',being_checkedtinyint(1) NOT NULL DEFAULT '0',result_hashvarchar(200) NOT NULL DEFAULT '',false_positivetinyint(1) NOT NULL DEFAULT '0',dismissedtinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (link_id), KEYurl(url(150)), KEYfinal_url(final_url(150)), KEYhttp_code(http_code), KEYbroken(broken) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1' [ ] CREATE TABLE IF NOT EXISTSwp_blc_synch(container_idint(20) unsigned NOT NULL,container_typevarchar(40) NOT NULL,synchedtinyint(2) unsigned NOT NULL,last_synchdatetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (container_type,container_id), KEYsynched(synched) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1' Schema update took 0.002 seconds Database schema updated.- This reply was modified 5 years, 6 months ago by Yui. Reason: please use CODE button for proper formatting
Viewing 1 replies (of 1 total)