Blog Search - Shows Just 1 Result

dosa · Mar 25th 2020

My blog search results are not really working. Here's what I have setup:

1. The search page:

PHP

<?php
perch_content_search(perch_get('q'), [
'apps' => ['PerchBlog'],
'sort' => 'postDateTime',
'count' => '9',
'template'=>'search-result.html',
]);
?>

2. The "search-result.html" template referenced above is:

Code

<perch:before>
<div class="header-text">
<perch:search id="total" /> Articles With "<perch:search id="search_key" />"
</div>
<div class="posts">
<perch:if id="result_source" value="PerchBlog">
<perch:layout path="blog_search_result" url="<perch:search id="result_url" />">
</perch:if>
</div>
<perch:if exists="paging">
<div class="pagination"><perch:if exists="not_first_page">
<a href="<perch:search id="prev_url" encode="false" />">Prev</a>
</perch:if><span>Page <perch:search id="current_page" /> of <perch:search id="number_of_pages" /></span><perch:if exists="not_last_page">
<a href="<perch:search id="next_url" encode="false" />">Next</a>
</perch:if></div>
</perch:if>
</perch:after>
<perch:noresults>
<perch:if exists="search_key">
<h1>Search results for “<perch:search id="search_key" />”</h1>
<perch:else />
</perch:if>
<perch:if exists="search_key">
<p>Sorry, there are no results for “<perch:search id="search_key" />”.</p>
</perch:if>
</perch:noresults>

Display More

3. The "blog_search_result.php" is:

PHP

<?php
$slug = str_replace('/newsroom/', '', perch_layout_var('url', true));
perch_blog_custom([
'template' => 'post_search_result',
'filter' => 'postSlug',
'value' => $slug,
]);
?>

Display More

With all that, the results looks as the should style-wise, but even when the results show a total number of 100 for example, I'm only seeing one single result. The pagination is working. But it's as if I added a 'count' filter, but I didn't. What's missing here?

hus_hmd · Mar 25th 2020

Can you turn on debug mode and share your debug message?

dosa · Mar 25th 2020

Sure, the site is live, so I'll wait until later hours when traffic is lower.

dosa · Mar 25th 2020

hi hus_hmd - here's the debug message after perform a search of "test" and getting 1 results as shown above:

Code

Debug Message - Perch Runway 3.1.5
[706]SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM cms1_pages p LEFT JOIN cms1_page_routes pr ON p.pageID=pr.pageID LEFT JOIN cms1_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 cms1_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /about/newsroom/search, so not using routes.
Using master page: /templates/pages/blog/newsroom-search.php
[44]SELECT DISTINCT settingID, settingValue FROM cms1_settings WHERE userID=0
[1]SELECT * FROM cms1_members_sessions WHERE sessionID='94056fdb5a2c2684306e6a828a15001d1088d516' AND sessionHttpFootprint='7a87e2c0b86900f4f78aba594ac1c33cdc364333' AND sessionExpires>'2020-03-25 16:35:08' LIMIT 1
User is logged in
[1]SELECT * FROM cms1_pages WHERE pagePath='/about/newsroom/search' LIMIT 1
Using template: /templates/pages/attributes/vcy18-seo.html
[46]SELECT regionKey, regionHTML FROM cms1_content_regions WHERE regionPage='/about/newsroom/search' OR regionPage='*' ORDER BY regionPage DESC
[453]SELECT * FROM cms1_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=3 ORDER BY pageTreePosition ASC
[1]SELECT pageTreePosition FROM cms1_pages WHERE pagePath='/about/newsroom/search' LIMIT 1
[3]SELECT pageID FROM cms1_pages WHERE pageTreePosition IN ('000-006-002-008', '000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/item.html
[5]Using template: /templates/navigation/item-3rd.html
[3]Using template: /templates/navigation/item-3rd.html
Using template: /templates/navigation/item-3rd.html
[4]Using template: /templates/navigation/item.html
[4]Using template: /templates/navigation/item.html
[4]Using template: /templates/navigation/item.html
[6]Using template: /templates/navigation/item.html
[8]Using template: /templates/navigation/item.html
[6]Using template: /templates/navigation/item.html
[7]Using template: /templates/navigation/item-3rd.html
Using template: /templates/navigation/item-3rd.html
[8]Using template: /templates/navigation/item.html
[4]Using template: /templates/navigation/item-3rd.html
[7]Using template: /templates/navigation/item-3rd.html
Using template: /templates/search/search-form.html
Search term: test
[9]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 cms1_content_regions WHERE 1=0 UNION SELECT 'PerchBlog_SearchHandler' AS source, MATCH(postTitle, postDescRaw, postTags) AGAINST('test') AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM cms1_blog_posts p, cms1_blog_sections s WHERE postStatus='Published' AND postDateTime<'2020-03-25 16:35:08' AND p.sectionID=s.sectionID AND MATCH(postTitle, postDescRaw, postTags) AGAINST('test') ORDER BY score DESC LIMIT 0, 9
[12]SELECT FOUND_ROWS() AS `count`
[9]Using template: /templates/search/search-result.html
[1]SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM cms1_blog_index idx JOIN cms1_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN cms1_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='postSlug' AND idx.indexValue='client-delivers-stream-analytics')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2020-03-25 16:35:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
[1]SELECT FOUND_ROWS() AS `count`
[1]Using template: /templates/blog/post_search_result.html
[29]SELECT * FROM cms1_blog_authors ORDER BY authorFamilyName, authorGivenName ASC
[4]SELECT * FROM cms1_blog_sections ORDER BY sectionTitle ASC
[1]SELECT * FROM cms1_blogs ORDER BY blogTitle ASC
Request time: 0.04
Process time: 0.0399
Memory: 4.3656

Display More

ellimondo · Mar 26th 2020

Hi

Unless your search-result.html template is redacted, it looks like your perch:before and perch:after tags aren't opening or closing respectively, so that's going to throw up some issues. Especially if you are looping over the search results and taking them into a layout page. It's only going to show one result.

I am assuming here that there's a reason you are calling the layout blog_search_result.php, rather than just show the contents of the search result in the original template.

dosa · Mar 26th 2020

thanks ellimondo - I think you have it right! I have more results now, but they aren't laying out properly. Also when I paginate, the next pages are blank. So I imagine I have the perch:before and perch:after tags in the wrong spot?

Code

<perch:before>
<div class="header-text">
<perch:search id="total" /> Articles With "<perch:search id="search_key" />"
</div>
</perch:before>
<div class="posts">
<perch:if id="result_source" value="PerchBlog">
<perch:layout path="blog_search_result" url="<perch:search id="result_url" />">
</perch:if>
</div>
<perch:after>
<perch:if exists="paging">
<div class="pagination"><perch:if exists="not_first_page">
<a href="<perch:search id="prev_url" encode="false" />">Prev</a>
</perch:if><span>Page <perch:search id="current_page" /> of <perch:search id="number_of_pages" /></span><perch:if exists="not_last_page">
<a href="<perch:search id="next_url" encode="false" />">Next</a>
</perch:if></div>
</perch:if>
</perch:after>
<perch:noresults>
<perch:if exists="search_key">
<h1>Search results for “<perch:search id="search_key" />”</h1>
<perch:else />
</perch:if>
<perch:if exists="search_key">
<p>Sorry, there are no results for “<perch:search id="search_key" />”.</p>
</perch:if>
</perch:noresults>

Display More

hus_hmd · Mar 26th 2020

You may need to move <div class="posts"> inside perch:before and </div> inside perch:after.

dosa · Mar 26th 2020

Looks great, thanks for helping resolve this to you both!