Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#37 2010-02-13 15:25:02

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#38 2010-02-13 15:31:35

jsoo
Plugin Author
From: NC, USA
Registered: 2004-11-15
Posts: 1,793
Website

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

#39 2010-02-13 15:45:42

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#40 2010-02-13 15:48:39

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#41 2010-02-13 15:59:46

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#42 2010-02-13 16:14:20

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#43 2010-02-13 16:18:00

jsoo
Plugin Author
From: NC, USA
Registered: 2004-11-15
Posts: 1,793
Website

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

#44 2010-02-13 16:33:52

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#45 2010-02-13 16:57:08

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

#46 2010-02-14 03:57:01

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

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

Board footer

Powered by FluxBB