Posts by dosa

dosa · Aug 27th 2020

Setting up a mirror copy of a site for staging and I'm getting this error on my last step in testing it. The CMS works fine, but when viewing the pages, this comes up in most browsers: "cannot decode raw data"

I'm pretty sure I've seen this before but can't remember the fix. hus_hmd - I'm sure you know this A bit of help?

dosa · Aug 3rd 2020

Ok I'll dig in. Thanks hus_hmd

dosa · Jul 28th 2020

That changes the whole method of how my search works. Isn't there a way to simply add the filter for the date?

I tried the above, but again the layout is thrown off. When I try to add the correct template or save the template to the right place, I get blank results.

You helped me do this in this thread: Use The Image In A Blog Post In Search Results

I just didn't realize the order was backwards.

dosa · Jul 27th 2020

Thanks hus_hmd - this worked mostly. The posts are in DESC order by date now finally, but it's not using the template to layout the design. I added the search-result.html template in, but it's not changing anything.

So how do I use the search-result.html template on these results?

dosa · Jul 24th 2020

Hi all - I realized all my blog searches have the order wrong. So I added the sort and sort-order option. But nothing is happening:

Blog results template:

PHP

<?php
$slug = str_replace('/newsroom/', '', perch_layout_var('url', true));
perch_blog_custom([
'template' => 'post_search_result',
'filter' => 'postSlug',
'sort' => 'postDateTime',
'sort-order' => 'ASC',
'value' => $slug,
'paginate' => false,
]);
?>

Display More

So shouldn't the results be showing the post in ascending order by post date?

dosa · Jun 8th 2020

thanks hus_hmd - I had it there, but just fully deleted it and installed the latest. The file structure actually looks very different. That did the trick!

dosa · Jun 8th 2020

Using Perch Runway 3.1.6 with an updated site that I took from 2.8. None of my textarea items are showing the CKeditor though, as if it's missing the editor. I thought it was installed in the core?

The code calls out the editor:

Code

<perch:blog id="postDescHTML" type="textarea" label="Post" editor="ckeditor" html="true" size="xxl autowidth" required="true" />

Diagnostics says it's installed (see attached) and but the CKeditor is missing (see attached).

Thoughts?

dosa · Jun 5th 2020

Ah, thank you. Didn't realize how old the version of this site was.

dosa · Jun 5th 2020

Hi hus_hmd - its 2.8.26 and I plan on upgrading it to 3 once it's install and running on the new server. What did I miss on the install?

dosa · Jun 4th 2020

Hi. Having an odd license issue. I'm moving a site to a new server. I've put up the old files, database, updated the config file with the details, yet I get a "Sorry, your license key isn't valid for this domain."

There are TWO licenses my client has. One I bought when the project started, the other he bought so he could manage it. So there are 2 licenses with the domain name. Could that be the issue? I went into the old license and changed the staging domain name I setup. But it made no difference.

Both license keys don't work. Any solutions to this?

dosa · Mar 31st 2020

Ah great to know. Thank you thank you thank you for all your help hus_hmd

For anyone else looking for the final code for all this, here's how to create your blog search:

Your master page calls the search content, Blog specific, sorted, using a template:

PHP

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

That template is search-result.html:

Code

<perch:before>
<div class="header-text">
<perch:search id="total" /> You searched for "<perch:search id="search_key" />"
</div>
<div class="posts">
</perch:before>
<perch:if id="result_source" value="PerchBlog">
<perch:layout path="blog_search_result" url="<perch:search id="result_url" />">
</perch:if>
<perch:after>
</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">
<h2>Search results for “<perch:search id="search_key" />”</h2>
<perch:else />
<h1>No Results</h1>
</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

Now the key to connecting everything is in the Layout referenced, blog_search_result.php:

PHP

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

Display More

Which references this last template, post_search_result.html:

Code

<article><a href="<perch:blog id="postURL" />"><img src="<perch:blog id="image" />" alt="<perch:blog id="postTitle" />"></a>
<div class="top"> <a href="<perch:blog id="postURL" />" class="title"><perch:blog id="postTitle" /></a>
<perch:if exists="subtitle"><p><perch:blog id="subtitle" striptags="true" /></p></perch:if>
<div class="author">
<perch:if exists="author_image" /><div class="profile"> <img src="<perch:blog id="author_image">"> </div></perch:if>
<div class="content">
<div class="date"><perch:blog id="postDateTime" type="date" time="true" format="M j, Y" /> <span class="name">by <a href="/about/newsroom/authors/<perch:blog id="authorGivenName" type="hidden" urlify />-<perch:blog id="authorFamilyName" type="hidden" urlify />"><perch:blog id="authorGivenName" type="hidden" /> <perch:blog id="authorFamilyName" /></a></span></div>
</div>
</div>
</div>
</article>

Display More

Note the "urlify" links which reuse existing name of the author to make the slug link.

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

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

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

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

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?

dosa · Mar 29th 2020

I realized I don't know exactly what Perch is scrubbing when searching our blog. Is it titles, content, can that be changed?

dosa · Mar 26th 2020

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

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

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

Posts by dosa

"cannot decode raw data"

Search Results Order

Search Results Order

Search Results Order

Search Results Order

CKeditor Missing?

CKeditor Missing?

"Sorry, your license key isn't valid for this domain." BUT IT IS!

"Sorry, your license key isn't valid for this domain." BUT IT IS!

"Sorry, your license key isn't valid for this domain." BUT IT IS!

What Terms Does The Blog Search

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

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

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

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

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

What Terms Does The Blog Search

Blog Search - Shows Just 1 Result

Blog Search - Shows Just 1 Result

Blog Search - Shows Just 1 Result