The Hive Archive

So my Wordpress got compromised again by spammers, I’ve upgraded to the latest and greatest and instituted new protection mechanisms as well as tracking Wordpress by SVN to make upgrades more painless.

Some stats:

You have 125 posts, 2 pages, 11 drafts, contained within 63 categories and 2 tags.

You are using WordPress Default theme with 3 widgets. This is WordPress version 2.5.

Akismet has protected your site from 24,837 spam comments already, and there are 446 comments in your spam queue right now.

Surprisingly, the upgrade went pretty smoothly. While dinking around in the admin section, I noticed:

Akismet has protected your site from 15,874 spam comments.

Man, I hate spammers. The more popular my domains get, the more they get targeted. One of my other sites was used as a forged from address in a bunch of e-mails and I got all the bounces. Thanks for checking SPF everyone.

Update:

Ugh! Damn it.

WordPress database error: [Table 'wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM `wp_posts` p LEFT JOIN `wp_post2cat` pc ON p.ID = pc.post_id LEFT JOIN `wp_categories` c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID

WordPress database error: [Table 'wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM `wp_posts` p LEFT JOIN `wp_post2cat` pc ON p.ID = pc.post_id LEFT JOIN `wp_categories` c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID

Yes, I ran the update which supposedly updated my DB. Lovely.

Update 2:

Apparently I need to update my Google Sitemaps plugin as found in this thread: http://wordpress.org/support/topic/135564

I have upgraded everything to the latest Wordpress, installed new plugins and updated the theme. Let me know if you see something broken, and I’ll get it fixed up.

I’ll probably be experimenting with some new themes and graphics placement stuff. I have already installed some new plugins that do some semi-intelligent caching, so that should speed things up. I also recently tuned MySQL to have a query-cache. In combination with the Wordpress speedsups, this site should be able to take quite a beating.

I’ve been sitting on this domain for awhile for a project that hadn’t gone anywhere, and I decided it was going to waste.  I wanted to try out Wordpress and start up the writing chops again.  This seemed like a good opportunity to do so.  So far Wordpress has been pretty impressive, we’ll see how this experiment goes.