Returning issues with Posts 2 Posts and Events Calendar compatability

[Connor]

Hi there,

I’m running into compatibility issues with Events Calendar and Scribu’s Posts 2 Posts plugin. The issue appears to be the same or similar to this issue from several years ago: https://theeventscalendar.com/support/forums/topic%2Fposts-2-posts-connections/?source=tri.be

I have followed the steps outlined by another blogger, who seems to be experiencing the same issue after upgrading their WP and Events Calendar installs to the most recent versions: http://4hoursoftware.com/test/2015/01/14/the-event-calendar-and-posts-2-posts-plugin-compatibility-issue-query/

Is this a known issue and, if so, are there any workarounds? I’m not even especially wedded to the Posts 2 Posts plugin – I simply need a way to assign speakers to events in a reciprocal way.

For reference, here’s the debug error I’m receiving (modified to removed identifying info):

WordPress database error: [Incorrect usage/placement of ‘SQL_CALC_FOUND_ROWS’]
SELECT DISTINCT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_p2p WHERE 1=1 AND wp_posts.post_type = ‘artists’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) AND (wp_p2p.p2p_type = ‘events_to_artists2’ AND wp_posts.ID = wp_p2p.p2p_to AND wp_p2p.p2p_from IN ( SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDateUTC’ ) WHERE 1=1 AND wp_posts.ID IN (13) AND ( wp_postmeta.meta_key = ‘_EventStartDateUTC’ ) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) ORDER BY wp_posts.post_date DESC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) ORDER BY EventStartDate ASC )) ORDER BY wp_posts.post_date DESC /* From [sitename.com/event/eventname/] in [/nas/content/live/sitename/wp-content/themes/twentyfifteen/tribe-events/single-event.php:65] */

Best,
Connor

• This topic was modified 10 years, 4 months ago by Connor.

[Brian]

Hi,

Thanks for using our plugin. I can try to help out here, but we are limited in supporting plugin compatibility issues.

I looked and we released a fix for Posts 2 Posts in 3.11 6 months ago.

I tested out it on my test site and it worked for me to connect posts to events.

What is the connection coding you are working with? I can try it out and see if I get a different result.

Thanks

[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