Post slider conflict with Event Calendar Pro

I tried just using the blog posts widget instead of the posts slider and that won’t work either. Clearly there is a conflict with the Event Calendar Plug-in.

If you actually log-in and view the home page with the visual editor, which I gave you creds for, you will see a post-slider that is supposed to appear under NEWS. Not the layer slider at the top of the page, the post-slider that comes with your theme. I cannot get blog posts to show up using any of the posts widgets unless I deactivate the ECP plug-in. I’m not sure how else I can explain it.
It is not working unless the ECP is de-activated. This is a conflict with that plug-in that the dev’s of the ECP they tell me is theme related. I have included another page called test that if you would please log-in and see that the only thing on the page is the post slider and the blog widget and they will not display. We have hundreds of events in the ECP, switching that out is not an option. It was working fine until the last update as I have stated already.

This is a staging site.

You sent an e-mail to me that is not showing here but the code you said you added in the functions.php was not there? Was that in the child functions? I did a search for that code on the whole site and didn’t find anything. I added it in the child functions and it didn’t do anything but create a bunch of code at the top of the home page when I previewed it. This is what the last e-mail said:

The plugin overrides the post slider query as you can see in this page: ~/test/

We added this in the functions.php file:

add_filter('avia_post_slide_query', function($query, $params) {
var_dump($query);
return $query;
}, 10, 2);

I fixed the quotes/apostrophes btw so that the code was correct and it still did nothing. Please advise. ECP is also looking at this again.

They are now looking into it so if they cannot come up with a solution, I will give you the ftp login. I just don’t want both of you in there at the same time over writing each other. Thanks,

Here is the reply from ECP. Please let me know if I can send you credentials for FTP and admin and please help resolve this issue. They are unable to do anything further. We added a debug.

From:ECP:
I am sorry, I forgot to get back to you about this. Please feel free to set WP_DEBUG to false, which will hide those errors. You might not remove the debug bar or revert SAVEQUERIES just yet, as Kriesi themes might find those interesting.

The query on your site which is generating an error (I quoted it in my last response) is strangely quite different from the query that is running on my site when I have Enfold and Pro running side-by-side with a post slider. Here is my query:
SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.*,
IF (wp_posts.post_type = ‘tribe_events’, wp_postmeta.meta_value, wp_posts.post_date) AS post_date
FROM wp_posts
INNER JOIN wp_term_relationships
ON (
wp_posts.id = wp_term_relationships.object_id) LEFT JOIN wp_postmeta AS wp_postmeta
ON wp_posts.id = wp_postmeta.post_id
AND wp_postmeta.meta_key = ‘_EventStartDate’
WHERE 1=1
AND (
wp_term_relationships.term_taxonomy_id IN (1) )
AND wp_posts.post_type IN (‘post’,
‘page’,
‘attachment’,
‘revision’,
‘nav_menu_item’,
‘wp_router_page’,
‘tribe_events’,
‘tribe_venue’,
‘tribe_organizer’,
‘portfolio’,
‘avia_framework_post’)
AND (
wp_posts.post_status = ‘publish’
OR wp_posts.post_author = 1
AND wp_posts.post_status = ‘private’)
GROUP BY wp_posts.id
ORDER BY post_date DESC
LIMIT 0, 9
Due to how your query is structured it is getting a duplicate column for post_date. Where as the properly structured one running on my system does not.

The reason why I am giving you all of this technical information is because this falls well outside our scope of support. Technically we do not support third party themes here at all, especially when the issue is one of their widgets. But, I did not want to send you back/forth between support teams if I could at all avoid if, plus the Kriesi folks have been awesome. I wanted to help even thought it violated our TOS and probably would have disappointed our support manager here. Unfortunately, I have to send you back to Kriesi at this point. We are simply not qualified to be diagnosing Enfold queries. I don’t know what could be affecting this, why it’s different on your system, etc. We are just not true Enfold experts here. Hopefully though when you go back with the extra information we have collected, they will know what is up. Maybe they will have a good idea of why the query is changing and what could be causing it to vary so drastically from system to system.

Please advise as soon as possible, we have been waiting to take this site live until this is resolved.
thanks!

Can you give me an idea of how long this will take, we need to launch this site asap. Thanks!