No data from blog search results

dcus2018 · Sep 6th 2019

Built out a multilingual site built on perch runway and uses a branch method to organise content.

Having some trouble with searching the site content from the blog application. For some reason I can't get any data from the blog app even if I specify the blog independently through the source. I am pretty sure this is something I have overlooked as at one point at least I could retrieve the blog title within the results, however no I get nothing even when targeting the blog by app alone.

The blog itself is broken down into listing for each lang variable (i.e 'en' and 'de')

Thanks in advance

PHP

<?php
$query = perch_get('q');
perch_content_search($query, array(
'data' => [
'lang_uppercase' => strtoupper($vars['lang']),
],
'count' => 6,
'from-path' => '/' . $vars['lang'],
'excerpt-chars' => 300,
'template' => 'site-search-result.html',
));
// target the blog alone to try and get some data
perch_content_search($query, array(
'template' => 'blog-search-result.html',
'apps' => ['PerchBlog'],
));
?>

Display More

Code

<perch:before>
<div class="row">
<div class="col-12 ta-c">
<div class="h1 h1--sm"><perch:search id="total" /> results for "<span class="h2"><perch:search id="search_key" /></span>"</div>
</div>
</div>
<hr />
<ul class="search--grid row grid-list">
</perch:before>
<li class=" col-lg-6 <perch:search id="perch_item_odd" />">
<perch:if id="source" match="eq" value="PerchContent_RunwaySearch">
<perch:if id="result_url" match="eq" value="Projects"/>
<a href="/<perch:search id="lang" /><perch:trans id="lang.projects.url" /><perch:translate id="result_slug" en="{result_slug_en}" de="{result_slug_de}" explicit="true" html="true"/>/" class="eq-margin">
</perch:if>
<perch:if id="result_url" match="eq" value="Downloads"/>
<a href="/<perch:search id="lang" /><perch:trans id="lang.downloads.url" /><perch:translate id="result_slug" en="{result_slug_en}" de="{result_slug_de}" explicit="true" html="true"/>/" class="eq-margin">
</perch:if>
<perch:if id="result_url" match="eq" value="Locations"/>
<a href="/<perch:search id="lang" /><perch:trans id="lang.locations.url" />#location-<perch:translate id="division_en" en="{division_en}" de="{division_de}" explicit="true" />" class="eq-margin">
</perch:if>
<perch:if id="result_url" match="eq" value="Team"/>
<a href="/<perch:search id="lang" /><perch:trans id="lang.about.url" />#team--<perch:search id="dataID"/>" class="eq-margin">
</perch:if>
</perch:if>
<perch:if id="source" match="eq" value="PerchContent">
<a href="<perch:search id="result_url" />/" class="eq-margin">
</perch:if>
<perch:if id="source" match="eq" value="PerchBlog">
<a href="/<perch:search id="lang" /><perch:search id="result_url" />" class="eq-margin">
</perch:if>
<div class="eq-margin">
<h3 class="h2 h2--sm text-color--pink"><perch:if id="result_title" value="{lang_uppercase}"><perch:trans id="lang.search.home" /> - </perch:if><perch:search id="result_title" /></h3>
<perch:if exists="result_excerpt"><p class="excerpt">"<perch:search id="result_excerpt" encode="false" html="true"/>…"</p></perch:if>
</div>
<span class="link link--right">
<span><perch:trans id="lang.search.cta" /></span>
<svg class="icon--arrow-r icon--svg" viewBox="0 0 30 18">
<use xlink:href="/assets/svg/svg-defs.svg#icon--arrow-r"></use>
</svg>
</span>
<hr />
</a>
</li>
<perch:after>
</ul>
<perch:if exists="paging">
<div class="row ta-c">
<div class="col-12 ta-c eq-margin">
<div class="h3">
<perch:trans id="lang.search.paging.page" /> <perch:search id="current_page" /> <perch:trans id="lang.search.paging.of" /> <perch:search id="number_of_pages" />
</div>
<perch:if exists="not_first_page">
<a class="btn btn--skew btn--fill" href="<perch:search id="prev_url" encode="false" />"><span><perch:trans id="lang.search.prev" /></span></a>
<perch:else>
<span class="btn btn--skew btn--disabled"><span><perch:trans id="lang.search.prev" /></span></span>
</perch:if>
<perch:if exists="not_last_page">
<a class="btn btn--skew btn--fill" href="<perch:search id="next_url" encode="false" />"><span><perch:trans id="lang.search.next" /></span></a>
<perch:else>
<span class="btn btn--skew btn--disabled"><span><perch:trans id="lang.search.next" /></span></span>
</perch:if>
</div>
</div>
</perch:if>
</perch:after>
<perch:noresults>
<div class="col-12 ta-c">
<perch:if exists="search_key">
<perch:trans id="lang.search.result.none" /> "<perch:search id="search_key" />"
<perch:else />
<perch:trans id="lang.search.result.empty" />
</perch:if>
</div>
</perch:noresults>

