Database Error

[Sonya Mowery]

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!!

[Barry]

Hi Brian,

Do you see a link anywhere within the admin environment (perhaps if you visit Events → Settings for instance) to update geolocation data … and if you follow this does that resolve the problem?

It’s definitely something a number of people have reported so we’ll ask the team to look into it.

Thanks!

[Barry]

Hi Brian:

Just checking to see if you need further help and also to check if you can provide a note of the theme and active plugins on your site to help us get to the bottom of this one.

If you could additionally try deactivating all other plugins but ours and switching to a default, unmodified theme (to see if the problem is a conflict) that would be doubly great.

Thanks!

[Barry]

I’m going to close this as you haven’t followed up and I’m guessing you’re all sorted here.

Do note however that we have found this / a very similar problem occurs when NextGen Gallery is present and active. If that’s the case for you (or anyone else reading this) please do note that, sadly, we cannot at present assist further due to the nature and structure of NextGen.

Thanks!

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts