Blog Search Shows Only 1 Page of Results - Paginated Pages Are Blank

dosa · Mar 30th 2020

Using this for the search results:

PHP

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

I'm getting 12 results for a search of "test". Yet the page shows the first 9 results, then the second page is blank. In fact ALL searches are showing the first 9 results then all the remaining pages, even if there are 100 results, are all blank. What is missing from the code to where it's following the count, but only on one page?

hus_hmd · Mar 30th 2020

Can you turn on debug mode and share the debug message from the second page?

dosa · Mar 30th 2020

Here you go hus_hmd - the debug message is below in two comments since it's beyond the 10,000 character limit per post.

Code

Debug Message - Perch Runway 3.1.5
[708]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='799c6074725406ded049229d1b992eabb5707cd0' AND sessionHttpFootprint='7a87e2c0b86900f4f78aba594ac1c33cdc364333' AND sessionExpires>'2020-03-30 11:45:16' 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
[454]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

Display More

Code

dosa · Mar 30th 2020

Debug continued....

Code

Search term: rip
[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 cms1_content_regions WHERE 1=0 UNION SELECT 'PerchBlog_SearchHandler' AS source, MATCH(postTitle, postDescRaw, postTags) AGAINST('rip') AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM cms1_blog_posts p, cms1_blog_sections s WHERE postStatus='Published' AND postDateTime<'2020-03-30 11:45:16' AND p.sectionID=s.sectionID AND MATCH(postTitle, postDescRaw, postTags) AGAINST('rip') ORDER BY score DESC LIMIT 9, 9
[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, postDateTime AS score, postTitle, postSlug, postDateTime, postDescHTML, postID, sectionSlug, "", "" FROM cms1_blog_posts p, cms1_blog_sections s WHERE postStatus='Published' AND postDateTime<'2020-03-30 11:45:16' AND p.sectionID=s.sectionID AND ( concat(" ", postTitle, " ") REGEXP '[[:<:]]rip[[:>:]]' OR concat(" ", postDescRaw, " ") REGEXP '[[:<:]]rip[[:>:]]' OR concat(" ", postTags, " ") REGEXP '[[:<:]]rip[[:>:]]' ) ORDER BY score ASC LIMIT 9, 9
[47]SELECT FOUND_ROWS() AS `count`
[9]Using template: /templates/search/search-result.html
[nil]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='company-infosys-partnership')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='vtalk-for-company-communications-cloud')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='top-10-industry-cloud-moments-from-dreamforce-16')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='company-partner-matrixx-wins-stevie-award')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='company-wins-industry-awards-named-as-crm-watchlist-winner')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='2017-tm-forum-excellence-awards')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='company-wins-leading-lights-awards-for-2017')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='ai-meets-enterprise-collaboration')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
[nil]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='company-wins-2017-stevie-award-favorite-new-product')) 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-30 11:45:00' ) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 10, 10
[1]SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_search_result.html
Request time: 0.1059
Process time: 0.1057
Memory: 4.3895

Display More

hus_hmd · Mar 30th 2020

This looks like the same project as the threads you started before. You display the blog posts from a layout. I think you need to disable the pagination in your perch_blog_custom() call.

dosa · Mar 30th 2020

It's the same issue? It's using the same template. I just commented out the pagination call, results are no different.

hus_hmd · Mar 30th 2020

To disable the pagination you would set the paginate option to false:

PHP

perch_blog_custom([
'template' => 'post_search_result',
'filter' => 'postSlug',
'value' => $slug,
'paginate' => false,
]);

dosa · Mar 30th 2020

Awesome! That did it. I didn't realize it had to be specifically off, I commented it out thinking that removed it. So I guess there was a pagination loop happening. Thanks for the fix!

On a related note, what is the search searching - blog post titles, descriptions, content, all?

dosa Mar 30th 2020