ColorZilla has the ability to work with Ubuntu, but not the way it is packaged. If you install the regular ColorZilla_1.x.xpi the library that does not work with Ubuntu gets installed and you get the ‘mode not supported on your platform’ error message.

The ColorZilla_1.x.xpi (both the one on Mozilla.com and the beta at iostart.com) comes with the needed library, it’s just a matter of forcing the correct one for Ubuntu. Here’s how I did it with the beta (kudos to SaltwaterC for pointing out that an .xpi file is just a renamed .zip file):

1. Do a right-click and save so I could access the file locally.
2. Open up ColorZilla_1.9.xpi with File Roller (Ubuntu Gutsy/7.10 default handler) and delete the /platform/Linux/components/ColorZilla.so file inside the archive and then just hit the ‘x’ (close button) on File Roller.
3. Open up Firefox, open the Addons window, drag and drop the ColorZilla_1.9.xpi file onto the window, click install.
4. Restart Firefox.

Yet one less reason to develop on M$.

After upgrading to WordPress 2.3 and trying to re-evaluate tag usage, I decided to re-visit an old pet-peeve of mine: The relatively massive (read: gi-normous) size of my wp_postmeta table. It was always the biggest table in my database (thanks to UTW), so whenever I was poking around in the database it caught my eye (it was over 5MB).

With WordPress 2.3 ‘tags’ are starting to be handled internally, and the need for UTW in it’s old form (rumor is it will be broken up into elements complementing WordPress’ new built-in tagging system) is no longer, so I got out the scissors and…

Taking a closer look, I had over 30,000 records in wp_postmeta that had a meta_key named _utw_tags_0. Amidst thoughts of how these records were somehow data-intercourse/sexing it up and reproducing like bunnies, I started warming up phpMyAdmin (does that behemoth take a while to start or what?).

Once phpMyAdmin was up, I selected my site’s database, then the wp_postmeta (the ‘wp_’ prefix is the default, if yours is different, adjust the SQL query appropriately) table from the list on the left side of the phpMyAdmin interface.

Once you have the wp_postmeta table in front of you, click on the SQL tab at the top of the page and you should end up on a page with a large text box and a query already started for you. Highlight that text and replace it with:

DELETE FROM `wp_postmeta` WHERE meta_key = '_utw_tags_0'

You will get some sort of “Are you sure you want to destroy Planet Earth” notice, click yes.

I still had about 10 records with a meta_key title of _utw_tags_ so I used the same steps as above and blasted them with:

DELETE FROM `wp_postmeta` WHERE meta_key = '_utw_tags_'

This brought my wp_postmeta table down from over 5MB to less then 22kB. Can you say: Wheeee?

Between the theme change, settling into 2.3 final and trying to bring some style continuity from the new theme into my forums, there have been some short periods of down-time. Last night and this AM were more significant however, so I wanted to post some info:

Last night I made a ‘quick’ change to the site, adding a little code to my functions.php file and like an idiot I guess I didn’t check afterwards but just ran out the door (real life, what a concept). End result was that samdevol.com was down all night until I did a huge “DOH!” this morning.

I use PunBB for my forum, and decided to give it it’s own database. But until I went through the SQL code (my backup) and repaired it by hand, I couldn’t re-import it. The error I noted was:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Apparently the same MySQL database that I exported from refused to accept the format it created. Specifically, where a field was empty (signified in my backup as , , [comma space comma]) MySQL choked on the import. I eventually did a search/replace and replaced all occurences of , , with , '', [comma space tick tick comma] and it finally imported without error.

I have discovered the import for punbb appeared successful, but it was not. Until I find some way to import it, the forum is back up with no old messages.

All user error, short-between-the-headphones stuff. Sowwy.

Now if I could figure out my database sync issue (every time I activate a plugin I get the Your database is out-of-date. Please upgrade. message).

I have been meaning to post a note about some of the recent changes here, but have been busier then a long-tailed cat in a room full of rocking chairs (been dying to use that phrase for some time ;’)…

