WordPress 2.2.2 and Ultimate Tag Warrior Plugin Problems.

After about two days of fiddling with DNS settings and .htaccess files UkMac.net has finally been transferred from Netfirms to Plus.Net. One of the difficulties with the migration, and this is probably common to most WordPress sites, is getting all the little plugins and tweaks to themes working again. The reality is that many little changes get made to a site during its evolution and unless you are religious about recording these it can be difficult if not impossible to replicate the exact configuration you had previously.

One oddity with the transfer this time was getting the Ultimate Tag Warrior plugin by Christine Davis working again. For some reason the plugin would not create the three tables which it normally should when it is first activated. Despite lots of Googling I couldn’t find a complete solution to this problem and in the end had to create the tables in PhpMyAdmin by hand. The SQL executed for reference was :

CREATE TABLE IF NOT EXISTS wp_tags (
tag_ID int(11) NOT NULL auto_increment,
tag varchar(255) NOT NULL default ”,
PRIMARY KEY (tag_ID)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS wp_post2tag (
rel_id int(11) NOT NULL auto_increment,
tag_id int(11) NOT NULL default ’0′,
post_id int(11) NOT NULL default ’0′,
ip_address varchar(15),
PRIMARY KEY (rel_id)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS wp_tag_synonyms (
tagsynonymid int(11) NOT NULL auto_increment,
tag_id int(11) NOT NULL default ’0′,
synonym varchar(150) NOT NULL default ”,
PRIMARY KEY (`tagsynonymid`)
) TYPE=MyISAM;

This assumes your WordPress install is set to prefix tables with wp_ .

Once this was done the UTW plugin worked fine.