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 ;

Prabhjeet Singh - BD Foundation | Beyond Diversity

Director – Operations and Head of Cities, Uber

Prabhjeet is the Business Head for Uber across all cities in India and South Asia. In his role, he looks after the Operations and Products across all 45+ cities in the region.

Over the last 3 years, he has built Uber grounds up in the region helping it grow multiple X and unleashing the magic of technology in one of the toughest markets globally. In the process, he has helped Uber adapt its business model to India, lead several India first innovations and has built the foundation for multiple new businesses in future. An ex McKinsey Associate Partner, Prabh has worked with several iconic clients to help design their digital businesses particularly in financial services and consumer space. A best outgoing all-rounder from IIMA and Engineer from IIT Kharagpur, Prabhjeet and his wife Sucheta, the better half and a successful CXO, stay in Gurgaon with their 2 daughters.

Skills

Posted on

2019-08-08