[wp-testers] Testing Taxonomy

[spencerp]

Ryan Boren wrote:
> http://trac.wordpress.org/ticket/4189
>
> If you've already tried the upgrade and had problems, drop your terms,
> term_taxonomy, and term_relationships tables and decrement your 
> db_version
> to force a new upgrade.  The easiest way to decrement db_version is to 
> edit
> it with wp-admin/options.php or with phpmyadmin. 

Ok, on the localhost did the above again. All categories went bye bye! I 
had to make new categories, even edited on post assigned post to a new 
one, the check mark isn't sticking to it in the right window pane for it 
like normal. All other posts aren't showing up on the blog period, this 
is what's on front page of blog:

WordPress database error: [You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right 
syntax to use near ') AND (post_type = 'post' AND (post_status = 
'publish' OR post_status = 'privat' at line 1]
SELECT SQL_CALC_FOUND_ROWS wp02_posts.* FROM wp02_posts LEFT JOIN 
wp02_term_relationships ON (wp02_posts.ID = 
wp02_term_relationships.object_id) LEFT JOIN wp02_term_taxonomy ON 
(wp02_term_relationships.term_taxonomy_id = 
wp02_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND 
wp02_term_taxonomy.taxonomy = 'category' AND wp02_term_taxonomy.term_id 
IN (2,3,4,5,6,7,8,9,10,11,13,17,18,19,20,) AND (post_type = 'post' AND 
(post_status = 'publish' OR post_status = 'private')) GROUP BY 
wp02_posts.ID ORDER BY post_date DESC LIMIT 0, 5

I made 3 categories.. assigned ONE post to that category and the 
checkmark isn't there. Nothing is happening.. WTH? :(

--
spencerp
http://spencerp.net
http://www.vindictivebastard.net