Just One Category
This plugin will cause WordPress to display on a category archive page only those posts which are direct members of that category, i.e. this plugin will exclude from that category page all posts which belong to any of that category’s subcategories but do not belong to the category itself.
Compatibility:
This plugin requires at least WordPress version 2.3 or higher, and I have tested it with the still-in-development WordPress version 2.8. If you haven’t already, upgrade to the latest WordPress.
Instructions:
- Download the plugin.
- Upload it to your
wp-content/plugins/directory (i.e.wp-content/plugins/just_one_cat.php). - Make sure the file has sufficient File Permissions to be read by your web server (you probably don’t have to worry about this step).
- Activate the plugin called “Just One Category” from your Administration Panel’s Plugin Manager.
That should be it. No configuration is necessary.
Update: This plugin is now hosted on the wp-plugins.org repository. The download link above has been changed to reflect that.
[…] hat category or any subcategory. The plugin is called Just One Category, for displaying only one category on a category page for all you […]
Your Just One Category plugin seems to break my rss feed for the category.
I was using the /wp-rss2.php?cat=3 to show the rss feed for category 3 and it was working just fine. Now I get these messages when I click on the rss link:
___________________________
WordPress database error: [Unknown column ‘category_nicename’ in ‘where clause’]
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND 0=1 AND (category_id = 3 OR category_id = 4) AND post_date_gmt
I get the flw error on all categories:
WordPress database error: [Unknown column ‘category_nicename’ in ‘where clause’]
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id = 1) AND post_date_gmt
My page validates as XHTML but when I activate the plugin the page no longer validates.
It wasn’t working because you’re not using Pretty Permalinks.
I’ve updated the plugin so that it should now work no matter the URL you use.
I can only assume your validation errors were a result of the plugin vomiting all over your page.
In the future, note that it’s always easier for someone to help you if you give them a link to your site.
Yes, it works, thank a lot!!! – great plugin, just what I was looking for. Sorry for not including link.
Hello!
I get this error, similar to Henrik… but I *am* using pretty permalinks. What do you think? I have queried specific categories (2,7,10,12,15,17,22,29) to be shown on the homepage. If you need me to re-activate the plugin, I will – in the meantime it is deactivated.
WordPress database error: [You have an error in your SQL syntax near ‘2,7,10,12,15,17,22,29 GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 3’ at line 1]
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id = 1 OR category_id = 2 OR category_id = 7 OR category_id = 10 OR category_id = 12 OR category_id = 15 OR category_id = 17 OR category_id = 22 OR category_id = 29) AND post_date_gmt
Do you mean that you have restricted the homepage so that only posts of categories 2,7,10,12,15,17,22,29 show up? If so, by what method?
Henrik, no worries. Glad it suits you.
That’s exactly what I mean – I used query posts. Perhaps this is a nasty hack, but I make this stuff up as I go along. :)
I put this before my loop:
Whoops, it’s very early in the morning yet for me. Guess I can’t put php code in my comment.
surrounded by the requisite php tags I have (I hope this works since I can’t seem to preview my comment):
$page = (get_query_var(‘paged’)) ? get_query_var(‘paged’) : 1;
query_posts(“cat=1,2,7,10,12,15,17,22,29&showposts=3&paged=$page”);
Nevermind – I’ve ended up using front-page-cats to drive the posts on my home page (instead of the god-awful query posts above) and this is no longer a problem.
THANKYOU!! this is just what I was after.. was about to write it myself until I stumbled across this.
[…] Two plugins worth looking at and get tested for my …/emba site which are by Blogwaffe. They are Just One Category and Draft Notifier. • • • […]
This is great! I wish wordpress had this function natively.
Hello and thank you for your plugin, this is looking to be a life saver. I have a question. How can the plugin be modified so the behavior is not global and work for a specific category and it’s children.
Tried to change this
if ( !is_category() )
to
if ( !is_category(Category Name) )
but that doesn’t do it. Would be really thankful.
BigBerries, The plugin simply is not designed to do what you ask. Without redefining what the plugin is supposed to do (and therefore rewriting the whole thing), the best solution is to:
if ( !is_category('category-slug') )or
if ( !is_category(cat_ID number) )Hi, what a great plugin! But I get the errors that Henrik got above. I tried to change to Pretty Permalinks but I still get the same errors…
Maybe it’s because I use Widgets? I also use WP v. 2.0.6
WordPress database error: [Unknown column ‘category_nicename’ in ‘where clause’]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt
Sorry I just realised that another plugin interferad mith yours, it’s a plugin that shows recent posts that generates the errors.
Thanks for this plugin
[…] Just One Category>> […]
Hi there
Great plugin, I hope to use it. But at the moment my sidebar widget that displays my recent posts is producing this error with your plugin installed:
[Unknown column ‘category_nicename’ in ‘where clause’]
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (post_type = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’)) AND category_nicename = ‘podcasting’ ORDER BY post_date DESC LIMIT 0, 5
Any ideas?
Thanks
Dermod
hi, a short questions for you experts:
(I installed the plugin and activated it, but nothing new happens on my website… I hope it works…)
the question is: may I place some code in the ‘single post’ page to show a list of all the posts of that same category?
thank you in advance for your help!
I have also had the errors from posts 20 and 21 above.
The post #20 error “Unknown column” I received while using WP 2.2.1 and the post #21 error (nothing happens) I received using WP ME2.2.3
Thanks much. Hope to be able to use this handy plugin.
Matt
I get the following error too:
Tried to deactivate other plugins but no go…
any ideas?
WordPress database error: [Unknown column ‘category_nicename’ in ‘where clause’]
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘6’, ‘8’, ‘7’, ‘9’, ’11’, ’10’) AND post_type = ‘post’ AND (post_status = ‘publish’ OR post_status = ‘private’) AND category_nicename = ‘services’ GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0,1
This plugin isn’t compatible with WordPress version 2.2 or greater. I’ll see if I have some time to fix it up over the next couple weeks.
How is it going MDA, already fixed the problems?
Still not working for me though :(
The plugin now works with WordPress 2.3 or greater.
You should upgrade to WordPress 2.5.1 if you haven’t already.
Thanks so much for developing this plugin. I had an older plugin running on a website that did the same thing (no subcats), but just updated it to WordPress 2.6.3, cue plugin not working, site looking completely broken, tearing hair out etc. Had a quick search for a plugin, nearly gave up when I spotted a link to this page – installed plugin, site working perfectly again, life saved.
Much respect!
THANKS FOR THIS PLUGINS, BUT I CAN’T USE THIS PLUGINS ON MY WORDPRESS, CAN YOU HELP ME!
[…] plugins worth looking at and get tested for my …/emba site which are by Blogwaffe. They are Just One Category and Draft […]
Exelent … i searched 2 day’s for it.
The name of the plugin is a little confusing, however i’m glad i found it.
Simple question – once installed, how do i use the plugin?
Am I missing something basic here, or is there no documentation, screenshots on how to use this very necessary plugin?
can’t wait to use though – good job, and thanks.
Just install and activate. There are no options. It just works.
What do you mean “it just works”?
How do I choose what category to display on which page?!?
It’s not working with WP 2.7?
Would you update the plugin please?
I have confirmed that it works with WordPress 2.7.1.
Very nice plugin however it causes my Recent posts and my Most Popular posts sidebar widgets to stop working on the archive pages. I get the error:
WordPress database error: [Unknown column ‘wp_term_taxonomy.term_id’ in ‘where clause’]
and instead of articles, this displays for most popular:
SELECT ID, post_title FROM wp_posts LEFT JOIN wp_ak_popularity pop ON wp_posts.ID = pop.post_id WHERE post_status = ‘publish’ AND post_date < NOW() AND wp_term_taxonomy.term_id = 244 GROUP BY wp_posts.ID ORDER BY pop.total DESC LIMIT 3
and this for recent posts:
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) AND wp_term_taxonomy.term_id = 244 ORDER BY wp_posts.post_date DESC LIMIT 0, 3
Fixed in version 1.1.
This plugin is must have for me .. dont know how could i live whitout it! Thanxxxx goes to great programer .. and as i can see you have great knowladge about architecture of WP .. not my leag :)
Great work, and keep up good work!
it’s beautiful
i wished i could understand how it works
a pity i had to modify it a bit, unfortunately, cause i needed to display the latest entries
so, it applies only to the one category that has many subcategories,
anyway,
thanks !
Greetings, I’m also getting the error: WordPress database error Unknown column ‘wp_term_taxonomy.term_id’ in ‘where clause’ for query SELECT SQL_CALC_FOUND_ROWS
The nice thing is that the plugin still works. This is on WP 2.9.1
Could I convince you to issue a fix for this bug?
Thanks!
Clint
Version 1.1 of the plugin (available http://wordpress.org/extend/plugins/just-one-category/) should fix this issue.
Strange thing happened with version 1.1 to me. It hide my home page category posts. It didn’t do that before. So I had to downgrade back to 1.0 Maybe you could tell me how to customize this plug in to act like a 1.0 then it comes to home page post?
I don’t know what you mean by “home page category” posts. Could you explain more?
Well, if you look at http://www.kawapanga.com homepage, there are categories displayed a bit lover like: “travel ideas”, “travel tips” and “travel the world”.Each show 3 recent emails with a thumb picture. After installing upgrade, it started showing just one post instead of 3. Originally my theme is showing 3 recent posts from those categories on a home page. Before this plug0in would not influence my home page, just normal posts. Now it disrupts work of my home page. Any idea how i could exclude my home page out of plug-ins influence field?
I sent an email to the authors of your theme. Hopefully they can send me a copy so that I can see what my plugin is doing that breaks your site.
Great and useful plugin but does not work for me after updating to 1.1. There seems to be a problem with newer categories/posts which are shown in the parent category although they belong only to the subcategory.
Hm. It works for me. What version of WordPress are you using?
The latest version 2.9.2.
I administrate two blogs with Just One Category. Both use WP 2.9.2, both have professional updated themes but one was broken after updating to 1.1 and the other one wasn’t. The broken one uses Gotham News by Woothemes, the other one Thesis 1.7.
I can not get this to work with 2.9.2. I installed it and NOTHING sub-categories still show up in main categories.
Perhaps it’s one of my other PLUGINS messing it up can you test it?
I have the following installed and active:
1) Category Order
2) Date Exclusion SEO
3) Fast and Secure Contact Form
4) Frontpage Manager
5) Twitter for WordPress
6) WP No Category Base
I must be stupid because I have no clue how to call the functionality of this plugin.
Hi
the plugin is broken since WP Update 3.1
Can you bring a Update for this Plugin please.
Thx
Michael,
I think I fixed just One Category to work with newer versions of WordPress (since 3.1):
In ver. 1.1 Change just_one_cat.php, approx line 39, reads:
$just_one = $wpdb->prepare( " AND $wpdb->term_taxonomy.term_id = %d ", $cat );
Change to:
$just_one = $wpdb->prepare( " AND $wpdb->term_relationships.term_taxonomy_id = %d ", $cat );