Database Error Message

[downtownls]

We’re getting a weird error message posted above our event calendar. Below is the text.

WordPress database error: [Unknown column ‘post_parent’ in ‘group statement’]
SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT xvn_posts.ID FROM xvn_posts INNER JOIN xvn_postmeta ON ( xvn_posts.ID = xvn_postmeta.post_id ) LEFT JOIN xvn_postmeta as tribe_event_end_date ON ( xvn_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND xvn_posts.post_parent = 9366 AND ( xvn_postmeta.meta_key = ‘_EventStartDate’ ) AND xvn_posts.post_type = ‘tribe_events’ AND (xvn_posts.post_status = ‘publish’ OR xvn_posts.post_status = ‘tribe-ea-success’ OR xvn_posts.post_status = ‘tribe-ea-failed’ OR xvn_posts.post_status = ‘tribe-ea-schedule’ OR xvn_posts.post_status = ‘tribe-ea-pending’ OR xvn_posts.post_status = ‘tribe-ea-draft’ OR xvn_posts.post_status = ‘private’) AND (xvn_postmeta.meta_value >= ‘2018-05-17 13:17:00’ OR (xvn_postmeta.meta_value <= ‘2018-05-17 13:17:00’ AND tribe_event_end_date.meta_value >= ‘2018-05-17 13:17:00’ )) ORDER BY xvn_posts.post_date ASC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) LIMIT 0, 1

WordPress database error: [Unknown column ‘post_parent’ in ‘group statement’]
SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT xvn_posts.ID FROM xvn_posts INNER JOIN xvn_postmeta ON ( xvn_posts.ID = xvn_postmeta.post_id ) LEFT JOIN xvn_postmeta as tribe_event_end_date ON ( xvn_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND xvn_posts.post_parent = 9324 AND ( xvn_postmeta.meta_key = ‘_EventStartDate’ ) AND xvn_posts.post_type = ‘tribe_events’ AND (xvn_posts.post_status = ‘publish’ OR xvn_posts.post_status = ‘tribe-ea-success’ OR xvn_posts.post_status = ‘tribe-ea-failed’ OR xvn_posts.post_status = ‘tribe-ea-schedule’ OR xvn_posts.post_status = ‘tribe-ea-pending’ OR xvn_posts.post_status = ‘tribe-ea-draft’ OR xvn_posts.post_status = ‘private’) AND (xvn_postmeta.meta_value >= ‘2018-05-17 13:17:00’ OR (xvn_postmeta.meta_value <= ‘2018-05-17 13:17:00’ AND tribe_event_end_date.meta_value >= ‘2018-05-17 13:17:00’ )) ORDER BY xvn_posts.post_date ASC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) LIMIT 0, 1

[Jaime Marchwinski]

Hi Donnie,

Thanks so much for reaching out!

As a first step, let’s try to rule out if there is some type of conflict at play.
This is usually because of:

• A conflict with another plugin
• A conflict with your WordPress theme
• A template customization for the Events Calendar that requires updating

When it comes to that type of issue, it is preferable to troubleshoot in a staging environment if you have one.

A first quick test is to simply temporarily revert back to a default WordPress theme such as twenty-sixteen to see if the issue persists.

The next step would be to go through our testing for conflicts procedure and let us know what you find out.

Basically the goal here is to revert back to a bare WordPress installation to see if the problem persists. It also allows us to pinpoint what the cause of the issue is.

But, before you do that, there are 2 things I would advise:

• Make a backup of your database
• Consider activating a “Maintenance Page” plugin if you are doing this on your live site (to minimize impact on your visitors)

Let me know how that goes!

 

Thanks,

Jaime

[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