WordPress database error: [Cannot add foreign key constraint] CREATE TABLE `wp_icwp_wpsf_ip_rules` (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary ID',
ip_ref int(11) UNSIGNED NOT NULL COMMENT 'Foreign Key For Primary ID',
cidr int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'CIDR',
is_range tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is IP Range',
offenses int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Offenses Count',
type char(2) NOT NULL DEFAULT '' COMMENT 'List',
label varchar(255) NOT NULL DEFAULT '' COMMENT 'IP Description',
last_access_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Access',
blocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'IP Blocked',
unblocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Visitor Requested Unblock',
last_unblock_attempt_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Time An Auto-Unblock Attempt Was Made',
expires_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The IP Rule on this lists expires at this time.',
updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Updated',
created_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Created',
deleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Soft Deleted',
PRIMARY KEY (id),
FOREIGN KEY (ip_ref) REFERENCES wp_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Cannot add foreign key constraint] CREATE TABLE `wp_icwp_wpsf_ip_rules` (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary ID',
ip_ref int(11) UNSIGNED NOT NULL COMMENT 'Foreign Key For Primary ID',
cidr int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'CIDR',
is_range tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Is IP Range',
offenses int(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Offenses Count',
type char(2) NOT NULL DEFAULT '' COMMENT 'List',
label varchar(255) NOT NULL DEFAULT '' COMMENT 'IP Description',
last_access_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Access',
blocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'IP Blocked',
unblocked_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Visitor Requested Unblock',
last_unblock_attempt_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Time An Auto-Unblock Attempt Was Made',
expires_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The IP Rule on this lists expires at this time.',
updated_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last Updated',
created_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Created',
deleted_at int(15) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Soft Deleted',
PRIMARY KEY (id),
FOREIGN KEY (ip_ref) REFERENCES wp_icwp_wpsf_ips(id) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
WordPress database error: [Table 'beyondiversity.wp_icwp_wpsf_ip_rules' doesn't exist] SELECT `ips`.`ip` as `ip`, `ir`.id, `ir`.ip_ref, `ir`.cidr, `ir`.is_range, `ir`.offenses, `ir`.type, `ir`.label, `ir`.last_access_at, `ir`.blocked_at, `ir`.unblocked_at, `ir`.last_unblock_attempt_at, `ir`.expires_at, `ir`.updated_at, `ir`.created_at, `ir`.deleted_at
FROM `wp_icwp_wpsf_ip_rules` as `ir`
INNER JOIN `wp_icwp_wpsf_ips` as `ips`
ON `ir`.ip_ref = `ips`.id
WHERE (`ips`.ip=INET6_ATON('3.238.90.95') AND `ir`.`is_range`='0') OR (`ir`.`is_range`='1')
ORDER BY `ir`.`created_at` DESC
;
Diversity Archives - BD Foundation | Beyond Diversity
Intel Ceo Brian Krzanich said in a conference of Grace Hopper Celebration of women in computing, “We all have unconscious gender bias”. The important words here are ‘We all…” And this includes leaders of the organizations as well. An EY paper on Unconscious Bias,...
I once asked in one of my talks – Do you think Men should be included in the Menstrual conversations? A girl raised hand and said yes. I asked why do you think so? She responded because the word MENstruation has MEN in it…:p While the entire class...
Middle Earth is in danger and there is a job to be done. A sinister, powerful ring to be destroyed. And Gandalf the Grey, in his infinite wisdom, entrusts the perilous job to a young, weak, innocent Hobbit called Frodo. Why? Because Hobbits, as a race, are known to...
A youngster wearing “ghungroos”, doing the Kathak in gay abandon in pouring rain A bike-riding modern young woman declaring that salwar-kameez is her choice of attire A Muslim woman lighting “diyas” and celebrating Diwali A young man proposing to another man Men in...
Behind every success—individual, team or company—there are people behind the scenes—supporting, encouraging and absorbing the extra stress themselves, thereby ensuring success. As organisations we have focused on what we can provide to our employees to support and...
