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 log gets:
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
On screen, I’ll get something slightly expanded:
SQL/DB Error — [Got error 12 from storage engine]
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
The requested page could not be found.
Cannot modify header information – headers already sent by (output started at /home/dave/public_html/blog/mt/php/extlib/ezsql/ezsql_mysql.php:109)
If I go to manually save a post, sometimes (not always) I get:
An error occurred:
Can’t call method “prepare” on an undefined value at lib/MT/ObjectDriver/DBI.pm line 103. at lib/MT.pm line 867
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
I’ve done some research via Google on this, but not getting diddlysquat.
Meantime, comments (and posts) are 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.
UPDATE: 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*
This error also affects WIST, Blog of Heroes, Doing Write, and BoulderDude’s site.
Well, we seem to be working again. Got the HM folks (who were quite helpful, as usual) to restart the MySQL server and, hey presto, all was right with the world.
In the meantime, it was a chance to clean up some other problems lurking out there (note to self, do regular DB checks and cleaning). Hopefully all’s right with the world for a while.