While creating a post using Kung-log something happened to cause the entry to partially corrupt the db3 database. This resulted in errors when the templates tried to generate a comments link to the post in question. The id of the post was 0 and couldn't be deleted from the database.
I coped with this by manually deleting the errant post from the generated index page, and commenting out the comment-link in the main index template. I was grumpy about it, but what can you do.
I'd now like to switch to a Postgres backend, but the corruption is preventing me from doing so. When I run the mt-db2sql.cgi script I get warnings like:
**** WARNING: substr outside of string at /var/www/html/blog/lib/MT/Serialize.pm line 59.
**** WARNING: Use of uninitialized value in unpack at /var/www/html/blog/lib/MT/Serialize.pm line 59.
...which are the same warnings that have been plaguing me. But I also get:
ERROR: parser: unterminated quoted string at or near "'Â?
followed by the text of the post. That quotation mark seems to be the problem to me, although I have no real clue. Seeing as how I can't get to this post in any way to delete or alter it, and seeing as how it is clearly a few cards short of a full db3 record, I'm curious to know how I might handle this.
Some check obviously failed over the xml-rpc exchange between Kung-log and MT, which I thought people might want to be on the lookout for. Am I just out of luck, though? TIA!