a:61:{i:0;a:3:{i:0;i:1;i:1;s:40:"Plugin activated at 2025-03-23 14:58:35.";i:2;N;}i:1;a:3:{i:0;i:1;i:1;s:27:"Installation/update begins.";i:2;N;}i:2;a:3:{i:0;i:1;i:1;s:25:"Upgrading the database...";i:2;N;}i:3;a:3:{i:0;i:1;i:1;s:31:"... SHOW TABLES (0.002 seconds)";i:2;N;}i:4;a:3:{i:0;i:1;i:1;s:260:" [OK] 
	CREATE TABLE IF NOT EXISTS `wpka_blc_filters` (
		`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`name` varchar(100) NOT NULL,
		`params` text NOT NULL,

		PRIMARY KEY (`id`)
	) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci (0.355 seconds)";i:2;N;}i:5;a:3:{i:0;i:1;i:1;s:707:" [OK] 

	CREATE TABLE IF NOT EXISTS `wpka_blc_instances` (
		`instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`link_id` int(10) unsigned NOT NULL,
		`container_id` int(10) unsigned NOT NULL,
		`container_type` varchar(40) NOT NULL DEFAULT 'post',
		`link_text` text NOT NULL DEFAULT '',
		`parser_type` varchar(40) NOT NULL DEFAULT 'link',
		`container_field` varchar(250) NOT NULL DEFAULT '',
		`link_context` varchar(250) NOT NULL DEFAULT '',
		`raw_url` text NOT NULL,

		PRIMARY KEY (`instance_id`),
		KEY `link_id` (`link_id`),
		KEY `source_id` (`container_type`, `container_id`),
		KEY `parser_type` (`parser_type`)
	) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci (0.333 seconds)";i:2;N;}i:6;a:3:{i:0;i:1;i:1;s:1594:" [OK] 

	CREATE TABLE IF NOT EXISTS `wpka_blc_links` (
		`link_id` int(20) unsigned NOT NULL AUTO_INCREMENT,
		`url` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
		`first_failure` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`last_success` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`last_check_attempt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
		`check_count` int(4) unsigned NOT NULL DEFAULT '0',
		`final_url` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
		`redirect_count` smallint(5) unsigned NOT NULL DEFAULT '0',
		`log` text NOT NULL,
		`http_code` smallint(6) NOT NULL DEFAULT '0',
		`status_code` varchar(100) DEFAULT '',
		`status_text` varchar(250) DEFAULT '',
		`request_duration` float NOT NULL DEFAULT '0',
		`timeout` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`broken` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`warning` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`may_recheck` tinyint(1) NOT NULL DEFAULT '1',
		`being_checked` tinyint(1) NOT NULL DEFAULT '0',

		`result_hash` varchar(200) NOT NULL DEFAULT '',
		`false_positive` tinyint(1) NOT NULL DEFAULT '0',
		`dismissed` tinyint(1) NOT NULL DEFAULT '0',

		PRIMARY KEY (`link_id`),
		KEY `url` (`url`(150)),
		KEY `final_url` (`final_url`(150)),
		KEY `http_code` (`http_code`),
		KEY `broken` (`broken`),
		KEY `last_check_attempt` (`last_check_attempt`),
		KEY `may_recheck` (`may_recheck`),
		KEY `check_count` (`check_count`)

	) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci (0.466 seconds)";i:2;N;}i:7;a:3:{i:0;i:1;i:1;s:399:" [OK] 

	CREATE TABLE IF NOT EXISTS `wpka_blc_synch` (
		`container_id` int(20) unsigned NOT NULL,
		`container_type` varchar(40) NOT NULL,
		`synched` tinyint(2) unsigned NOT NULL,
		`last_synch` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

		PRIMARY KEY (`container_type`,`container_id`),
		KEY `synched` (`synched`)
	) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci (0.232 seconds)";i:2;N;}i:8;a:3:{i:0;i:1;i:1;s:32:"Schema update took 1.391 seconds";i:2;N;}i:9;a:3:{i:0;i:1;i:1;s:24:"Database schema updated.";i:2;N;}i:10;a:3:{i:0;i:1;i:1;s:31:"Database successfully upgraded.";i:2;N;}i:11;a:3:{i:0;i:1;i:1;s:24:"--- Total: 1.400 seconds";i:2;N;}i:12;a:3:{i:0;i:1;i:1;s:27:"Cleaning up the database...";i:2;N;}i:13;a:3:{i:0;i:1;i:1;s:38:"... Deleting invalid container records";i:2;N;}i:14;a:3:{i:0;i:0;i:1;s:44:"... 0 synch records deleted in 0.002 seconds";i:2;N;}i:15;a:3:{i:0;i:1;i:1;s:35:"... Deleting invalid link instances";i:2;N;}i:16;a:3:{i:0;i:0;i:1;s:40:"... 0 instances deleted in 0.002 seconds";i:2;N;}i:17;a:3:{i:0;i:0;i:1;s:45:"... 0 more instances deleted in 0.001 seconds";i:2;N;}i:18;a:3:{i:0;i:1;i:1;s:27:"... Deleting orphaned links";i:2;N;}i:19;a:3:{i:0;i:0;i:1;s:36:"... 0 links deleted in 0.002 seconds";i:2;N;}i:20;a:3:{i:0;i:1;i:1;s:24:"--- Total: 0.006 seconds";i:2;N;}i:21;a:3:{i:0;i:1;i:1;s:20:"Notifying modules...";i:2;N;}i:22;a:3:{i:0;i:0;i:1;s:25:"... Updating module cache";i:2;N;}i:23;a:3:{i:0;i:1;i:1;s:36:"... Cache refresh took 0.000 seconds";i:2;N;}i:24;a:3:{i:0;i:0;i:1;s:19:"... Loading modules";i:2;N;}i:25;a:3:{i:0;i:1;i:1;s:37:"... 6 modules loaded in 0.001 seconds";i:2;N;}i:26;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "http"";i:2;N;}i:27;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "link"";i:2;N;}i:28;a:3:{i:0;i:0;i:1;s:28:"... Notifying module "image"";i:2;N;}i:29;a:3:{i:0;i:0;i:1;s:31:"... Notifying module "metadata"";i:2;N;}i:30;a:3:{i:0;i:0;i:1;s:32:"... Notifying module "url_field"";i:2;N;}i:31;a:3:{i:0;i:0;i:1;s:30:"... Notifying module "comment"";i:2;N;}i:32;a:3:{i:0;i:0;i:1;s:51:"...... Deleting synch. records for removed comments";i:2;N;}i:33;a:3:{i:0;i:0;i:1;s:38:"...... 0 rows deleted in 0.001 seconds";i:2;N;}i:34;a:3:{i:0;i:0;i:1;s:47:"...... Creating synch. records for new comments";i:2;N;}i:35;a:3:{i:0;i:0;i:1;s:41:"...... 643 rows inserted in 0.040 seconds";i:2;N;}i:36;a:3:{i:0;i:0;i:1;s:26:"... Notifying module "acf"";i:2;N;}i:37;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "post"";i:2;N;}i:38;a:3:{i:0;i:0;i:1;s:74:"...... Deleting synch records for removed posts & post with invalid status";i:2;N;}i:39;a:3:{i:0;i:0;i:1;s:2978:"DELETE synch.* FROM wpka_blc_synch AS synch WHERE synch.container_id NOT IN ('2584', '2577', '2571', '2564', '2557', '2550', '2542', '2535', '2526', '2519', '2511', '2506', '2499', '2491', '2485', '2478', '2471', '2462', '2454', '2447', '2439', '2431', '2424', '2417', '2409', '2401', '2392', '2382', '2374', '2366', '2358', '2347', '2338', '2328', '2321', '2310', '2296', '2290', '2282', '2275', '2266', '2257', '2251', '2244', '2236', '2221', '2213', '2206', '2199', '2192', '2185', '2176', '2169', '2163', '2157', '2149', '2141', '2128', '2121', '2115', '2107', '2099', '2087', '2071', '2061', '2041', '2028', '1994', '1984', '1978', '1961', '1946', '1922', '1904', '1880', '1853', '1835', '1820', '1795', '1779', '1769', '1749', '1738', '1726', '1715', '1704', '1693', '1684', '1676', '1666', '1657', '1642', '1634', '1626', '1619', '1610', '1601', '1595', '1587', '1580', '1572', '1565', '1559', '1551', '1541', '1532', '1524', '1518', '1512', '1503', '1497', '1490', '1484', '1477', '1471', '1459', '1453', '1447', '1440', '1430', '1421', '1414', '1386', '1379', '1372', '1359', '1350', '1344', '1337', '1328', '1317', '1311', '1301', '1294', '1287', '1278', '1270', '1262', '1254', '1247', '1241', '1232', '1202', '1195', '1187', '1181', '1173', '1166', '1156', '1150', '1137', '1130', '1124', '1116', '1109', '1103', '1098', '1092', '1084', '1076', '1069', '1064', '1057', '1054', '1050', '1046', '1042', '1035', '1030', '1022', '1018', '1014', '995', '992', '989', '986', '948', '941', '937', '933', '930', '927', '918', '915', '911', '908', '891', '889', '890', '888', '887', '872', '874', '870', '871', '873', '854', '855', '856', '857', '853', '825', '824', '822', '831', '823', '776', '773', '738', '286', '283', '280', '277', '271', '268', '265', '262', '259', '256', '253', '250', '246', '244', '240', '238', '235', '230', '227', '224', '221', '217', '214', '211', '3', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '160', '161', '162', '163', '164', '165', '166', '167', '168', '169', '170', '171', '172', '173', '174', '175', '176')";i:2;N;}i:40;a:3:{i:0;i:0;i:1;s:40:"...... 546 rows deleted in 0.038 seconds";i:2;N;}i:41;a:3:{i:0;i:0;i:1;s:41:"...... Marking changed posts as unsynched";i:2;N;}i:42;a:3:{i:0;i:0;i:1;s:224:"UPDATE
					wpka_blc_synch AS synch
					JOIN wpka_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)
				  SET
					synched = 0
				  WHERE
					synch.last_synch < posts.post_modified";i:2;N;}i:43;a:3:{i:0;i:0;i:1;s:38:"...... 0 rows updated in 0.002 seconds";i:2;N;}i:44;a:3:{i:0;i:0;i:1;s:43:"...... Creating synch records for new posts";i:2;N;}i:45;a:3:{i:0;i:0;i:1;s:395:"INSERT INTO wpka_blc_synch(container_id, container_type, synched)
				  SELECT posts.id, posts.post_type, 0
				  FROM
				    wpka_posts AS posts LEFT JOIN wpka_blc_synch AS synch
					ON (synch.container_id = posts.ID and synch.container_type=posts.post_type)
				  WHERE
				  	posts.post_status IN ('publish')
	 				AND posts.post_type IN ('post', 'page')
					AND synch.container_id IS NULL";i:2;N;}i:46;a:3:{i:0;i:0;i:1;s:41:"...... 404 rows inserted in 0.041 seconds";i:2;N;}i:47;a:3:{i:0;i:0;i:1;s:27:"... Notifying module "page"";i:2;N;}i:48;a:3:{i:0;i:0;i:1;s:74:"...... Skipping "page" resyncyh since all post types were already synched.";i:2;N;}i:49;a:3:{i:0;i:0;i:1;s:38:"... Notifying module "youtube-checker"";i:2;N;}i:50;a:3:{i:0;i:0;i:1;s:37:"... Notifying module "youtube-iframe"";i:2;N;}i:51;a:3:{i:0;i:0;i:1;s:28:"... Notifying module "dummy"";i:2;N;}i:52;a:3:{i:0;i:1;i:1;s:24:"--- Total: 0.158 seconds";i:2;N;}i:53;a:3:{i:0;i:1;i:1;s:38:"Updating server load limit settings...";i:2;N;}i:54;a:3:{i:0;i:1;i:1;s:59:"Set server load limit to 8.00. Current load average is 6.39";i:2;N;}i:55;a:3:{i:0;i:1;i:1;s:26:"Optimizing the database...";i:2;N;}i:56;a:3:{i:0;i:1;i:1;s:24:"--- Total: 1.983 seconds";i:2;N;}i:57;a:3:{i:0;i:1;i:1;s:26:"Completing installation...";i:2;N;}i:58;a:3:{i:0;i:1;i:1;s:20:"Configuration saved.";i:2;N;}i:59;a:3:{i:0;i:1;i:1;s:78:"Installation/update completed at 2025-03-23 14:58:38 with 36 queries executed.";i:2;N;}i:60;a:3:{i:0;i:1;i:1;s:25:"Total time: 3.690 seconds";i:2;N;}}