• Everytime I goto a date with for the events calendar such as http://www.domain.com/calendar-of-events/category/family/2010-07/ I get a WP database error in my web server error.log:

    [Mon Sep 23 08:16:41 2013] [error] [client 173.238.123.32] WordPress database error Unknown column ‘ids’ in ‘field list’ for query SELECT DISTINCT ids FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) AND wp_postmeta.meta_key = ‘_EventStartDate’ 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 (7) AND tt1.term_taxonomy_id IN (7) ) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’) AND (wp_postmeta.meta_key = ‘_EventStartDate’ ) AND ((wp_postmeta.meta_value >= ‘2010-07-01’ AND wp_postmeta.meta_value <= ‘2010-07-31’) OR (tribe_event_end_date.meta_value >= ‘2010-07-01’ AND wp_postmeta.meta_value <= ‘2010-07-31’ ) OR (wp_postmeta.meta_value < ‘2010-07-01’ AND tribe_event_end_date.meta_value >= ‘2010-07-31’ )) ORDER BY DATE(wp_postmeta.meta_value) ASC, TIME(wp_postmeta.meta_value) ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/alterna1/page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, TribeEventsTemplates::load_ecp_into_page_template, tribe_get_view, do_action(‘tribe_events_before_view’), call_user_func_array, Tribe_Events_Month_Template->setup_view, Tribe_Events_Month_Template::get_daily_counts, TribeEventsQuery::getEventCounts, WP_Query->query, WP_Query->get_posts

    How do I fix this? I think its slowing down the site.

    http://wordpress.org/plugins/the-events-calendar/

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error Unknown column 'ids'’ is closed to new replies.