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 ;

Gagan Singh - BD Foundation | Beyond Diversity

Consultant, Anarock Property Consultants, Salaam Baalak and others

Gagan is an Independent Director on the boards of Timex Group and Future Retail Ltd. She heads the Audit Committees of both Companies and is an consultant to Anuj Puri’s Anarock Property Services Pvt. Ltd.

She considers herself to be a general management expert and have consistently achieved success in reviving businesses that are in trouble or need to scale up through better processes and rhythm. She manages to make dysfunctional teams work better together.

Gagan retired from Jones Lang LaSalle India in March 2017 where she worked for 10 years as CEO. She joined JLL in May 2007, to oversee the integration of the merger of Jones Lang LaSalle with Meghraj which created India’s largest real estate services firm . She led the Projects and Development Services business for India from 2008 to 2012 which more than doubled its revenue under her leadership.

She started the Sri Lanka business in 2011 and led it successfully for 5 years. She set up the SEZ Shared Service Operations 2012 which is now poised to grow to a 1500 headcount by 2019. Gagan initiated and led the CSR and Diversity & Inclusion agendas for India and also implemented the Ethics program for the Company.

She has over 30 years of experience across the apparel, exports and hospitality sectors. Prior to JLL, she was with Benetton India for over 6 years as Executive Director, and was appointed CEO in 2005.  Gagan spent 14 years from 1982 to 1995 in Nepal with the Soaltee Group, the leading conglomerate of Nepal.

She enjoys theatre, interior design & travel and is a trustee since 1999 of Salaam Baalak Trust, an NGO, working with street and working children and the founding Vice President of Youthreach, an NGO.

Skills

Posted on

2015-10-27

Submit a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.