Enfold Post slider conflict with Event Calendar Pro

[Brook]

Howdy Allison,

Thanks for getting back to us. Geoff was having me take a looksie now that you have approved access, since I had a good idea of what to be looking for. When I opened up the debug bar I noticed it was not quite finished being setup. Unfortunately I can not finish the setup from my end, we will have to rely on you to do that likely via FTP. The debug bar, and most any diagnostic tool, is going to require you to enable WP_DEBUG and SAVEQUERIES. The WordPress Codex has a great guide on how to enable settings like these by editting wp-config.php. Once you have read the intro there are two sections in that guide worth reading as well, one for WP_DEBUG and the other for SAVEQUERIES. You will want to set both of these to true as outlined:

https://codex.wordpress.org/Editing_wp-config.php#Debug
https://codex.wordpress.org/Editing_wp-config.php#Save_queries_for_analysis

Once you have done that we will have some nice diagnostic information that will likely prove helpful. Please let us know if you have any questions along the way. Thanks for working with us Allison, I hope we an find you a resolution shortly.

Cheers!

– Brook

[andersonparks]

define(‘WP_DEBUG’, true);
define( ‘SAVEQUERIES’, true );

is set in wp-config.php

please let me know what you find

[Brook]

Thanks you Allison. It would seem the error is related to the following SQL query:

SELECT SQL_CALC_FOUND_ROWS * 
FROM   (SELECT 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 ( 55 ) ) 
               AND wp_posts.post_type IN ( 'post', 'page', 'attachment', 
                                           'revision', 
                                           'nav_menu_item', 'tribe_events', 
                                           'tribe_venue', 
                                               'tribe_organizer', 
                                           'portfolio', 'avia_framework_post' ) 
               AND ( wp_posts.post_status = 'publish' 
                      OR wp_posts.post_author = 5 
                         AND wp_posts.post_status = 'private' ) 
        ORDER  BY post_date DESC) a 
GROUP  BY IF(post_parent = 0, id, post_parent) 
ORDER  BY eventstartdate ASC 
LIMIT  0, 10

This generates duplicate post_date column error. This looks like a query likely generated by our plugin, but its getting mangled. I am going to discuss this with the team and see if they have any ideas on what is mangling it, and how we could reproduce it. It is strange that I am not experiencing a similar error/problem on my end thus far. But perhaps between all of us someone will find something I’ve missed. I will get back to you shortly.

Thanks for all the details and debugging.

– Brook

[andersonparks]

Are you working on this still? I have a screen full of php errors for the last 2 days. Please let me know. We are trying to work on this site while in development and are unable to do anything. If you need a few days, please let me know so we know what to expect. Screen shot: http://imgur.com/Vg6FYAj

thank you!

[andersonparks]

Please let me know what is going on. We need to take this site live very soon and this is holding us up. I appreciate you trying to solve this issue but please understand we have hundreds of Events in this plug-in and need to get this resolved. Starting over is not an option. It was working fine before the update. This has been going on for a long time and neither Enfold or you have been able to provide a solution. Could you please give me an estimate of time or at least an update as to what you are doing? It would be appreciated! thanks,

[Brook]

Howdy Allison,

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.

There is a possible hacky workaround. If disabling Events Calendar Pro is temporarily fixing the issue on your website, and you are not running any The Events Calendar widgets on your home page, you might be able to disable Events Calendar Pro from loading only on the home page. I have never tried this before, not even sure if it works. but the WP Plugin Plugin Organizer allows you to disable plugin for “any post type or wordpress managed URL”. It’s possible disabling Events Calendar Pro on your home page will work.

I really really wish I had better news.

• Brook

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts