[Zachary]

Hi Barry,
Thanks for responding. Here is one of the long query errors:

[Tue Nov 11 09:59:42 2014] [error] [client 85.113.166.57] LONG QUERY (1152 characters long generated in /nas/wp/www/cluster-2802/dharmaocean/wp-content/plugins/the-events-calendar/lib/tribe-event-query.class.php:786): \n\t\t\t\t\t\t\tSELECT \ttribe_event_start.post_id as ID, \n\t\t\t\t\t\t\t\t\ttribe_event_start.meta_value as EventStartDate, \n\t\t\t\t\t\t\t\t\tDATE_FORMAT( tribe_event_end_date.meta_value, ‘%Y-%m-%d %H:%i:%s’) as EventEndDate,\n\t\t\t\t\t\t\t\t\twp_2_posts.menu_order as menu_order\n\t\t\t\t\t\t\tFROM wp_2_postmeta AS tribe_event_start\n\t\t\t\t\t\t\t\t\tLEFT JOIN wp_2_posts ON (tribe_event_start.post_id = wp_2_posts.ID)\n\t\t\t\t\t\t\tLEFT JOIN wp_2_postmeta as tribe_event_end_date ON ( tribe_event_start.post_id = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ )\n\t\t\t\t\t\t\tWHERE tribe_event_start.meta_key = ‘_EventStartDate’\n\t\t\t\t\t\t\tAND tribe_event_start.post_id IN ( 231 )\n\t\t\t\t\t\t\tAND ( (tribe_event_start.meta_value >= ‘2014-11-01 00:00:00’ AND tribe_event_start.meta_value <= ‘2014-11-30 23:59:59’)\n\t\t\t\t\t\t\t\tOR (tribe_event_start.meta_value <= ‘2014-11-01 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2014-11-01 00:00:00’)\n\t\t\t\t\t\t\t\tOR ( tribe_event_start.meta_value >= ‘2014-11-01 00:00:00’ AND tribe_event_start.meta_value <= ‘2014-11-30 23:59:59’)\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tORDER BY menu_order ASC, DATE(tribe_event_start.meta_value) ASC, TIME(tribe_event_start.meta_value) ASC;, referer: http://www.blazingmountain.org/location/about-the-environment/

You can see that the “referer” is the site blazingmountain.org. This is a sub-site on our multi-site network. As mentioned in my first post I removed the calendar from this site, but I’m still seeing the errors. Here’s another, which was logged after removing the celendar from the sub-site:

[Tue Nov 11 19:44:59 2014] [error] [client 71.196.153.209] LONG QUERY (1043 characters long generated in /nas/wp/www/cluster-2802/dharmaocean/wp-content/plugins/the-events-calendar/lib/tribe-event-query.class.php:887): 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_postmeta ON (wp_2_posts.ID = wp_2_postmeta.post_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 = ‘_EventEndDate’ ) WHERE 1=1 AND wp_2_posts.ID IN (231) AND wp_2_posts.post_type = ‘tribe_events’ AND (wp_2_posts.post_status = ‘publish’ OR wp_2_posts.post_status = ‘private’) AND (wp_2_postmeta.meta_key = ‘_EventStartDate’ ) AND ((wp_2_postmeta.meta_value >= ‘2014-11-13 00:00:00’ AND wp_2_postmeta.meta_value <= ‘2014-11-13 23:59:59’) OR (tribe_event_end_date.meta_value >= ‘2014-11-13 00:00:00’ AND wp_2_postmeta.meta_value <= ‘2014-11-13 23:59:59’ ) OR (wp_2_postmeta.meta_value < ‘2014-11-13 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2014-11-13 23:59:59’ )) GROUP BY wp_2_posts.ID ORDER BY DATE(MIN(wp_2_postmeta.meta_value)) ASC, TIME(wp_2_postmeta.meta_value) ASC LIMIT 0, 3

This is all more or less gobbledegook to me, so perhaps you can help me make sense of it. Is there any way to tell from these errors where to look for the issue?

Thank you for your suggestion to test on the staging site with the basic twenty-something theme. The thing is we don’t really see the errors on the staging site even with the same configuration as the live site. The staging site doesn’t get much traffic, of course, and so I don’t know how to reproduce an issue on staging that only seems to rear its head under real world use. Any advice here?

[Zachary]

It turns out that Firefox was caching the previous configuration, which is why it only showed up there. (Feeling kinda dumb…) So, yes, issue resolved. Thank you!

[Zachary]

Hi Barry,

I see what you mean. That is very weird! The issue shows up on Firefox (v. 28), but it looks fine on Safari.

Thank you for your help,
Zac

[Zachary]

This reply is private.

[Author]

Posts