Racing Minis at Zandvoort
Photo: Copyright © 2019 Eelke Blok

Changing a user's password in OpenX 2.8

The user management of OpenX is a little confusing if you are used to other systems. There is a blog-post about the user system on the OpenX-blog giving a good overview.

One aspect that they seem to have forgotten is dat users may want to change their password. A "I forgot my password" link is provided, but other than that there is no way to change your password.

No more multi-language

So you may see a few weird menu items, blog posts and/or categories. This is because I disabled the WPML (multi-language) plugin. Recently, they went commercial and since then (or thereabouts) I've had trouble updating. Then, my server was hacked. I am not in the least way implying this was due to WPML, but the fact is that it was out of date along with three other plugins. The others I could update. WPML, not so much.

Finding number of Drupal-nodes created per hour in a single query

For a customer I've been running an import of old content into a Drupal installation and I got the feeling that the process seemed to run slower and slower. We say "meten is weten" in Dutch ("measuring is knowing"), so I wondered if it was possible to write a single SQL query to find out how many nodes were created per hour since the start of the import. This is the query I came up with:

SELECT FLOOR((node.changed - 1304604369) / 3600) AS hour, COUNT(nid) FROM node WHERE node.changed >= 1304604369 GROUP BY hour;

Wall Street Journal: What Part of ‘Mini’ Did You Not Grasp, BMW?

This reviewer from the Wall Street Journal puts into words what has been my opinion about the Mini Countryman for a while. It's great my dad still gets to drive a Mini because of it, it's a great drive, I might even consider it myself if I was really pressed for space. But...

We'd never build a full-size Mini truck, would we, Meine Herren? The Germans burst into gales of laughter: Hah. Hah. Hah. Hah. Never a D-segment sedan? Again, Das ist nicht moglich!