Problem showing Categories with multiple blogs and default post template issues

Have you tried turning on debug on the page that contains perch_blog_category(perch_get('cat'), true) to see what query is being sent to the database?

I don't know this for sure, but I wonder if the Blog ES set name is causing issues - maybe the category slug isn't forming correctly or something daft. That's the only difference between your blog and blob es sets.

Hi Duncan,

Thanks for your reply.

I've had a look at Debug on an archive page that is displaying as expected and an archive that isn't working as expected. The EN page mentions the catPath as follows:

SELECT * FROM perch2_categories WHERE catPath='blog/people/' LIMIT 1

And on the ES page I'm getting:

SELECT * FROM perch2_categories WHERE catPath='blog/gente/' LIMIT 1

but of course I'd expect the catPath to be blog-es/gente.

I'll try renaming the category sets and see if that make any difference. Thanks again for your input — much appreciated.

No problem.

It might just be that the link to that page isn't being formed properly - is your category_link.html template hard coding blog/ at the start of the path or something?

But without a doubt, debug always helps - in fact if I'm developing anything, I leave debug turned on all the time, just to see exactly what's going on...

Yes, the links from the category_link.html are all as I'd expect them to be.

So I changed the category set name from Blog ES to Noticias (with a slug of noticias) and am still having issues. Output from the following will now correctly show all categories in use for the EN blog but shows categories from both blogs when variable $blog returns the slug of the ES blog:

<?php
                    perch_blog_categories(array(
                        'blog' => $blog,
                        'template' => 'category_link.html',
                        'cache' => false,
                    ));
                ?>

And the issue of the post template being change when a save is made in the Meta and Social Tab still persists.

The category archive (on the ES blog) still doesn't output as expected/hoped. This is Debug output on a category archive page for a category called Gente that I'd expect to be in the Noticias set.

