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 ;

Dev Deepika, Author at BD Foundation | Beyond Diversity

Battle with the Bulge

Some of us are in this constant endeavor of balancing the calorie intake and motivate ourselves to lose a few kilos. While a few have successfully managed the balance, some will always be on this path with the hope to strike the balance sooner rather than later. With...
Create Distractions

Create Distractions

“Create Distractions”, these words still ring in my ears loud and clear. Not sure how much do I really remember and can spell out from the various lectures and class-room sessions that I have attended. But these words are etched in my memory. Some professors leave an...
‘Me-Time’… It’s Now or Never!!

‘Me-Time’… It’s Now or Never!!

“One day you will wake up and there won’t be any more time to do the things you’ve always wanted.” ~ Paulo Coelho. I was amazed to see how this small but profound message, which a friend sent early one morning, created the ripple effects and made that small huge...
Making the ‘G’ disappear…

Making the ‘G’ disappear…

It was once again the same thought knocking in my mind, this would happen time and again – the alphabet ‘G’ was trying to make noise in the loudest possible manner and was dancing in-front of my eyes in absolute bold. I realized this was happening very often. I was...