Strange blog-spam problem

· Music

Movable Type is doing something bizarre here. I’ve got this entry, Blogging a yoga conference @ Radio Free Blogistan and it shows 19 spam comments in the counter and on the individual archive page. The spam comments are also showing up in my list of recent comments in the sidebar of RFB.
Ironically, they’ve all got “nofollow” attributes on the links, so they ain’t buying any Googlejuice for the spammers, but they’re still ugly and they clutter up my recent list.
So, just junk them and rebuild, right? Sounds easy. Here’s the problem:
I’ve already junked those comments _and_ repeatedly rebuilt the index page and the archive pages. The back-end information for the entry shows 0 comments. They are phantoms. I have no idea how they can be displayed on the page despite the rebuilds. I have no idea where they’re stored and where they’re coming from.
How can the backend and the frontend of an MT blog be out of synch like that?
I suppose I could poke around the database but I’d first like to have some idea of what’s going on.

Lazyweb request for help with mySQL (phpwiki problem)

· Music

Over at The Power of Many, the wiki-driven portion of the site is down because of an error of some sort in the “page” table in the mySQL database. I’m kind of stymied now and don’t know whether the error is even fixable, or if I’ll need to revert to a backup.
Please drop me a line if you are experienced with php / mySQL and think you might be able to lend me a hand. Thanks in advance!
Update: Nevermind. Andy Baio pointed me in the right direction. A data table had crashed. I was able to repair it in phpMyAdmin. All is once again right with the world. Thanks, everyone who helped,!

My main server down again

· Music

I love owning my own server and hosting my own site. Most of the time I love my co-location arrangement too, by which my friend and sysadmin manages the site and keep it humming. The downside of all this is that the server (a reconditioned Linux box) is located in New York while I am in Oakland.
Right now the machine seems to be offline. Not only can’t I reach my sites via my web browser (or any of the other sites hosted there), but I can’t even telnet into the box right now. I haven’t heard of another power outage or tropical storm in New York since last evening, so I have no idea what the cause is. Maybe we’ve been hit with a denial of service attack. Maybe someone tripped over a power cord, unplugging it, before going home for the weekend.
Regardless, chances are my sites won’t be back online till Monday, which suddenly makes my recently neglected, still in their free trial period, remotely hosted TypePad sites all the more enticing. Over the weekend maybe I’ll get around to uploading some more one-off photos to Mr. Spontaneous and I’ve decided to keep messing with my third TypePad site (I get three as a Plus user), taking down “Radio Free TypePadistan” and setting it up with some new name as a place to store ephemera in situations like this when I can’t get to some of my other sites. I won’t use permalinks and I’ll just park occasional posts there for later migration to the correct blog. At least that’s the idea.

New York is off-line

· Music

Suddenly I’ve noticed the charms of a hosted weblogging system, now that the New York blackout has taken my server off-line. Not sure if my sites will be up again today or not till Monday. It’s too bad, too, because I’m missing “Fair and Balanced” day on the Internet.