Display More

dcus2018 · Sep 6th 2019

0.0729	0.0022	[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT 'PerchContent_SearchHandler' AS source, MATCH(ci.itemSearch) AGAINST('a') AS score, r.regionPage AS col1, ci.itemSearch AS col2, ci.itemJSON AS col3, r.regionOptions AS col4, p.pageNavText AS col5, p.pageTitle AS col6, regionTemplate AS col7, r.regionKey AS col8 FROM perch_content_regions r, perch_content_items ci, perch_pages p WHERE r.regionID=ci.regionID AND r.regionRev=ci.itemRev AND r.pageID=p.pageID AND r.regionPage!='*' AND r.regionSearchable=1 AND (MATCH(ci.itemSearch) AGAINST('a') OR MATCH(ci.itemSearch) AGAINST('a') ) AND (r.regionPage LIKE '/en%') UNION SELECT 'PerchContent_RunwaySearch' AS source, MATCH(ci.itemSearch) AGAINST('a') AS score, c.collectionKey AS col1, ci.itemSearch AS col2, ci.itemJSON AS col3, c.collectionOptions AS col4, c.collectionKey AS col5, c.collectionKey AS col6, collectionTemplate AS col7, c.collectionKey AS col8 FROM perch_collections c, perch_collection_items ci, perch_collection_revisions cr WHERE c.collectionID=cr.collectionID AND cr.itemID=ci.itemID AND cr.itemRev=ci.itemRev AND c.collectionSearchable=1 AND cr.itemSearchable=1 AND (MATCH(ci.itemSearch) AGAINST('a') OR MATCH(ci.itemSearch) AGAINST('a') ) UNION SELECT 'PerchBlog_SearchHandler' AS source, MATCH(postTitle, postDescRaw, postTags) AGAINST('a') AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM perch_blog_posts p, perch_blog_sections s WHERE postStatus='Published' AND postDateTime<'2019-09-06 11:06:33' AND p.sectionID=s.sectionID AND MATCH(postTitle, postDescRaw, postTags) AGAINST('a') ORDER BY score DESC LIMIT 0, 6
0.077	0.0042	[6] SELECT SQL_CALC_FOUND_ROWS DISTINCT 'PerchContent_SearchHandler' AS source, 0-(LENGTH(r.regionPage)-LENGTH(REPLACE(r.regionPage, '/', ''))) AS score, r.regionPage AS col1, ci.itemSearch AS col2, ci.itemJSON AS col3, r.regionOptions AS col4, p.pageNavText AS col5, p.pageTitle AS col6, regionTemplate AS col7, r.regionKey AS col8 FROM perch_content_regions r, perch_content_items ci, perch_pages p WHERE r.regionID=ci.regionID AND r.regionRev=ci.itemRev AND r.pageID=p.pageID AND r.regionPage!='*' AND r.regionSearchable=1 AND ci.itemSearch REGEXP '[[:<:]]a[[:>:]]' AND (r.regionPage LIKE '/en%') UNION SELECT 'PerchContent_RunwaySearch' AS source, 1 AS score, c.collectionKey AS col1, ci.itemSearch AS col2, ci.itemJSON AS col3, c.collectionOptions AS col4, c.collectionKey AS col5, c.collectionKey AS col6, collectionTemplate AS col7, c.collectionKey AS col8 FROM perch_collections c, perch_collection_items ci, perch_collection_revisions cr WHERE c.collectionID=cr.collectionID AND cr.itemID=ci.itemID AND cr.itemRev=ci.itemRev AND c.collectionSearchable=1 AND cr.itemSearchable=1 AND ci.itemSearch REGEXP '[[:<:]]a[[:>:]]' UNION SELECT 'PerchBlog_SearchHandler' AS source, postDateTime AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM perch_blog_posts p, perch_blog_sections s WHERE postStatus='Published' AND postDateTime<'2019-09-06 11:06:33' AND p.sectionID=s.sectionID AND ( concat(" ", postTitle, " ") REGEXP '[[:<:]]a[[:>:]]' OR concat(" ", postDescRaw, " ") REGEXP '[[:<:]]a[[:>:]]' OR concat(" ", postTags, " ") REGEXP '[[:<:]]a[[:>:]]' ) ORDER BY score ASC LIMIT 0, 6
0.0896	0.0126	[69] SELECT FOUND_ROWS() AS `count`
0.092	0.0024	[6] Using template: /templates/search/site-search-result.html
0.0988	0.0067	Using translation: en.lang.search.home
0.0988	0	Using translation: en.lang.search.cta
0.0989	0	Using translation: en.lang.search.home
0.0989	0	Using translation: en.lang.search.cta
0.0989	0	Using translation: en.lang.search.cta
0.0989	0	Using translation: en.lang.search.cta
0.0989	0	Using translation: en.lang.search.cta
0.099	0	Using translation: en.lang.search.cta
0.099	0	Using translation: en.lang.search.paging.page
0.099	0	Using translation: en.lang.search.paging.of
0.099	0	Using translation: en.lang.search.prev
0.0991	0	Using translation: en.lang.search.next
0.1001	0.0011	Search term: a
0.1002	0.0001	[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT 'PerchContent_SearchHandler' AS source, '' AS score, '' AS col1, '' AS col2, '' AS col3, '' AS col4, '' AS col5, '' AS col6, '' AS col7, '' AS col8 FROM perch_content_regions WHERE 1=0 UNION SELECT 'PerchBlog_SearchHandler' AS source, MATCH(postTitle, postDescRaw, postTags) AGAINST('a') AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM perch_blog_posts p, perch_blog_sections s WHERE postStatus='Published' AND postDateTime<'2019-09-06 11:06:33' AND p.sectionID=s.sectionID AND MATCH(postTitle, postDescRaw, postTags) AGAINST('a') ORDER BY score DESC LIMIT 0, 10
0.1031	0.0028	[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT 'PerchContent_SearchHandler' AS source, '' AS score, '' AS col1, '' AS col2, '' AS col3, '' AS col4, '' AS col5, '' AS col6, '' AS col7, '' AS col8 FROM perch_content_regions WHERE 1=0 UNION SELECT 'PerchBlog_SearchHandler' AS source, postDateTime AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM perch_blog_posts p, perch_blog_sections s WHERE postStatus='Published' AND postDateTime<'2019-09-06 11:06:33' AND p.sectionID=s.sectionID AND ( concat(" ", postTitle, " ") REGEXP '[[:<:]]a[[:>:]]' OR concat(" ", postDescRaw, " ") REGEXP '[[:<:]]a[[:>:]]' OR concat(" ", postTags, " ") REGEXP '[[:<:]]a[[:>:]]' ) ORDER BY score ASC LIMIT 0, 10
0.1046	0.0015	[0] SELECT FOUND_ROWS() AS `count`
0.105	0.0004
0.1053	0.0003	[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch_content_regions WHERE regionKey='Footer Form' AND (regionPage='/en/search' OR regionPage='*')
0.1061	0.0008	[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch_content_index idx JOIN perch_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=68 AND idx.itemRev=14)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

dcus2018 · Sep 9th 2019

Since opening the ticket I have tried a couple of things with no you...

First of all I have noticed that when I originally setup the template for the main body of the article in the blog template I was using template tag with an ID of ’text’ when I think the ID should have been ‘postDescHTML’.

Code

<perch:blog id="text" type="textarea" label="Text" html="true" size="xl" editor="redactor" editor-config="basic" order="15" required="true" divider-before="Article Content"/>
<perch:blog id="postDescHTML" type="textarea" label="Text" html="true" size="xl" editor="redactor" editor-config="basic" order="15" required="true" divider-before="Article Content"/>

I am guessing the reason for this is because built into perch is functionality that takes data from this and adds it to the database rows postDescRaw and postDescHTML as before I changed this in my local environment both columns, postDescRaw and postDescHTML where listed as NULL. So I have sorted this however it still does not work but thinking this will need to be applied to the live site at some point anyway.

I have also tried cloning the default blog post and applying this in place of my template and also creating some test blogs however this is still not working.

Any way as the above has still not worked I was looking at the table within phpMyAdmin and noticed the tables linked in the search ‘perch_blog_posts' and ‘perch_blog_sections’. The 2 columns I think that join the tables are ’sectionID’ and ‘blogID’ do not match up with any of the sections maybe this could have something to do with returning no results on blogs?

Is there any thing else I could do to try and debug my issue

marc · Sep 10th 2019

Managed to fix the issue. It turns out that a blog article had to be attributed to a blog section to appear in the results.

I have never come across this before, just wondering if anyone else had?

drewm Sep 6th 2019