« Previous | Next »

Making the Switch: JK to UTW

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!



About this entry

You’re currently reading “Making the Switch: JK to UTW”, an entry on dis.content

Published:
01.28.07 / 4pm
Category:
Blog, Technology