Well, I seem to have gotten everything working again, although the table errors have not gone away.
An update: it seems now that pages within the blog work. For example: http://disorderedcosmos.com/2010/12/31/hello/
But, when I go to the main site, it forwards to another site. I can’t figure out how this has happened. In my CNAME records, I do have poetry.disorderedcosmos.com forwarding to that site, but I have explicitly got www reserved.
Also, this wasn’t happening a few days ago! So I still think it’s connected to the database error somehow.
I had the same experience as urbanred in the end. I don’t know why, but I definitely recommend trying it.