Okay, so here’s the scoop. Sometime after things get actually saved into database (posts, comments), but before the rebuild occurs or is completed, the process errors out:<\/p>\n
The site error log gets:<\/p>\n
PHP Warning: Cannot modify header information – headers already sent by (output started at \/home\/dave\/public_html\/blog\/mt\/php\/extlib\/ezsql\/ezsql_mysql.php:109) in \/home\/dave\/public_html\/blog\/mt\/php\/mt.php on line 554<\/p><\/blockquote>\n
On screen, I’ll get something slightly expanded:<\/p>\n
SQL\/DB Error — [Got error 12 from storage engine]<\/p>\n
Warning: Cannot modify header information – headers already sent by (output started at \/home\/dave\/public_html\/blog\/mt\/php\/extlib\/ezsql\/ezsql_mysql.php:109) in \/home\/dave\/public_html\/blog\/mt\/php\/mt.php on line 554<\/p>\n
The requested page could not be found.<\/p>\n
Cannot modify header information – headers already sent by (output started at \/home\/dave\/public_html\/blog\/mt\/php\/extlib\/ezsql\/ezsql_mysql.php:109)\n<\/p><\/blockquote>\n
If I go to manually save a post, sometimes (not always) I get:<\/p>\n
\nAn error occurred:<\/p>\n
Can’t call method “prepare” on an undefined value at lib\/MT\/ObjectDriver\/DBI.pm line 103. at lib\/MT.pm line 867<\/p>\n
Content-Type: text\/plain; charset=utf-8 Got an error: Can’t call method “prepare” on an undefined value at lib\/MT\/ObjectDriver\/DBI.pm line 103. at lib\/MT\/App\/CMS.pm line 870<\/p>\n<\/blockquote>\n
I’ve done some research via Google on this, but not getting diddlysquat.<\/p>\n
Meantime, comments (and posts) are <\/em>being saved. They’re just not necessarily showing up at the site yet. Going to do a bit more research, and go after some support options.<\/p>\n
UPDATE<\/strong>: Went both to the MT support line and the Hosting Matters one. That got me looking at the MySQL DB checking tools — which revealed my MT tables were riddled with “warning : 46 clients are using or haven’t closed the table properly” types of errors. Managed to force a Repair through after a couple of tries for everything except the mt_plugindata table, which we’re checking out. At the moment, though, there are still odd errors showing up when you open a post (mostly around categories), and any post that has any comments in it is not opening at all. *sigh*<\/p>\n
This error also affects WIST, Blog of Heroes, Doing Write, and BoulderDude’s site.<\/p>\n","protected":false},"excerpt":{"rendered":"
Okay, so here’s the scoop. Sometime after things get actually saved into database (posts, comments), but before the rebuild occurs or is completed, the process errors out: The site error…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-11553","post","type-post","status-publish","format-standard","hentry","category-blogging"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6272,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/09\/29\/dynamic_publish.html","url_meta":{"origin":11553,"position":0},"title":"Dynamic publishing in MT3","author":"***Dave","date":"Wed 29-Sep-04 9:52am","format":false,"excerpt":"One of my major reasons for taking the MT 3.11 plunge is the prospect of dynamic publishing -- that a blog page gets rendered on the fly when you go...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8825,"url":"https:\/\/hill-kleerup.org\/blog\/2006\/04\/10\/please_stand_by.html","url_meta":{"origin":11553,"position":1},"title":"Please stand by — we are experiencing technical difficulties","author":"***Dave","date":"Mon 10-Apr-06 2:14pm","format":false,"excerpt":"Getting Error 500 glitches on the site for folks trying to file comments here. Apologies to anyone who's run into that -- I'm trying to dig into it, but my...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6239,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/10\/04\/mt_dynamic_publ.html","url_meta":{"origin":11553,"position":2},"title":"MT dynamic publishing notes (yet again)","author":"***Dave","date":"Mon 4-Oct-04 2:00pm","format":false,"excerpt":"Okay, here's the good news: I figured out what was wrong with the dynamic publishing options I had set for my main blog (this one). In my IDC blog (\/blog\/idc\/),...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6270,"url":"https:\/\/hill-kleerup.org\/blog\/2004\/09\/29\/mt3_dynamic_pub.html","url_meta":{"origin":11553,"position":3},"title":"MT3, dynamic publishing, and SmartyPants","author":"***Dave","date":"Wed 29-Sep-04 11:59am","format":false,"excerpt":"SmartyPants is a text modifier that can be used to turn straight quotes to \"curly quotes\", dashes to em-dashes -- as they say -- dots to ellipses ... etc. I've...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11897,"url":"https:\/\/hill-kleerup.org\/blog\/2008\/01\/05\/installing_movable_type_4.html","url_meta":{"origin":11553,"position":4},"title":"Installing Movable Type 4","author":"***Dave","date":"Sat 5-Jan-08 8:03pm","format":false,"excerpt":"I'm going to use this post to keep track of my MT4 installation.\u00a0 The good folks at Hosting Matters (who are probably sick and tired of my site sucking...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10502,"url":"https:\/\/hill-kleerup.org\/blog\/2007\/01\/04\/when_mtentrynext_isnt.html","url_meta":{"origin":11553,"position":5},"title":"When MTEntryNext isn’t","author":"***Dave","date":"Thu 4-Jan-07 9:59am","format":false,"excerpt":"So in playing around with some stuff last night, I discovered that on the individual entry archives, in the little triptych of links at the top of each entry (previous...","rel":"","context":"In "Blogging & Internet"","block_context":{"text":"Blogging & Internet","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/11553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/comments?post=11553"}],"version-history":[{"count":0,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/11553\/revisions"}],"wp:attachment":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media?parent=11553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/categories?post=11553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/tags?post=11553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}