Debug Message - Perch Runway 3.0.1
[79] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: es/noticias/archive/category/[slug:cat]
Using master page: \templates\pages\blog\archive.php
Page arguments:
Array
(
    [0] => /es/noticias/archive/category/gente
    [cat] => gente
    [1] => gente
)
Fetching from cache: perch_blog_categoryf146750e9027c272ca3213a49800255d
Cache file not found: perch_blog_categoryf146750e9027c272ca3213a49800255d
[1] SELECT * FROM perch2_categories WHERE catPath='blog/gente/' LIMIT 1
[15] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/es/noticias/archive' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/es' OR pageSortPath='/es' LIMIT 1
[2] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/es/noticias/archive' LIMIT 1
[3] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004-001-003', '000-004-001', '000-004', '000') ORDER BY pageTreePosition DESC
[1] Using template: \templates\navigation\main-nav.html
[0] SELECT groupID FROM perch2_navigation WHERE groupSlug='es-bookings-las-terrazas' LIMIT 1
[nil] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=0 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/es/noticias/archive' OR pageSortPath='/es/noticias/archive' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageTreePosition='000-004-001' LIMIT 1
[nil] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004-001%' ORDER BY pageTreePosition ASC
Fetching from cache: perch_blog_categoryf146750e9027c272ca3213a49800255d
Cache file not found: perch_blog_categoryf146750e9027c272ca3213a49800255d
[1] SELECT * FROM perch2_categories WHERE catPath='blog/gente/' LIMIT 1
[0] SELECT DISTINCT idx.itemID FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'blog/gente/%' OR idx.indexKey='_category' AND idx.indexValue='blog/gente/'))
[1] SELECT blogID FROM perch2_blogs WHERE blogSlug='noticias' LIMIT 1
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' AND idx.itemID IN (NULL) WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE ( blogID=3 AND postStatus='Published' AND postDateTime<='2017-04-12 16:56:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 10
[1] SELECT FOUND_ROWS() AS `count`
[46] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Using template: \templates\blog\post_in_list.html
[1] SELECT blogID FROM perch2_blogs WHERE blogSlug='noticias' LIMIT 1
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE ( blogID=3 AND postStatus='Published' AND postDateTime<='2017-04-12 16:56:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 10
[1] SELECT FOUND_ROWS() AS `count`
[1] Using template: \templates\blog\recent_posts_subnav.html
[1] SELECT * FROM perch2_blog_sections ORDER BY sectionTitle ASC
[2] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM perch2_blogs WHERE blogSlug='noticias' LIMIT 1
[0] SELECT setID FROM perch2_category_sets WHERE setSlug='blog-es' LIMIT 1
[7] SELECT main.* , COALESCE(cc.countValue,0) AS `count.blog.post` FROM perch2_categories main LEFT OUTER JOIN perch2_category_counts cc ON cc.catID=main.catID WHERE 1=1 AND (cc.countType='blog.post' OR cc.countType IS NULL) AND cc.countValue > 0 ORDER BY catTreePosition ASC
[7] Using template: \templates\blog\category_link.html
[1] SELECT groupID FROM perch2_navigation WHERE groupSlug='es-footer-menu' LIMIT 1
[1] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=12 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=12 AND p.pagePath='/es/noticias/archive' LIMIT 1
[1] Using template: \templates\navigation\footer-nav.html
Debug Message - Perch Runway 3.0.1
[79] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: es/noticias/archive/category/[slug:cat]
Using master page: \templates\pages\blog\archive.php
Page arguments:
Array
(
    [0] => /es/noticias/archive/category/gente
    [cat] => gente
    [1] => gente
)
Fetching from cache: perch_blog_categoryf146750e9027c272ca3213a49800255d
Cache file not found: perch_blog_categoryf146750e9027c272ca3213a49800255d
[1] SELECT * FROM perch2_categories WHERE catPath='blog/gente/' LIMIT 1
[15] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/es/noticias/archive' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/es' OR pageSortPath='/es' LIMIT 1
[2] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/es/noticias/archive' LIMIT 1
[3] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-004-001-003', '000-004-001', '000-004', '000') ORDER BY pageTreePosition DESC
[1] Using template: \templates\navigation\main-nav.html
[0] SELECT groupID FROM perch2_navigation WHERE groupSlug='es-bookings-las-terrazas' LIMIT 1
[nil] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=0 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/es/noticias/archive' OR pageSortPath='/es/noticias/archive' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageTreePosition='000-004-001' LIMIT 1
[nil] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004-001%' ORDER BY pageTreePosition ASC
Fetching from cache: perch_blog_categoryf146750e9027c272ca3213a49800255d
Cache file not found: perch_blog_categoryf146750e9027c272ca3213a49800255d
[1] SELECT * FROM perch2_categories WHERE catPath='blog/gente/' LIMIT 1
[0] SELECT DISTINCT idx.itemID FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'blog/gente/%' OR idx.indexKey='_category' AND idx.indexValue='blog/gente/'))
[1] SELECT blogID FROM perch2_blogs WHERE blogSlug='noticias' LIMIT 1
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' AND idx.itemID IN (NULL) WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE ( blogID=3 AND postStatus='Published' AND postDateTime<='2017-04-12 16:56:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 10
[1] SELECT FOUND_ROWS() AS `count`
[46] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Using template: \templates\blog\post_in_list.html
[1] SELECT blogID FROM perch2_blogs WHERE blogSlug='noticias' LIMIT 1
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE ( blogID=3 AND postStatus='Published' AND postDateTime<='2017-04-12 16:56:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 10
[1] SELECT FOUND_ROWS() AS `count`
[1] Using template: \templates\blog\recent_posts_subnav.html
[1] SELECT * FROM perch2_blog_sections ORDER BY sectionTitle ASC
[2] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM perch2_blogs WHERE blogSlug='noticias' LIMIT 1
[0] SELECT setID FROM perch2_category_sets WHERE setSlug='blog-es' LIMIT 1
[7] SELECT main.* , COALESCE(cc.countValue,0) AS `count.blog.post` FROM perch2_categories main LEFT OUTER JOIN perch2_category_counts cc ON cc.catID=main.catID WHERE 1=1 AND (cc.countType='blog.post' OR cc.countType IS NULL) AND cc.countValue > 0 ORDER BY catTreePosition ASC
[7] Using template: \templates\blog\category_link.html
[1] SELECT groupID FROM perch2_navigation WHERE groupSlug='es-footer-menu' LIMIT 1
[1] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch2_navigation_pages np, perch2_pages p WHERE p.pageID=np.pageID AND np.groupID=12 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch2_pages p, perch2_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=12 AND p.pagePath='/es/noticias/archive' LIMIT 1
[1] Using template: \templates\navigation\footer-nav.html
Request time: 0.1606
Process time: 0.155
Memory: 3.4318

Any suggestions very gladly received!

I have a feeling that the blog app might be restricted to using the blog category set - it's hard coded to do so.

You/I might need to do some forum searches to confirm that.

Good call, Duncan, thanks. I've been able to make some progress ;)

I can get the archive page to show the listings as I'd expect (thanks to this post https://forum.grabaperch.com/forum/12-16-2015-does-a-category-set-have-still-have-to-be-called-blog-to-work-with-the-blog-app), which leaves me with two remaining issues: edits to the Meta and Social tab changing the post template in such as way that I can't change it back, and the perch_blog_categories function not outputting just the categories of the ES blog when I expect it to.

Progress though... thanks for your help.

OK, I have it down to just one issue now, I think. And that's the issue of the post template being switched when I make an edit/save in the Meta and Social tab, and this has me stumped. If I could switch it back manually then that's something I could live with right now but I can't see any option for that. Unless I'm missing something?

This last issue seems to be because my alternative post template for the ES blog was in /blog and not /blog/posts so I guess that was messing things up. Pleased to say this all appears to be resolved now ;)