@subiewrx I can confirm that I see this same issue on both 4.1.9.3 and 4.1.9.4. In my case the issue is the limit_modified_date value is ending up blank in the database query. If I save a post with the “Don’t update the modified date” checked it saves the SEO data fine. If I have that unchecked it fails for all post types, including pages.
This is the error from the error log. You can see limit_modified_date = ” in there. Which is causing the error.
[30-Mar-2022 17:15:35 UTC] WordPress database error Incorrect integer value: '' for columnsite-2019.fb_aioseo_posts.limit_modified_date` at row 1 for query UPDATE fb_aioseo_posts
SET id = ‘1854’, post_id = 1288, title = ‘Learn About Us | #site_title’, description = ‘Trying once more a custom meta description.’, keywords = ‘[]’, keyphrases = ‘{\”focus\”:[],\”additional\”:[]}’, page_analysis = ‘{\”analysis\”:{\”basic\”:{\”metadescriptionLength\”:{\”title\”:\”Meta description length\”,\”description\”:\”The meta description is too short.\”,\”score\”:6,\”maxScore\”:9,\”error\”:1},\”lengthContent\”:{\”title\”:\”Content length\”,\”description\”:\”This is far below the recommended minimum of words.\”,\”score\”:-20,\”maxScore\”:9,\”error\”:1},\”isInternalLink\”:{\”title\”:\”Internal links\”,\”description\”:\”We couldn\’t find any internal links in your content. Add internal links in your content.\”,\”score\”:3,\”maxScore\”:9,\”error\”:1},\”isExternalLink\”:{\”title\”:\”External links\”,\”description\”:\”No outbound links were found. Link out to external resources.\”,\”score\”:3,\”maxScore\”:9,\”error\”:1},\”errors\”:4},\”title\”:{\”titleLength\”:{\”title\”:\”SEO Title length\”,\”description\”:\”The title is too short.\”,\”score\”:6,\”maxScore\”:9,\”error\”:1},\”errors\”:1},\”readability\”:{\”contentHasAssets\”:{\”error\”:1,\”title\”:\”Images\\/videos in content\”,\”description\”:\”You are not using rich media like images or videos.\”,\”score\”:1,\”maxScore\”:5},\”paragraphLength\”:{\”title\”:\”Paragraphs length\”,\”description\”:\”You are using short paragraphs.\”,\”score\”:5,\”maxScore\”:5,\”error\”:0},\”sentenceLength\”:{\”title\”:\”Sentences length\”,\”description\”:\”Sentence length is looking great!\”,\”score\”:9,\”maxScore\”:9,\”error\”:0},\”passiveVoice\”:{\”title\”:\”Passive voice\”,\”description\”:\”You\’re using enough active voice. That\’s great!\”,\”score\”:9,\”maxScore\”:9,\”error\”:0},\”transitionWords\”:[],\”consecutiveSentences\”:{\”title\”:\”Consecutive sentences\”,\”description\”:\”There is enough variety in your sentences. That\’s great!\”,\”score\”:9,\”maxScore\”:9,\”error\”:0},\”subheadingsDistribution\”:{\”title\”:\”Subheading distribution\”,\”description\”:\”You are not using any subheadings, but your text is short enough and probably doesn\’t need them.\”,\”score\”:9,\”maxScore\”:9,\”error\”:0},\”calculateFleschReading\”:{\”title\”:\”Flesch reading ease\”,\”description\”:\”The copy scores 0 in the test, which is considered very difficult to read. Try to make shorter sentences, using less difficult words to improve readability.\”,\”score\”:3,\”maxScore\”:9,\”error\”:1},\”errors\”:2}}}’, canonical_url = NULL, og_title = NULL, og_description = NULL, og_object_type = ‘activity’, og_image_type = ‘default’, og_image_url = NULL, og_image_width = NULL, og_image_height = NULL, og_image_custom_url = NULL, og_image_custom_fields = NULL, og_video = ”, og_custom_url = NULL, og_article_section = NULL, og_article_tags = ‘[]’, twitter_use_og = 0, twitter_card = ‘summary’, twitter_image_type = ‘default’, twitter_image_url = NULL, twitter_image_custom_url = NULL, twitter_image_custom_fields = NULL, twitter_title = NULL, twitter_description = NULL, seo_score = ’64’, schema_type = ‘none’, schema_type_options = ‘{\”article\”:{\”articleType\”:\”BlogPosting\”},\”course\”:{\”name\”:\”\”,\”description\”:\”\”,\”provider\”:\”\”},\”faq\”:{\”pages\”:[]},\”product\”:{\”reviews\”:[]},\”recipe\”:{\”ingredients\”:[],\”instructions\”:[],\”keywords\”:[]},\”software\”:{\”reviews\”:[],\”operatingSystems\”:[]},\”webPage\”:{\”webPageType\”:\”WebPage\”},\”book\”:[],\”event\”:[],\”jobPosting\”:[],\”music\”:[],\”person\”:[],\”restaurant\”:[],\”service\”:[],\”video\”:[]}’, pillar_content = 0, robots_default = 1, robots_noindex = 0, robots_noarchive = 0, robots_nosnippet = 0, robots_nofollow = 0, robots_noimageindex = 0, robots_noodp = 0, robots_notranslate = 0, robots_max_snippet = -1, robots_max_videopreview = -1, robots_max_imagepreview = ‘large’, tabs = ‘{\”tab\”:\”general\”,\”tab_social\”:\”facebook\”,\”tab_sidebar\”:\”general\”,\”tab_modal\”:\”general\”,\”tab_modal_social\”:\”facebook\”}’, images = NULL, image_scan_date = ‘2021-01-14 17:17:58’, priority = ‘default’, frequency = ‘default’, videos = NULL, video_thumbnail = NULL, video_scan_date = NULL, location = NULL, local_seo = NULL, limit_modified_date = ”, updated = ‘2022-03-30 17:15:35’
WHERE 1 = 1 AND
id = ‘1854’
/* 1 = 1 */ made by AIOSEO\Plugin\Common\Utils\Database::run`
