I'm not familiar with pgsql, but I did manage to reinstall 0.9.1 and then do the proper upgrade to 1.2.1, so everything's working fine now. Thanks for your help--I really appreciate it.

Adam

Ah...that might be the problem.

I didn't get the chance to do a clean reinstall. When I alerted my sysadmins to the spammer, they completely shut down the old blog. I had to reinstall to a separate directory, without doing any kind of clean, proper upgrade.

I might be able to reinstall the old ...

Now it's telling me this, when I look at my media library.

Unable to locate the file entitled 44, maybe it has already been deleted?
Unable to locate the file entitled 163, maybe it has already been deleted?

Does this give anyone an idea as to what might be wrong?

The security hole was found, and it had nothing to do with Serendipity. There was an unsecured wiki on the same domain.

I'd be grateful for any help on this matter.

I just upgraded from 0.9.1 to 1.2.1. (Side note: This was due to a spammer putting a subdirectory in my uploads directory, and using that to host pages advertising Viagra et al. Were there any known security holes in 0.9.1 that would have allowed that? I ...