January 2007

You are currently browsing the monthly archive for January 2007.

Protected: We will

January 30, 2007 in Private | Permalink

This post is password protected. To view it please enter your password below:


Making the Switch: JK to UTW

January 28, 2007 in Blog, Technology | Permalink

So. I decided to give a Ultimate Tag Warrior a spin when I started having some strange problems with the Jerome’s Keywords Plugin after the 2.1 WordPress upgrade. I poked around and couldn’t figure out what was wrong and decided to switch over to UTW.

There wasn’t much advice on Google for people contemplating the switch so I decide to give it a shot myself. It was pretty easy really; simply a matter of moving tag data from the JK table (wp_jkeywords) to the UTW ones (wp_tags, wp_post2tag).

You will have to execute the SQL code below through phpMyAdmin or the MySql client of your choice. The code is provided as-is, with absolutely no warranties, so please don’t blame me if you wipe out your database. Backup backup backup.

  1.  
  2. – Step 1. Create tags in UTW from JK
  3. INSERT INTO wp_tags (tag)
  4. SELECT DISTINCT tag_name FROM wp_jkeywords
  5.  
  6. – Step 2. Link tags to posts in UTW
  7. INSERT INTO wp_post2tag (tag_id, post_id)
  8. SELECT t.tag_id, j.post_id
  9. FROM wp_tags t, wp_jkeywords j
  10. WHERE j.tag_name = t.tag
  11.  
  12. — Done!

After running the sql, you may need to do a “Tidy Tags” in UTW (WP Admin > Manage > Tags > Manage Tags) before things start showing up properly.

Remember, backup!

Tags: , , , , , ,

Hello Ella!

January 26, 2007 in Blog, Technology | Permalink

Upgraded WordPress to the latest and the greatest 2.1 version “Ella”. Relative painless upgrade but the Category Exclusion plugin I was using is broken. It was causing query_posts to return duplicate records for posts which have multiple categories. No biggie to fix; just remove the plugin and use the exclude parameter when calling the list categories function. Incidentally, while patching the theme, I found out that wp_list_cats is deprecated and is replaced by wp_list_categories in WP2.1.

What’s harder to fix is the problem WP Tiger Admin has with the tabbed Tiny MCE interface. Toggling between the Visual and Code modes causes the UI to go a little crazy. I regularly switch between both modes when editing a post, so this a bummer.

In Visual Mode initially Click on Code modeThen click back on Visual mode again

Other than, “Ella” seems to be working well. What I like most:

  • Ability to toggle between WYSIWYG and code mode in the editor
  • Auto-save!
  • Improved upload manager – it’s a whole lot more intuitive now

I still prefer the Tiger Admin interface though, and I hope it gets fixed soon…

Tags: , ,

And the winner of Survivor: Real World is…

January 22, 2007 in Fun | Permalink

Le Canard.

Lucky Duck A duck in the US state of Florida has survived gunshot wounds and a two-day stint in a refrigerator.

A hunter shot the duck, wounding it in the wing and leg. Believing the bird was dead, he left it in his fridge at his home in Tallahassee.

The hunter’s wife got a fright when she opened the fridge and the duck lifted its head, a local veterinarian said.

This little duck makes Survivors look wimpy in comparison.
[via BoingBoing]

Tags: , ,

« Older entries