WordPress.org

Forums

Ultimate Tag Warrior Error (10 posts)

  1. William Speruzzi
    Member
    Posted 8 years ago #

    I've installed the most recent version of UTW and I'm getting the following error:

    WordPress database error: [Table 'thissavageart.wp_tags' doesn't exist]
    select tag, t.tag_id, count(p2t.post_id) as count from wp_tags t inner join wp_post2tag p2t on t.tag_id = p2t.tag_id inner join wp_posts p on p2t.post_id = p.ID WHERE post_date_gmt < '2007-02-06 19:40:24' AND (post_type = 'post') group by t.tag having count > 0 order by tag asc

    Do I need to create an actual folder for my tags?

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

  3. William Speruzzi
    Member
    Posted 8 years ago #

    Tried deactivating, nuttin'.

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

  5. niiiiick
    Member
    Posted 8 years ago #

    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.

  6. William Speruzzi
    Member
    Posted 8 years ago #

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

  7. fuery
    Member
    Posted 8 years ago #

    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. :-)

  8. simsen
    Member
    Posted 8 years ago #

    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.

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

  10. simsen
    Member
    Posted 8 years ago #

    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: http://www.neato.co.nz/forum/comments.php?DiscussionID=1560&page=1#Item_0

    - S

Topic Closed

This topic has been closed to new replies.

About this Topic