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 ;

Canning the Can’ts - BD Foundation | Beyond Diversity

scared_lady_199097“I can’t sleep on the right side of the bed.”

“I can’t sleep with lights off.”

“I can’t drive.”

“I can’t dance.”

“I can’t go to crowded places.”

“I can’t go ahead after a black cat has crossed my path.”

“I can’t lose weight.”

“I can’t make it to Harvard.”

As you must have guessed, these are common statements one often hears all around. And you must have also realized that these are more of “I don’t think I can” statements than the literal “I can’t” ones. We are so used to hearing these kinds of statements that these don’t call for special attention and mostly leave us unaffected. Even our own. In reality though, they affect us big time.

These “can’t” statements are window to our inner world, if you will. Actually these are window to cobwebs in our inner world. Anybody who is a genuine seeker of truth or wants to be in touch with their core has to try at least a “why?”. Why can’t I sleep on a particular side of the bed? Why can’t I go into dark? And please, shrug is not a valid answer.

Don’t be fooled by their magnitude or level of impact on your life. Every “can’t” statement is a block. It could be as simple as – “I can’t step on sidewalk cracks while walking through the city”. (Remember Jack Nicholson in As Good as It Gets?) While it is convenient to dismiss smaller blocks, you should be aware that smaller blocks have this inordinate prowess to make you vulnerable to bigger ones. To put it into fancy new-age language: you become an easy “can’t”-er subconsciously.

Blocks block your growth to your highest potential as wholistic individual. That’s what blocks do, the name is a dead giveaway.

If you can logically explain a “can’t” of your life, and the explanation is acceptable to you, it’s fine. If you are sure there’s nothing that can be done to change the “can’t” to a “can” or you absolutely don’t want to change it, it’s fine too. You don’t have to justify to anybody else.

But there are some “can’t”s lurking in the back of our minds, which we know shouldn’t be there. We do our best to brush them under the mental carpet, or try to justify them unsatisfactorily, or feign complete ignorance of their existence. For these types of “can’t”s, there’s also this unmistakable nagging feeling that prompts us to take some action and refuses to be shushed. Somehow we learn to live with that feeling – because that’s easier than “canning” a “can’t”.

Or is it?

Here’s a simple step by step guide to reversing undesired “can’t”s that are bothering you:

  1. Bring your “can’t”s out in the open. List them all.
  2. Take a magnifying glass and study them thoroughly.
  3. List the ones you are not able to explain and are causing discomfort, however mild.
  4. See what you can do about those. Write down all possibilities. Take help, if required.

(You may want to refer to my previous article on Options.)

  1. Choose the best recourse.
  2. GO AND DO IT.

(If you say “can’t” to this one, repeat.)