WordPress database error

[Tammy]

HI, I have been receiving several of these for several days now. I noticed my website was running really slow and I was hoping you could help me with this? The ones I have posted below are from today. Thanks

[Sat May 07 15:58:34.483118 2016] [:error] [pid 25659] [client 71.0.145.124:36055] WordPress database error Unknown column ‘wp_2_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wp_2_posts.*, MIN(wp_2_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_2_posts LEFT JOIN wp_2_postmeta as tribe_event_end_date ON ( wp_2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDateUTC’ ) WHERE 1=1 AND wp_2_posts.post_type = ‘tribe_events’ AND (wp_2_posts.post_status = ‘publish’ OR wp_2_posts.post_status = ‘private’) ORDER BY EventStartDate DESC, wp_2_posts.post_date DESC LIMIT 0, 1 /* From [residents.scgccmulti.wpengine.com/events/] in [/nas/content/live/scgccmulti/index.php:17] */ made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: http://residents.scgccmulti.wpengine.com/event/water-volleyball-2-4pm/2016-05-08/

[Sat May 07 16:44:48.368305 2016] [:error] [pid 12995] [client 71.0.145.124:11268] WordPress database error Unknown column ‘wp_2_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wp_2_posts.*, MIN(wp_2_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_2_posts LEFT JOIN wp_2_postmeta as tribe_event_end_date ON ( wp_2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDateUTC’ ) WHERE 1=1 AND wp_2_posts.post_type = ‘tribe_events’ AND (wp_2_posts.post_status = ‘publish’ OR wp_2_posts.post_status = ‘private’) ORDER BY EventStartDate DESC, wp_2_posts.post_date DESC LIMIT 0, 1 /* From [residents.scgccmulti.wpengine.com/events/] in [/nas/content/live/scgccmulti/index.php:17] */ made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: http://residents.scgccmulti.wpengine.com/lake-vista-fitness-center/exercise-studio/

[Sat May 07 16:51:47.187230 2016] [:error] [pid 22949] [client 71.0.145.124:16709] WordPress database error Unknown column ‘wp_2_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wp_2_posts.*, MIN(wp_2_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_2_posts INNER JOIN wp_2_term_relationships ON (wp_2_posts.ID = wp_2_term_relationships.object_id) LEFT JOIN wp_2_postmeta as tribe_event_end_date ON ( wp_2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDateUTC’ ) WHERE 1=1 AND ( \n wp_2_term_relationships.term_taxonomy_id IN (74)\n) AND wp_2_posts.post_type = ‘tribe_events’ AND (wp_2_posts.post_status = ‘publish’ OR wp_2_posts.post_status = ‘private’) GROUP BY wp_2_posts.ID ORDER BY EventStartDate DESC, wp_2_posts.post_date DESC LIMIT 0, 1 /* From [residents.scgccmulti.wpengine.com/events/category/exercise-studio/] in [/nas/content/live/scgccmulti/index.php:17] */ made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: http://residents.scgccmulti.wpengine.com/lake-vista-fitness-center/exercise-studio/

[Sun May 08 00:57:46.347327 2016] [:error] [pid 5535] [client 71.0.145.124:49180] WordPress database error Unknown column ‘wp_2_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wp_2_posts.*, MIN(wp_2_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_2_posts LEFT JOIN wp_2_postmeta as tribe_event_end_date ON ( wp_2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDateUTC’ ) WHERE 1=1 AND wp_2_posts.post_type = ‘tribe_events’ AND (wp_2_posts.post_status = ‘publish’ OR wp_2_posts.post_status = ‘private’) ORDER BY EventStartDate DESC, wp_2_posts.post_date DESC LIMIT 0, 1 /* From [residents.scgccmulti.wpengine.com/events/] in [/nas/content/live/scgccmulti/index.php:17] */ made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: http://residents.scgccmulti.wpengine.com/event/water-bugs/2016-05-11/

[Tammy]

I was checking out plugins to see why I wasn’t able to login from the main site to the subsite and it seems that the Events PRO is causing a 502 error and the login times out. When its turned off, I can login.

[Tammy]

Sorry for having the different posts but I went in to add some new events and the date calendar isn’t popping up and I can’t add to recurring event. I included a screen shot.

[Geoff B.]

Good morning Patrick and welcome back!

Thank you for reaching out to us.

We are sorry to hear about the error messages and loss of performance that seem to be caused by the Events Calendar Pro.
I would love to help you with this topic.

As a first troubleshooting step, could you please provide us with your complete system information in a private reply using the instructions found in the following link?

https://theeventscalendar.com/knowledgebase/sharing-sys-info/

Secondly, could you also please go through our testing for conflicts procedure (preferably in a staging/dev environment or local install of your WordPress website) 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.

Based on what you are describing, there is a fair chance the issue can be caused by a template customization (some custom piece of code found in the functions.php of your WordPress theme) or by a conflict.

Let me know how that goes.

Best regards,
Geoff B.

[Tammy]

This reply is private.

[Geoff B.]

Good afternoon Patrick,

Thank you for sharing your system information.

It’s unfortunate that the glitch seems to be caused by using our Widgets with Visual Composer.

That being said, I am also noticing that you are several versions behind on our the Events Calendar Pro plugin.

Prior to trying anything else, I would recommend upgrading that plugin to the latest version (4.1.2)

Let me know how that goes.

Best regards,
Geoff B.

[Tammy]

Update downloaded. Are you saying now that I shouldn’t have a conflict with using VC and Events Pro?

Also, where do I get notices about updates on your plugins? Thanks

[Tammy]

This reply is private.

[Geoff B.]

Good evening Patrick,

Are you saying now that I shouldn’t have a conflict with using VC and Events Pro?

In my experience the type of issue you were experiencing can be caused by using an older version of a plugin combined with the newer version of another.

This is especially true with major upgrades such as WP 4.5.x where the way to do certain things changed significantly.

I cannot guarantee that this fixes everything, but most of the time it helps.

Also, where do I get notices about updates on your plugins?

In order to get the update notices, I recommend entering your license number in Events -> Settings -> Licenses

Finally, I will run that last error message by our DEV team and see what their advice on it is tomorrow.

Best regards,

Geoff B.

[Geoff B.]

Good afternoon Patrick,

As promised, I ran this by our team members, here are a couple of take away items from that conversation:

1. The event that is causing the remaining message seems to be private (http://residents.scgccmulti.wpengine.com/?post_type=tribe_events&p=4161%2F/). Would you mind sharing screenshots of the Edit Event screen for this one ?
2. It looks like there is an issue between some template customization done with your WordPress theme and that specific event. Could you please send me a link to a zip file containing your theme ?

Best regards,

Geoff B.

[Tammy]

This reply is private.

[Tammy]

This reply is private.

• This reply was modified 9 years, 11 months ago by Tammy.

[Geoff B.]

Hi Patrick,

I ran this by our lead programmer.
Based on the fact that you are using multisite and that the $wpdb variable is the one impacted, he’s 100% positive that there is another one of your plugins that’s impacting the $wpdb variable in an unwanted way, thus creating the error message.

As suggested before, unfortunately, the only way to identify the culprit would be to go through our complete testing for conflicts procedure (preferably in a staging/dev environment or local install of your WordPress website) and let us know what you find out.

I wish I had a better answer for you, but for now it’s the best one I have.

Best regards,

Geoff B.

[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