Sometimes The API Just Won't Do It

So I've been having lots of fun (read: horrible pain) this week thanks to some quirks of Drupal that only really present themselves when you are looping through, loading, saving and manipulating nodes quickly.

Drupal 6.x And CentOS 5.x

This is more a bookmark for my reference than anything, but if you have a stock CentOS 5.x installation (maybe from a VPS image or a clean install on a dedicated box) you're going to have issues with Drupal 6.x.

Framework, Product Or Both?

Ask any Scottish whisky maker, distilling is not an easy process. Only when the hot gases cool can you see the real results of your labours.

This Author Sees A Long Drupal Slope

Anyone who follows the community will know much is made of a developer/designer divide. To be honest, I still don't quite get why this is. I don't personally feel it.

I'm prompted to write a post that is a bit less technical and more of a muse on the state of the Drupal project.

Restoring The MySQL Root User

Very quick post today. I rather foolishly didn't look at a back-up of a MySQL database someone sent to me this morning. I didn't realise it contained a copy of *their* mysql table. So when I restored it, all my user data got replaced with their user data. Frack.

AHAH, Node Forms And Select Lists

There are a number of decent resources helping you to make your first steps in to AHAH with Drupal 6.x. I won't try and create another start-to-finish tutorial.

Very Slick Site Maps

Short one today. This collection of links caused a mini stir in the #drupaluk IRC channel yesterday (thanks to longwave). Nothing dazzling, just a nice and easy approach to a really pretty site map for your Drupal website.

Avoiding Loops In Preprocess Hooks

I've just released a new module (fanfare) which seems to work pretty well. I have a couple of silly bug fixes to put up tonight (knew I should've called it "beta") but other than that it works great. It's called Node Reference Variables:

Filtering Search Results On CCK Fields

This is a quick HOWTO on altering the core Search module's database query in Drupal 5.x and 6.x. I think this will be different in 7.x, as there seem to be new, better hooks for manipulating queries, but we're not there yet.

Using Views To Create DMOZ-Style Sub-Categories

This is a quick Drupal 6.x, Views 2.x blog tutorial about creating the classic DMOZ-style sub-categories plus node listings above/below. Something Drupal does not do out of the box, but is fairly easily achieved.

Database Download Script

Just thought I'd throw this one up there. It's a Linux bash shell script I wrote this morning. You know when you want to take a copy of your production database down to localhost for testing? Not rocket science, but a bit of a pain. This dramatically speeds things up.

And We're Back, You Can Be Too

So comments are back up and running. I still need to migrate all the old Node Comments to core Drupal comments, but at least it is now a properly moderated mechanism so it should get rid of the spam. The rest can happen when it happens.

IE7 And Apache File Type Gotcha

Microsoft Office .docx file extension read by Internet Explorer 7/8 as a Zip file

Firstly, thanks for Russ at Manta Ray Media for doing the Google leg-work on this one.

Apache2 On Fedora - Getting Rid Of The 403

If understanding Linux is an important part of your work and you want to know how to properly configure a RedHat-based distro like Fedora or CentOS, then carry on reading.

Apache2 on the Fedora core (in my case Fedora 10) can be a fiddly beast.

No Comment

Ouch! Finally found a moment to make a new blog post and instead spent an hour weeding through the spam in my comments - and I'm still not finished!