Support » Plugin: The Events Calendar » WordPress Database Error

  • Hello, i found the following error in the debug.log of my site:

    WordPress-Datenbank-Fehler Unknown column 'EventStartDate' in 'order clause' für Abfrage SELECT SQL_CALC_FOUND_ROWS DISTINCT dr_posts.ID FROM dr_posts  LEFT JOIN dr_term_relationships ON (dr_posts.ID = dr_term_relationships.object_id) LEFT JOIN
     dr_postmeta as tribe_event_end_date ON ( dr_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' )  WHERE 1=1  AND ( 
      dr_term_relationships.term_taxonomy_id IN (134,135,148)
    
    ) AND dr_posts.post_type = 'tribe_events' AND (dr_posts.post_status = 'publish' OR dr_posts.post_status = 'hidden' OR dr_posts.post_status = 'expired' OR 
    dr_posts.post_status = 'archived' OR dr_posts.post_status = 'tribe-ea-success' OR dr_posts.post_status = 'tribe-ea-failed' OR dr_posts.post_status = 'tribe-ea-schedule'
     OR dr_posts.post_status = 'tribe-ea-pending' OR dr_posts.post_status = 'tribe-ea-draft' 
    OR dr_posts.post_status = 'private') GROUP BY dr_posts.ID ORDER BY EventStartDate DESC, dr_posts.post_modified DESC LIMIT 0, 1 von require('wp-blog-header.php'), wp, WP->main,
     WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, 
    WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Taxonomy_Sitemap_Provider->get_index_links, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    

    I am not sure if your Event Calendar Plugin creates this broken Query or the Yoast Plugin. The Problem ist the “order by EventStartDate”, because it does not exists.

    I would be happy, if you can help me finding the source of this error 🙂

    • This topic was modified 1 year, 2 months ago by DimaW.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘WordPress Database Error’ is closed to new replies.