What’s gone is gone

I had a look at my blog yesterday and to my horror, about 4 months of posts had disappeared. I agonized over whether I should go back over Google cache and repost lost articles, but in the end, I didn’t think it was worth the bother. After all, a blog is a notepad for ideas and framing one’s thoughts. Once written down, it’s purpose is served.

What would you have done?

About this entry

You’re currently reading “ What’s gone is gone ,” an entry on Chui's Counterpoint

Published:: 9.21.08 / 12pm

Category:: General

4 Comments

Jump to comment form | comments rss [?] | trackback uri [?]

Eric 9.24.08 / 2am

I had wondered why a couple of your posts from 12 September were generating 404 errors by the time I noticed them in the Planet Python feed. Not a huge issue, but it is disappointing.
Steve Holden 9.29.08 / 11pm

Well, I was just about to quote your Cygwin SQLite post to someone on c.l.py, but I guess this means I can’t. However, I’d definitely be thinking about changing my hosting arrangements if that happened to me … now I’ll go search the Google cache.
Chui 9.30.08 / 1pm

Surprisingly, the entry appears to be still in the wp_posts table. It’s set to “published” too, so there has to be a bad join somewhere.
Chui 9.30.08 / 2pm

Turned out to be broken indexes.

SELECT wp_title from wp_posts where wp_title like ‘%sqlite%’
worked since it’s a table scan, but

select wp_title from wp_posts where ID=479
returned 0 rows.

Solution: Rebuild indexes.

repair table wp_posts QUICK;

Have your say

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Chui's Counterpoint

What’s gone is gone

About this entry

4 Comments

Have your say

About

Recently

Categories