I’ve adopted a new theme called nobus, designed by Dezzain Studio. The UI is not too simple, not too complex, not too dark. The header is a bit tall, but I want to live with it a bit before attempting changes (the height did allow me to pretty much cut-and-paste some of my code/hacks into the header to retain functionality I desired (translation service, RSS icon w/out scrolling down, my logo and some quotes). There is a big difference in typography, not just style, but size and spacing. Feedback is desired/welcome about these (and any other) changes.

Some minor changes in functionality, testing new plugins (not just new to me, but new to WP 2.3 and/or the ‘world’), carefully applying some AJAX (less then 2% of my visitors have JavaScript turned off, but I do keep an eye on this and try to use JS that will degrade/fall-back to HTML behavior/appearance.

Posted here about using Zazz Post ticker. I have been keeping an eye out for something with this functionality over the last year or so, and everything I researched/tried was either too clunky/ugly or required more time to integrate then I was willing to devote. This one dropped right in without a struggle and styled up quite easily with a few CSS additions.

Playing with the new (WP 2.3) Tag functionality (not tag as in template-tag-PHP-function but tag as in ‘mini-category’). Using the new-to-2.3 the_tags() function like this:

With the 2 arguments supplied to the_tags() being the leading text/title and then the separator. Checking existence may seem overkill but without it, if WP is downgraded, it will explode. Or something like that.

Also trying the new Tag Cloud widget that comes with WP 2.3, although using:

pretty much achieves the same thing if you wanted to just add it to sidebar.php (or elsewhere).

Some other new plugin additions:

• DoFollow Using no-follow as a rule just doesn’t make sense any more, it should be the exception.
• Enforce www. Preference I dropped the www NOTE: This plugin is now redundant with 2.3.
• HeadSpace2 Experimenting with this meta-generator-on-steroids
• Link Indication If we are going to put the control/decision about how links/new-windows are handled into the users hands, let them make an informed decision?
• Nofollow reciprocity If I’m going to turn off no-follow, I expect you to, as well
• Shutter Reloaded With all the different javascript libraries and resultant conflicts my lightbox/slimbox scripts started acting whacky. Just dropped this in and I’m ok for now ;’)
• WP-Footnotes Because some of my posts just need footnotes.
• Secure and Accessible PHP Contact Form Fianlly broke down and decided to try/test a plugin form solution

Some folks email me now and then about the quotes in my header, so just as an FYI: I use Quality Quotes, and the thing I love the most about this ‘yet-another-random-quote’ plugin is that it goes out and gets 10 quotes each day and then cycles randomly through them on each page refresh. So instead of hitting/depending-on some outside resource every time a page is refreshed on my site it’s cached locally. Fast, lightweight and independent.

Closing with one of my favorite recent quotes:

We can lick gravity, but sometimes the paperwork is overwhelming.
- Wernher von Braun

There are some basic steps you can take to help limit your exposure to malicious behavior directed at your WordPress blog. My intention with this article is not to make your website bullet-proof (if such a thing exists) but to cover the most common exploits/weaknesses. File and directory permissions have been discussed elsewhere but I’ll post a reminder about the basic rule-of-thumb: Set files to 644 and directories to 755. If you have to use less secure settings (for /wp-content/uploads/ for example) you don’t have a good host.

Failure to do the following doesn’t mean your blog will be hacked, it just means it’s more likely. So here we go:
..Cover your privates (or: “Nice knickers there!”)…

1. Delete unnecessary files /wp-admin/install.php and /wp-admin/upgrade.php
2. Delete default post and comment
3. Make it harder to reveal your SQL login info and help prevent users browsing where they shouldn’t: In your root directory (where wp-config.php resides) make sure there is a .htaccess file containing the following:
   Options -Indexes
DirectoryIndex index.php index.html

Order Deny,Allow
Deny from all


4. Change permissions for wp-config.php to 600 (equivalent to rw——-) if possible
5. Prevent browsing of directories not covered by WordPress: Drop an empty (0-byte) file named index.html in /wp-content/plugins/ or /wp-content/uploads/ (for example)
6. For SPAM prevention, activate Akismet (comes with WordPress) and install/activate Bad Behavior These two plugins are the minimum in spam prevention in my opinion, but feel free to experiment on your own.

Other considerations for security are your choice in a host. I recommend a professional:

As always: Feedback welcome!

I was thinking about a way to showcase older posts and happened across the Zazz Post Tickerplugin by Stew Houston.

I thought “Here we go, another chance for me to totally bork my blog with some unknown piece of code…” So I picked up the scissors and blah-blah-blah (you get the idea).

I took a quick look at the instructions (note that for historical purposes) and I didn’t see where I had to re-write my server’s kernel or edit core WordPress components and figured “wot the ‘ell”.

The good points: Easy to install, light-weight and does exactly what it’s supposed to do right out of the box (and that’s with WordPress 2.3-beta3). It’s easy to configure (though it does require editing the zazz-post-ticker.php file, it’s a simple, straight-forward edit), it doesn’t use tables (thank you, I’ve puked enough this week) and the CSS is not convoluted! It allows for changing the duration before fading, the number of posts and even allows for an offset (seems redundant to me to display post information that’s displayed an inch lower on the page so I liked this feature).

The bad point (singular, mind you): The javascript isn’t wrapped so it isn’t valid. But here’s a quick fix:

Open up zazz-post-ticker.php and go to line 30, it should look like this:
echo "\n”;

Add:
echo "//]]>\n";

Now you have a light-weight, easy to install/configure post ticker for WordPress that validates as well!

Feedback welcome.

Just released the new version (0.94) of the missunderstood theme. Some major changes, lots of clean-up, added functionality:

• Built-in Optimal Title (for SEO)
• Built-in slimbox (faster, lighter Lightbox effect)
• Separate lists for comments and trackbacks
• Fancier blockquotes
• Built-in pullquotes
• Prettier search box
• Code-block style with numbers and zebra striping

A lot of generous people have brought my attention to problems with the earlier releases of missunderstood, and I’ve tried to go through everything with a fine-tooth comb. I tested this version in FireFox, Internet Explorer 6 and 7 as well as Opera. It is valid XHTML strict when used in a modern browser (read: anything other then Internet Explorer and that’s only because M$ couldn’t give a damn ).

Original post with more info is here. See a live demo here. Missunderstood has a Support Forum, and it can be downloaded from the original post or directly from here.

Feedback always appreciated…

I wanted to add a forum to my WordPress blog but everything I came across did not integrate well (design/page continuity, etc.) or was too simple for my tastes… Then I came across a tutorial here (there are a few around, that’s just the one I tripped across). Following the tutorial I had a somewhat more integrated forum…
…where the blood-splatter of our butchery won’t stain anything…
With the lessons learned and the release of PunBB 1.2.15 I decided to see if I could do a better job. Since the first install/integration I had added a css-based navigation menu and some random quotes which did not display when my banner/header was displayed above the PunBB forum.

Annoyed, I picked up the scissors and started running….
Continue reading this post…

Version .95 is out now, with a lot of tweaks done over several months…

Incorporated some plugins into functions.php for convenience:

• Optimal Title
• Hot Dates
• removed ’sociable’
• Slimbox

Added the Top Post functionality (for a full-width ‘featured’ post). Top Post takes the latest post in a category (category set in the themes options under Presentation), displays it at the top (full-width) and makes sure it is not repeated in either column below.

This theme comes with Slimbox, a lightweight/fast image display system like lightbox. It’s built into Corporate Slave, so there shouldn’t be any need for configuration. It’s automagical, works with any thumbnail-with-link-to-fullimage.

See it in action here.

Original post with much more information. Download there or directly from here: Corporate Slave Theme v0.95

Support Forum for the Corporate Slave Theme is here.

Since domains are often indexed differently (with and without the www prefix), I’m jumping on the no-www bandwagon. For more info visit

Ease of use with WordPress influenced me to use Mark Jaquith’s Enforce www. Preference plugin (which works for ‘enforcing’ either a www or no-www preference).