WPMU Update – Improved Caching

Hopefully you should see this site run a little faster, I’ve moved most database accesses to inside the cache loop.
For most users caching and processing of requests should be faster as the whole WordPress posts-loop is now cached, however there is a trade off. I can’t check if there are multiple or single posts on a page so every page, including the front page, is cached with your comment credentials and user login (if any). In other words, if I visit the front page and then you do, the front page won’t be cached for you, but if two anonymous users visit the second visitor will get a completely cached copy.
If you see any problems please leave a comment on this post, or email me at donncha @ linux.ie!

A bit later…I’m watching the logs and I’m glad I made that change. We’re being hit by 240 280 attempts at referer spamming from sex 4singles.com. After the first hit, all they get served is static html! 🙂

WPMU Update – mod_rewrite fix for digits in URLs

Here’s a small fix to fix a big mod_rewrite rules bug. URLs like this, http://blogs.linux.ie/xeer/2005/01/06/2004-indian-ocean-earthquake-wikipedia/, won’t load properly as mod_rewrite gets confused between the date of the post and the year in the title. Here’s a quick fix:
Open the .htaccess file in your root directory and replace each occurance of ^(.*) with ^([_0-9a-z-]+)
Thanks to Kae and Darragh for spotting that.
The latest CVS update broke post editing a bit, an extra field was added. Here’s how to update your blog if you’re using it:
cd wp-inst/wp-content/blogs; for i in *; do echo "ALTER TABLE wp_"$i"_posts ADD menu_order INT( 11 ) DEFAULT '0' NOT NULL" | mysql wpdb ;done

WordPress is Arstechnica "Web application of the year"

WordPress won an award!

WordPress is the most prominent rising star of weblog software, completely free and with a large and active community.

Several other notable categories, including the infamous “Thumbs Down” award going to ATI for their dreadful Linux driver support. #debian gets an honourable mention in this category too. Looks like it’s not the place to go to for Linux solutions! Try the ILUG instead!

That Spam Problem

Every blog on this machine now has the the spam words from my blog appended to their own!
Blog authors here should hopefully see a major decrease in the number of spam comments and trackbacks they have to moderate as I’m fairly diligent in updating my word list!
More on spam trackbacks to come later including mangled links to some of my content that was robbed to create a spam weblog. Thanks guys – just the motivation I needed to update my spam fight! nah nah nah! 😛

Spam Spam Spam, Come on up and get your spam!

Here’s an updated list of recent spam to this list. It’s updated every few minutes so you can see a snippet of the spam that’s being deleted automatically here by Kitten’s Spaminator and diligent updating of keywords. Go wild!

I need to think about this a bit more. WPMU supports multiple blogs, run by multiple different people, all of whom can update their spam word lists. Wouldn’t it be useful to have a “I trust the following blogs” list so that spam words can be shared between blogs?

Slightly related, I started using PEAR Cache to cache frequently used database calls. Stuff like the “last posts” and other plugins now use that. It’s working very well and load on the server has gone down!

Oh, and when you’re updating to the latest CVS version of WordPress, a database table has changed. I ran the following to update my tables:
cd wp-inst/wp-content/blogs; for i in *; do echo "ALTER TABLE wp_"$i"_users CHANGE dateYMDhour user_registered DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL "| mysql wordpress_db; done

Painful Upgrade?

Not too bad, I guess. Considering the amount of changes recently in WPMU the upgrade this evening went rather well! If you spot anything breaking here I’d really appreciate a comment on this post!
Later… Not quite as painless but I may have tracked down the major bugs. It’ll also help me resolve issues with the current release of WPMU. So far, the only outstanding issue is the search engine – blog authors, edit your site template and add “/index.php” to the “action” part of the search form so it looks like the following:
<form id="searchform" method="get" action="{$siteurl}/index.php">

WordPress Multiuser, Dec 6th Snapshot

Here’s another snapshot release of WPMU, this one fixed many bugs that existed when installing WPMU in the root of a webserver. Thanks go to John Allman, Derek Ditch and Per Soderlind(sorry, don’t know how to get that proper spelling Per!) for help and bug reporting.
Go download it!
No reg page yet, I’m drained after a day hacking the above.. zzzz