Conflict with Easy content types

[Keith O Reilly]

Am using Easy Content Types, to create custom post types. But there seems to be a conflict with this plugin and the events cal pro.
The following error :
[01-Jul-2017 08:55:51 UTC] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_posts AS p2 ON (wp_posts.post_parent = p2.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 = ‘_EventEndDate’ ) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (624,625,628)
) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) AND (((wp_posts.post_status = ‘publish’) OR (wp_posts.post_status = ‘inherit’ AND (p2.post_status = ‘publish’)))) ORDER BY wp_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 7
made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, call_user_func, Tribe__Events__REST__V1__Endpoints__Archive_Event->get, Tribe__Events__REST__V1__Endpoints__Archive_Event->has_previous, tribe_get_events, Tribe__Events__Query::getEvents, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

[Keith O Reilly]

I spoke with the plugin developer of the Easy Content Type – and they have told me that the error has nothing to do with their plugin so I am not sure what the issue is now?

[Patricia]

Hey Keith,

Thanks for contacting us! I’m very sorry about this issue you are experiencing. To help us understand better your problem, can you please let us know when you get this specific error (what action triggers it) and if the error occurs only with Easy Content Types plugin enabled? Please make sure to follow our Testing for Conflicts KB and let us know your test results!

Regards,

Patricia

[Keith O Reilly]

The error appears on the log on occasions when the people visit an individual event.

The 500 error appears when I try to enter the “Metaboxes” section of the the back end of the custom post types plugin.

[Patricia]

Hi Keith,

Can you please access your Dashboard, go to Events -> Settings -> General Settings, disable the “Recurring event instances” option, save the changes and let us know if the issue persists after that?

This query you sent us has some of the properties of our Tribe__Events__Pro__Recurrence__Queries::collapse_sql() method and it might be part of the issue you are experiencing.

Regards,

Patricia

[Keith O Reilly]

Hi Patricia,

Thank you for your response. I tried what you suggested, but unfortunately, it made no difference.
Any other suggestion?

Keith

[Patricia]

Hi Keith,

I’m sorry to know that the issue persists. Can you please confirm how did you discover that the source of the conflict was the Easy Content Types plugin? This information might be helpful in our debugging process. Also, can you please send us a copy of Easy Content Types so we can try to replicate the issue from our end?

Regards,

Patricia

[Keith O Reilly]

When I click on “metaboxes” on the back end of Easy Content Types, the error occurs.
Other options however remain unaffected.

Here is a link to the plugin file
https://www.dropbox.com/sh/b6zp46lam4kdj3x/AAAZrChBwGldp_bgXMlC960ba?dl=0

[Patricia]

Hi Keith!

Thanks for sharing with us your plugin file! I’ve ran a test and clicked on “Meta Boxes” option while having both Easy Content Types and Events Calendar Pro enabled and I couldn’t replicate the issue you are experiencing from here: the 500 internal server error doesn’t occur.

Can you please check you PHP error log again and share with us the Fatal errors you find? If your site is experiencing 500 internal server errors every time you click on “meta boxes”, there’s certainly a Fatal Error associated with this action.

Let us know if you need anything else in the mean time!

Regards,

Patricia

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts