Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-07-30 15:27:13
- Soutpiel
- New Member
- From: London
- Registered: 2009-07-28
- Posts: 7
rss_unlimited_categories: default categories overriding new categories
Apologies if this has already been covered, but I can’t seem to find any info on this problem …
I’m relatively new to TXP. I’ve installed the latest version of rss_unlimited_categories (patch 0.7.4p8) and all seems to be working well at first. The multiple category field shows up, I can select more than two, hoorah! (I notice at this point that the old TXP category 1 and category 2 drop-downs are still there in the “Write” tab, but I assume this is okay if I ignore them.)
When I view an article on the website, it displays its multiple categories as it should. Hoorah again.
The problem comes when I try to display articles by list (with the “rss_unlimited_categories_list” tag). Previously (when using the old tag and the default 2 categories) I had summary/listings pages generated from each category in a clean URL “/section/category” format, and this worked fine. In fact it still does work — but only for the OLD “official” categories assigned with the default category drop-downs. Furthermore, when I look under the Categories tab, under Article Categories, the number behind each tag also only reflects the number assigned in the default drop-downs. The new categories all show (0).
I’m hoping I’ve just overlooked some simple thing …
Offline
Re: rss_unlimited_categories: default categories overriding new categories
I believe there is a different way of category storage in the DB for the plugin.
Take a look at the installation instructions where the plugins author mentions that adding this plugin to an exisiting site (with already established categories) that some DB updates are needed as follows:
INSERT INTO textpattern_category (article_id, category_id) SELECT t.id, c.id FROM textpattern t LEFT JOIN txp_category c on t.category1 = c.name where c.type = 'article' and t.category1 != '';
INSERT INTO textpattern_category (article_id, category_id) SELECT t.id, c.id FROM textpattern t LEFT JOIN txp_category c on t.category2 = c.name where c.type = 'article' and t.category2 != '';
I had the sam problem some time ago but I don’t remeber exactly what I did but I did have this link saved in my notes. I’m not that knowledgeable about DB structure but I do know that you are extracting two different DB contents per different screen views. So joining the two places categories are stored should clear it all up. Wish I could tell you more but I’m pretty sure this is a good place to start.
Ah, and it looks like you already placed this post in the prefered place.
Edit: I reposted this to the prefered place.
Last edited by whaleen (2009-07-30 22:18:19)
txtstrap (Textpattern + Twitter Bootstrap + etc…)
Offline
#3 2009-07-31 09:30:29
- Soutpiel
- New Member
- From: London
- Registered: 2009-07-28
- Posts: 7
Re: rss_unlimited_categories: default categories overriding new categories
Many thanks, whaleen.
Apologies for double-posting. After not getting replies for a few days on the Author Support post I wondered if that thread had been discontinued so re-posted here.
I guess we should consider this thread terminated, and continue here
Offline