Blog posts not showing on Home page

Debug Message - Perch 3.0.8
[1] SELECT * FROM perch2_pages WHERE pagePath='/index.php' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=6077
[1] SELECT * FROM perch2_shop_cart WHERE cartID=6077
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[29] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=3 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/index.php' LIMIT 1
[1] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
[7] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/index.php' OR regionPage='*' ORDER BY regionPage DESC
[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' WHERE 1=1 AND ((idx.indexKey='postDateTime' AND idx.indexValue >= '2017-03-26 11:41:18') OR (idx.indexKey='promoinc' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2017-06-26 11:41:00' ) GROUP BY itemID, sortval HAVING count(*)=2 ORDER BY sortval DESC LIMIT 0, 3
[1] SELECT FOUND_ROWS() AS `count`
[55] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Using template: /templates/blog/promo.html
[1] SELECT groupID FROM perch2_navigation WHERE groupSlug='footer' LIMIT 1
[2] 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=1 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 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=1 AND p.pagePath='/index.php' LIMIT 1
[2] Using template: /templates/navigation/footer.html

Hi Drew, Three blog posts are displayed if I strip out the filtering so the issue must be how I've set that up. have I written the filtrer arrays correctly to achieve the intention below?

Display the 3 newest posts (that their "promoinc" field checked OK in the admin) in descending order made in the last three months.

You may be being afflicted by the funny group by issue for multiple filters.

Try this and see if it gives you what you're after:

'filter-mode' => 'ungrouped',

Hi Duncan (Drew),

That's seems to have done the trick! Thank you. I've changed the code in the following way see below… as I'm a designer rather than a programmer is this the correct way of doing this?

<?php perch_blog_custom([
    'template' => 'promo.html',
    'count' => '3',
    'sort' => 'postDateTime',
    'sort-order' => 'DESC',             
    'filter'=>array(
        array(
        'filter' => 'postDateTime',
        'filter-mode' => 'ungrouped', 
        'match' => 'gte',
        'value' => date('Y-m-d H:i:s', strtotime('- 3 MONTHS')),
        ),
        array(
        'filter'=>'promoinc',
        'filter-mode' => 'ungrouped', 
        'match'=>'eq',
        'value'=>1,
        ),
    'filter-mode' => 'ungrouped', 
    )
]); ?>  

I think you probably only need the one at the bottom (the last one)

I thought that had fixed it but it hasn't. I'd left in a stripped down perch_blog_custom call without the filtering which works in that it displays items just not necessarily the ones I want.

Good question. I'll see if I can figure it out. However I'm pretty good at jumping on new updates so on both sites that this problem is occuring blog would not have been older than 4.5.4 or possible 4.5.3 but most likely it would have been version 4.6

Not that I recall

I'm pretty sure that I replaced the core in the normal way, replaced the blog app, uploaded everything, logged into the admin, received the updated noticifcation and that was it.

On both sites that are suffering with the same issue, I've visited the blog app, primarily to check that the last post was within the last 3 months (as that was my initial thought as to why nothing was showing.) I don't recall seeing it/or being told that it was migrating my posts. I haven't tried adding a new post, would that automatically be in the right "format" (i.e. not need migrating)? If so I'll happily create new posts to replace the old ones.

I'll check

They are on separate servers.

Sorry Drew… Yes, I reused it on another site, as I thought it was pretty cool.