• Resolved bgajus

    (@bgajus)


    We are running the latest version of The Events Calendar and TEC Pro. Since upgrading, we have been getting the following error:

    Aug 30 15:11:27 servername.com httpd[8105]: [error] [client IP]
    WordPress database error Unknown column ‘ids’ in ‘field list’ for query SELECT
    SQL_CALC_FOUND_ROWS DISTINCT ids FROM wp_posts LEFT JOIN wp_postmeta ON
    (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key =
    ‘_VenueGeoAddress’)\nINNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID =
    mt1.post_id) WHERE 1=1 AND wp_posts.post_type = ‘tribe_venue’ AND
    (wp_posts.post_status = ‘publish’) AND ( wp_postmeta.post_id IS NULL\nAND
    (mt1.meta_key = ‘_VenueAddress’ AND CAST(mt1.meta_value AS CHAR) != ”) ) GROUP
    BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 made by
    do_action(‘admin_init’), call_user_func_array,
    TribeEventsGeoLoc->maybe_offer_generate_geopoints,
    TribeEventsGeoLoc->get_venues_without_geoloc_info, WP_Query->__construct,
    WP_Query->query, WP_Query->get_posts, referer:
    https://www.url.com/wp-admin/post.php?post=2353&action=edit&message=1

    Wondering if anyone has seen this before or knows of a solution?

    Thanks!!

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

Viewing 1 replies (of 1 total)
  • Hi!

    If you visit Events > Settings do you see an option to merge duplicate venues/organizers and if you use this is the problem resolved?

    (If not, please don’t hesitate to let us know.)

    Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘Database Error’ is closed to new replies.