Yesterday most everything was displaying fine in our backend (The exception being that when clicking the arrows to jump from one page of events to the next, the events on page 2, for example, simply disappeared. On the other hand, if we manually entered a page number, the appropriate page plus its events would appear.)<\/p>\n
Today, for an unknown reason, events have completely disappeared. We cannot access “All”, “Published”, “Pending”…nothing. No new plugins have been added to our site. The only change we can think of is that we used the countdown widget for the first time. <\/p>\n
Please treat this as urgent. We cannot publish our client’s events to our site at present and, so, run quite a risk of losing business. <\/p>\n
I’ll include the database error we see in our debug bar:<\/p>\n
Database Errors<\/p>\n
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_atlasmu_4_posts.*, wp_atlasmu_4_postmeta.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(wp_atlasmu_4_postmeta.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_atlasmu_4_posts LEFT JOIN wp_atlasmu_4_postmeta ON wp_atlasmu_4_posts.ID = wp_atlasmu_4_postmeta.post_id AND (wp_atlasmu_4_postmeta.meta_key = ‘_EventStartDate’ or wp_atlasmu_4_postmeta.meta_key is null) LEFT JOIN wp_atlasmu_4_postmeta as eventDuration ON( wp_atlasmu_4_posts.ID = eventDuration.post_id AND eventDuration.meta_key = ‘_EventDuration’) LEFT JOIN wp_atlasmu_4_postmeta as eventEnd ON( wp_atlasmu_4_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’) LEFT JOIN wp_atlasmu_4_postmeta as tribe_event_end_date ON ( wp_atlasmu_4_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) LEFT JOIN wp_atlasmu_4_postmeta as tribe_event_duration ON ( wp_atlasmu_4_posts.ID = tribe_event_duration.post_id AND tribe_event_duration.meta_key = ‘_EventDuration’ ) WHERE 1=1 AND wp_atlasmu_4_posts.post_type = ‘tribe_events’ AND (wp_atlasmu_4_posts.post_status = ‘publish’ OR wp_atlasmu_4_posts.post_status = ‘future’ OR wp_atlasmu_4_posts.post_status = ‘draft’ OR wp_atlasmu_4_posts.post_status = ‘pending’ OR wp_atlasmu_4_posts.post_status = ‘private’) ORDER BY DATE(wp_atlasmu_4_postmeta.meta_value) DESC, TIME(wp_atlasmu_4_postmeta.meta_value) DESC LIMIT 0, 20
\n The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<\/p>\n
——<\/p>\n
And, in the WP Query section of the debug bar we see the following: <\/p>\n
Query Arguments:<\/p>\n
post_type=tribe_events&posts_per_page=20<\/p>\n
Query SQL:<\/p>\n
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_atlasmu_4_posts.*, wp_atlasmu_4_postmeta.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(wp_atlasmu_4_postmeta.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_atlasmu_4_posts LEFT JOIN wp_atlasmu_4_postmeta ON wp_atlasmu_4_posts.ID = wp_atlasmu_4_postmeta.post_id AND (wp_atlasmu_4_postmeta.meta_key = ‘_EventStartDate’ or wp_atlasmu_4_postmeta.meta_key is null) LEFT JOIN wp_atlasmu_4_postmeta as eventDuration ON( wp_atlasmu_4_posts.ID = eventDuration.post_id AND eventDuration.meta_key = ‘_EventDuration’) LEFT JOIN wp_atlasmu_4_postmeta as eventEnd ON( wp_atlasmu_4_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’) LEFT JOIN wp_atlasmu_4_postmeta as tribe_event_end_date ON ( wp_atlasmu_4_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) LEFT JOIN wp_atlasmu_4_postmeta as tribe_event_duration ON ( wp_atlasmu_4_posts.ID = tribe_event_duration.post_id AND tribe_event_duration.meta_key = ‘_EventDuration’ ) WHERE 1=1 AND wp_atlasmu_4_posts.post_type = ‘tribe_events’ AND (wp_atlasmu_4_posts.post_status = ‘publish’ OR wp_atlasmu_4_posts.post_status = ‘future’ OR wp_atlasmu_4_posts.post_status = ‘draft’ OR wp_atlasmu_4_posts.post_status = ‘pending’ OR wp_atlasmu_4_posts.post_status = ‘private’) ORDER BY DATE(wp_atlasmu_4_postmeta.meta_value) DESC, TIME(wp_atlasmu_4_postmeta.meta_value) DESC LIMIT 0, 20<\/p>\n","protected":false},"template":"","class_list":["post-81222","topic","type-topic","status-closed","hentry"],"yoast_head":"\n