{"id":612,"date":"2024-07-04T13:25:10","date_gmt":"2024-07-04T13:25:10","guid":{"rendered":"https:\/\/ahorseforonebin.co.uk\/?p=612"},"modified":"2024-07-04T13:27:38","modified_gmt":"2024-07-04T13:27:38","slug":"flushing","status":"publish","type":"post","link":"https:\/\/ahorseforonebin.co.uk\/?p=612","title":{"rendered":"Flushing"},"content":{"rendered":"\n<p>I&#8217;ve experienced an anomaly on my random blog; the database shut comments after just a week, instead of on the 22 day rule I&#8217;d set.<\/p>\n\n\n\n<p>The first thing I did was look at every plugin and parent\/child theme for anything that could cause a conflict. That was an afternoon I&#8217;m never going to get back. But the long and short is there were no conflict-causes.<\/p>\n\n\n\n<p>I wondered if any of the largescale work I&#8217;d recently completed on the main website and shop might have impacted the blog, but the way I&#8217;ve set up the subdomain and separate databases for the core and the sub, threw that idea out.<\/p>\n\n\n\n<p>So than I cracked open the blog database and looked for a gash character or some other bad field and I found&#8230; Nothing. Not a sausage.<\/p>\n\n\n\n<p>Bizarre.<\/p>\n\n\n\n<p>So I flushed the database and ran a healthcheck on what the flushed database looked like compared to the unflushed version. A field-by-field comparison gave up no data issues, nothing looked out of order. But the flushed database was 2.3Mb smaller.<\/p>\n\n\n\n<p>Then I set a realtime comments test and the reaction to that was perfectly normal.<\/p>\n\n\n\n<p>So something in the DB which got flushed out? A gash character, a random value somewhere?<\/p>\n\n\n\n<p>I have no idea, and that&#8217;s *very* annoying.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed.png\"><img loading=\"lazy\" decoding=\"async\" width=\"942\" height=\"508\" src=\"https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed.png\" alt=\"\" class=\"wp-image-613\" srcset=\"https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed.png 942w, https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed-300x162.png 300w, https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed-768x414.png 768w, https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed-150x81.png 150w, https:\/\/ahorseforonebin.co.uk\/wp-content\/uploads\/2024\/07\/Flushed-250x135.png 250w\" sizes=\"auto, (max-width: 942px) 100vw, 942px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve experienced an anomaly on my random blog; the database shut comments after just a week, instead of on the 22 day rule I&#8217;d set. The first thing I did was look at every plugin and parent\/child theme for anything that could cause a conflict. That was an afternoon I&#8217;m \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/ahorseforonebin.co.uk\/?p=612\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-612","post","type-post","status-publish","format-standard","hentry","category-admin"],"_links":{"self":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=612"}],"version-history":[{"count":3,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/612\/revisions"}],"predecessor-version":[{"id":616,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/612\/revisions\/616"}],"wp:attachment":[{"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ahorseforonebin.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}