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
;
Rajeev Raju, Author at BD Foundation | Beyond Diversity
Once again, I found myself at a day-long conference where corporate HR leaders, consultants, learning and development professionals and executive coaches mingled and shared ideas and opinions. Before the event commenced, I was in a conversation with the HR Head of a...
“Why is no one offering me a job? What do I do next as I don’t want to continue doing the same thing? Can I do something entirely different from what my career has been focused on so far? Why can I not be hired for my strengths and not based only on my past...
“Boss, we have an issue…what do we do?” A familiar conversation played out daily in a Manager’s work day. Empirical evidence shows that, 9 out of 10 Managers go pat with “I suggest you do this…” or even more directly, “Just call X and ask them to….” These are...
A senior technology leader recently lamented, “I am tired of routine meetings and pointless discussions. In many cases, I realised I was adding no significant value to most of these FYIs. I seem to have no time left for doing strategic work.” Leaders...
Ever been to a meeting lately and wondered why a few attendees never spoke a word? Ever been to meetings and wondered why these attendees never speak at all? Ever wondered why some of these attendees are there in the first place?! Worse still, ever wondered if...
