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.
-
-
– Step 1. Create tags in UTW from JK
-
INSERT INTO wp_tags (tag)
-
SELECT DISTINCT tag_name FROM wp_jkeywords
-
-
– Step 2. Link tags to posts in UTW
-
INSERT INTO wp_post2tag (tag_id, post_id)
-
SELECT t.tag_id, j.post_id
-
FROM wp_tags t, wp_jkeywords j
-
WHERE j.tag_name = t.tag
-
-
— 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!
Recent Comments