Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: any category listing, any plugin, breaks at the blank between words
JimJoe wrote:
It goes much faster.
…
I should mention that the previous blog was slow as well. So I don’t think its a plugin problem so much as a possible database problem.
How much faster? If you get normal performance (page processing time of .3 seconds or less) without the category menu, then the problem is the category menu. If the page is much slower than this even without the category menu, go back to debugging mode and find the slow queries.
But if you think it’s a database problem you should look it over in phpMyAdmin or whatever you use for db management; in particular check over the txp_category and textpattern tables and see that the numbers of rows are what you expect for the number of categories and articles you have.
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
It doesn’t get 0.3 seconds to display the page. I’ll check, I think its more like 2-3 seconds.
If there was somehow to add just a third category listing I could select from, that might work instead of unlimited categories.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Well, its 0.35 for queries without plugin.
What puzzles me is that previous blogs/cms were slow to. So I don’t think it is just this plugin. It was slow with Movable Type and with Word Press.
I did do a repair and check db in phpmyadmin. I didn’t notice any difference.
Offline
Re: any category listing, any plugin, breaks at the blank between words
JimJoe wrote:
If there was somehow to add just a third category listing I could select from, that might work instead of unlimited categories.
I don’t know of an in-between solution. While you can use custom fields sort of like categories, you can’t integrate them into standard category lists. So if you need more than 2 categories per article, rss_unlimited_categories is the only solution I know.
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
I’ll check into it when I get the chance, busy week.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Okay, I have installed rss_unlimited_categories plugin. The two insert commands that copy over already present articles and categories gives me this error message:
ErrorSQL query: Documentation
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 != ‘’;
- - Table ‘drivein_txtp.textpattern_category’ doesn’t exist
Offline
Re: any category listing, any plugin, breaks at the blank between words
Okay. I looked over my table structure and I see:
Browse drivein_textpattern
Browse drivein_textpattern_category
Browse drivein_txp_category
I don’t know any sql commands. How would I reword the insert commands to work with this structure ?
Thank you.
Offline
Re: any category listing, any plugin, breaks at the blank between words
From the error message it appears rss_unlimited_categories is confused about table prefixes. It’s asking for drivein_txtp.textpattern_category. I’d try scanning the plugin’s support forum thread, although because it’s an orphan plugin you may be out of luck.
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
Well, if I knew what change to make in the insert comands, I think it would then work. More of a lack of knowledge of sql commands on my part. I just fail to see where it is adding in the ‘_txp.’ part of it. The rest of the structure is there.
Offline
Re: any category listing, any plugin, breaks at the blank between words
I’ll leave both plugins up and running. Where it says ‘Categories new type rss’ on the right sidebar is what the rss plugin is showing. Basically, I have entered only 1 article using it, so the two lines are al lthat is showing.
If I could figure out how to alter the sql insert command. I think it would work.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Oh, the insert commands I am having problems with are not part of the plugin.
They are suggestions on how to take already entered articles into the multiple category plugin listings for rss_unlimited_categories. It is just to make it easier so I don’t have to go back and re-categorize hundreds of entries.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Got it. I think. I just had to prepend drivein_ throughout the sql commands to the category names. Worked after that. I just have to get it to display them properly nested.
Offline
Re: any category listing, any plugin, breaks at the blank between words
OK, didn’t realize you had to run the SQL manually. You need to add the appropriate table prefix yourself. So,
INSERT INTO drivein_textpattern_category (article_id, category_id) SELECT t.id, c.id FROM drivein_textpattern t LEFT JOIN drivein_txp_category c on t.category1 = c.name where c.type = 'article' and t.category1 != '';and likewise for category2.
Edit: Ha, you beat me to it.
Last edited by jsoo (2010-02-13 16:18:18)
Code is topiary
Offline
Re: any category listing, any plugin, breaks at the blank between words
Thanks for the followup.
I am having a bit of trouble deciding on how to use what format to give me the same nested categories as with the stw_category_tree plugni.
Offline
Re: any category listing, any plugin, breaks at the blank between words
Until I can spend the time to figure out rss_unlimited_categories plugin options, I’ll leave my site using the previous plugin. Just too many things to do, I don’t want my weekend to be hectic like my work week.
Offline