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
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
Re: any category listing, any plugin, breaks at the blank between words
jsoo wrote:
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.
Using this plugin, my display time drops to 1.8 seconds.
with this format:
rss_unlimited_categories_list linktosection=“category”
Doesn’t give nested categories, I posted on its orphaned plugin thread.
edit:
It also leads to 404 pages.
The link shows like this, which is wrong: http://crestar.drivein-jim.net/crestar/“category”/adventures
It didn’t make it linkable, as it leads nowhere on my site. I’ll mention this in the plugin thread.
Last edited by JimJoe (2010-02-14 04:05:49)
Offline