Skip to content

Instantly share code, notes, and snippets.

@luvhari
luvhari / query monitor results
Created April 30, 2020 16:34
14.0.4 query monitor report
Query- CREATE TABLE `wpf7_yoast_indexable` ( `id` int(11) UNSIGNED auto_increment NOT NULL, `permalink` mediumtext, `permalink_hash` varchar(191), `object_id` int(11) UNSIGNED, `object_type` varchar(32) NOT NULL, `object_sub_type` varchar(32), `author_id` int(11) UNSIGNED, `post_parent` int(11) UNSIGNED, `title` varchar(191), `description` text, `breadcrumb_title` varchar(191), `post_status` varchar(191), `is_public` tinyint(1), `is_protected` tinyint(1) DEFAULT '0', `has_public_posts` tinyint(1), `number_of_pages` int(11) UNSIGNED, `canonical` mediumtext, `primary_focus_keyword` varchar(191), `primary_focus_keyword_score` int(3), `readability_score` int(3), `is_cornerstone` tinyint(1) DEFAULT '0', `is_robots_noindex` tinyint(1) DEFAULT '0', `is_robots_nofollow` tinyint(1) DEFAULT '0', `is_robots_noarchive` tinyint(1) DEFAULT '0', `is_robots_noimageindex` tinyint(1) DEFAULT '0', `is_robots_nosnippet` tinyint(1) DEFAULT '0', `twitter_title` varchar(191), `twitter_image` mediumtext, `twitter_description` medium
@luvhari
luvhari / query monitor results
Created April 30, 2020 12:59
14.0.03 installed.
Query Caller Component Error Message Error Code
CREATE TABLE `wpf7_yoast_indexable` ( `id` int(11) UNSIGNED auto_increment NOT NULL, `permalink` mediumtext, `permalink_hash` varchar(191), `object_id` int(11) UNSIGNED, `object_type` varchar(32) NOT NULL, `object_sub_type` varchar(32), `author_id` int(11) UNSIGNED, `post_parent` int(11) UNSIGNED, `title` varchar(191), `description` text, `breadcrumb_title` varchar(191), `post_status` varchar(191), `is_public` tinyint(1), `is_protected` tinyint(1) DEFAULT '0', `has_public_posts` tinyint(1), `number_of_pages` int(11) UNSIGNED, `canonical` mediumtext, `primary_focus_keyword` varchar(191), `primary_focus_keyword_score` int(3), `readability_score` int(3), `is_cornerstone` tinyint(1) DEFAULT '0', `is_robots_noindex` tinyint(1) DEFAULT '0', `is_robots_nofollow` tinyint(1) DEFAULT '0', `is_robots_noarchive` tinyint(1) DEFAULT '0', `is_robots_noimageindex` tinyint(1) DEFAULT '0', `is_robots_nosnippet` tinyint(1) DEFAULT '0', `twitter_title` varchar(191), `twitter_image`
@luvhari
luvhari / gist:35c4ebec03f9616d00b0a418fd2c7208
Created April 30, 2020 12:19
db error in query monitor
Query- CREATE TABLE `wpf7_yoast_indexable` ( `id` int(11) UNSIGNED auto_increment NOT NULL, `permalink` mediumtext, `permalink_hash` varchar(191), `object_id` int(11) UNSIGNED, `object_type` varchar(32) NOT NULL, `object_sub_type` varchar(32), `author_id` int(11) UNSIGNED, `post_parent` int(11) UNSIGNED, `title` varchar(191), `description` text, `breadcrumb_title` varchar(191), `post_status` varchar(191), `is_public` tinyint(1), `is_protected` tinyint(1) DEFAULT '0', `has_public_posts` tinyint(1), `number_of_pages` int(11) UNSIGNED, `canonical` mediumtext, `primary_focus_keyword` varchar(191), `primary_focus_keyword_score` int(3), `readability_score` int(3), `is_cornerstone` tinyint(1) DEFAULT '0', `is_robots_noindex` tinyint(1) DEFAULT '0', `is_robots_nofollow` tinyint(1) DEFAULT '0', `is_robots_noarchive` tinyint(1) DEFAULT '0', `is_robots_noimageindex` tinyint(1) DEFAULT '0', `is_robots_nosnippet` tinyint(1) DEFAULT '0', `twitter_title` varchar(191), `twitter_image` mediumtext, `twitter_description` me