Ultimate Tag Warrior Error

No, but it looks like you’re missing a table. Try deactivating and reactivating the plugin.

Tried deactivating, nuttin’.

Might want to talk to the plugin author then, or post on her blog about the problem.

Did you already go to ‘Options’ > ‘Permalinks’ and click ‘Update Permalinks Structure’? That solved a seperate problem when I would get a 404 when clicking a tag. Might work for you.

Niiiiik – I tried to update permalinks, no go either.

I ran into this problem also.

After digging a bit, I discovered that the database table creation goodies are in

plugins/UltimateTagWarrior/ultimate-tag-warrior-core.php

I chmod 777’d the entire folder (including the above file) — no dice.

I then double checked my wordpress database authentication credentials, ensuring that “create” was allowed. It was.

I didn’t have to much success with the error reporting, either, so in the end I just went into the database directly and created the tables manually.

Go into mysql and run the following:

			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;

You may need to adjust the “wp_” prefix in the table names, but I’m pretty sure my naming convention is the wordpress default.

Hope this is helpful. If it works for you, thank me by throwing me some blogosphere love and linking to me. ??

I too have a similar problem.

Symptoms when UTW is activated: When I enter a search word and press ENTER, the following error message appears:

WordPress database error: [Not unique table/alias: 'p2t']
SELECT SQL_CALC_FOUND_ROWS wp_can_posts.* FROM wp_can_posts INNER JOIN wp_can_post2tag p2t on wp_can_posts.ID = p2t.post_id INNER JOIN wp_can_tags t on p2t.tag_id = t.tag_id LEFT JOIN wp_can_post2tag p2t on wp_can_posts.ID = p2t.post_id INNER JOIN wp_can_tags on p2t.tag_id = wp_can_tags.tag_id WHERE 1=1 AND (((post_title LIKE '%some_search_word%') OR (post_content LIKE '%some_search_word%'))) AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) AND t.tag IN ('religion') OR wp_can_tags.tag like '%some_search_word%' GROUP BY ID ORDER BY post_date DESC LIMIT 0, 10

WordPress database error: [Not unique table/alias: 'p2t']
SELECT SQL_CALC_FOUND_ROWS wp_can_posts.* FROM wp_can_posts INNER JOIN wp_can_post2tag p2t on wp_can_posts.ID = p2t.post_id INNER JOIN wp_can_tags t on p2t.tag_id = t.tag_id LEFT JOIN wp_can_post2tag p2t on wp_can_posts.ID = p2t.post_id INNER JOIN wp_can_tags on p2t.tag_id = wp_can_tags.tag_id WHERE 1=1 AND (((post_title LIKE '%some_search_word%') OR (post_content LIKE '%some_search_word%'))) AND ((post_type = 'post') AND (post_status = 'publish' OR post_status = 'private')) AND t.tag IN ('religion') OR wp_can_tags.tag like '%some_search_word%' GROUP BY ID ORDER BY post_date DESC LIMIT 0, 10

I am anxious to know if there is a fix for this, and I am quite hesitant to manually creating tables in my databse like fuery suggests.

Make sure you’re using the absolute latest version of UTW.

I most certainly am. I call it the pi-version. (3.1415…)

By the way, I have found that people with the exact same problem are discussing it on UWT’s author’s forum. Here: https://www.neato.co.nz/forum/comments.php?DiscussionID=1560&page=1#Item_0

– S