Blog post element broken when Woocommerce is activated

Hey wtechgr,

Thank you for the inquiry.

Would you mind providing a screenshot of the issue? We checked the site and the blog posts elements in the home page only display items from the selected categories (Certifications, Private Sessions).

Best regards,
Ismael

Hi,

Thank you for the update.

We can now reproduce the issue on our end. Looks like the posts from the MasterStudy LMS plugin are getting included in the blog posts element when Woocommerce is enabled. We are not yet sure why that is happening, but adding this filter in the functions.php file should help.

function avia_masonry_entries_query_mod($query, $params) {	
    foreach($query['post_type'] as $key => $value) {
        if( $value == 'stm-lessons' ) {
            unset($query['post_type'][$key]);
        }      
    }

    return $query;
}
add_filter('avia_masonry_entries_query', 'avia_masonry_entries_query_mod', 10, 2);

Removing the post type “stm-lessons” should hide the unwanted posts.

Best regards,
Ismael

Hi,

Thank you for the info.

We modified the filter in the functions.php file so that it only queries posts from the default post type, which works but for some reason, all items from the post type are now displaying regardless of the selected category in the blog posts settings. Looks like there is something in the site that overrides the blog posts query.

We cannot reproduce the same issue on our installation, so this is probably caused by a plugin. Is there a staging or development version of the site? Can we deactivate the plugins temporarily?

Best regards,
Ismael

Hi,
I’m not sure if this will help your situation, but at the start of this thread you said that your issues seem to start when the woocommerce plugin is activated, if you are using WooCommerce 5.7.1 try downgrading to 5.6.1, in another thread woocommerce said that there was a known bug in 5.7.1 that caused issues on some sites. Perhaps this is your issue. I couldn’t login to your site and my keyboard doesn’t respond correctly on your site so it’s hard to say.

Best regards,
Mike

Hi,

Thank you for the access.

The issue does not occur when we disabled all plugins except Woocmmerce, so the issue is not entirely due to the shop plugin. It only occurs when both MasterStudy LMS and the Woocommerce plugin is enabled. And the reason why the blog posts element display all posts when the plugins are enabled is because the default query..

SELECT wp_posts.*
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (4) )
AND wp_posts.post_type IN ('post', 'page', 'attachment', 'revision', 'nav_menu_item', 'custom_css', 'customize_changeset', 'oembed_cache', 'user_request', 'wp_block', 'wp_template', 'scheduled-action', 'product', 'product_variation', 'shop_order', 'shop_order_refund', 'shop_coupon', 'portfolio', 'avia_framework_post')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 13
AND wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC

.. gets transformed to..

SELECT wp_posts.*
FROM wp_posts
WHERE 1=1
AND wp_posts.post_type IN ('post', 'page', 'attachment', 'revision', 'nav_menu_item', 'custom_css', 'customize_changeset', 'oembed_cache', 'user_request', 'wp_block', 'wp_template', 'product', 'product_variation', 'shop_order', 'shop_order_refund', 'shop_coupon', 'stm-courses', 'stm-lessons', 'stm-quizzes', 'stm-questions', 'stm-reviews', 'stm-orders', 'stm-payout', 'portfolio', 'avia_framework_post')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 13
AND wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC

.. and this part of the query that is supposed to retrieve posts from the selected category gets omitted.

LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)

It is possible that the plugin is using the pre_get_posts filter somewhere in its code base and overrides the blog posts query. You may need to contact the developers of the Master Study LMS plugin for additional assistance regarding the issue.

Best regards,
Ismael

Hi,

Thank you for the update.

Can we access the file server? We will try to trace and debug the issue inside the LMS plugin. Additional info from the plugin developers will help.

It is possible that the plugin is using the pre_get_posts filter somewhere in its code base and overrides the blog posts query. You may need to contact the developers of the Master Study LMS plugin for additional assistance regarding the issue.

Please try to forward the above statement to the plugin developers, or just ask them if the pre_get_posts filter is used or added somewhere in the plugin.

Best regards,
Ismael

Hi,

Thank you for the info.

What happens when you temporarily disable the filter by commenting it out?

// add_filter(‘pre_get_posts’, ‘STM_LMS_Instructor::posts_for_current_author’);

We may need to access the file server in order to properly check the issue.

Best regards,
Ismael

Hi,

Unfortunately, we are still not sure why the issue occurs but we have found out that it only happens when the Pro version of the LMS plugin is activated. We activated the LMS (Master Study) and shop (Woocommerce) plugin in our own WordPress installation and created a test page with the blog posts element. Only the selected posts are displayed in the front end.

Screenshot: https://imgur.com/0FWI83o

Best regards,
Ismael