PHP Error for Coords Since new Update

[mrjarbenne]

Since updating to 4.4.19 of TEC Pro and 4.6.4 of TEC, I’m seeing this error in my PHP logs. Thoughts?

[14-Nov-2017 04:28:56 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				)
			) AS <code>coords</code>' at line 27 for query 
			SELECT
				MAX( <code>coords</code>.<code>lat</code> ) AS <code>max_lat</code>,
				MAX( <code>coords</code>.<code>lng</code> ) AS <code>max_lng</code>,
				MIN( <code>coords</code>.<code>lat</code> ) AS <code>min_lat</code>,
				MIN( <code>coords</code>.<code>lng</code> ) AS <code>min_lng</code>
			FROM (
				SELECT <code>post_id</code> AS <code>venue_id</code>,
				CASE
					WHEN <code>meta_key</code> = '_VenueLat'
					THEN CAST( <code>meta_value</code> AS DECIMAL( 10, 6 ) )
				END AS <code>lat</code>,
				CASE
					WHEN <code>meta_key</code> = '_VenueLng'
					THEN CAST( <code>meta_value</code> AS DECIMAL( 10, 6 ) )
				END AS <code>lng</code>
			FROM <code>wp_4533_postmeta</code>
			WHERE
				(
					<code>meta_key</code> = '_VenueLat'
					OR <code>meta_key</code> = '_VenueLng'
				)
				AND <code>post_id</code> IN (
					SELECT <code>meta_value</code>
					FROM <code>wp_4533_postmeta</code>
					WHERE
						<code>meta_key</code> = '_EventVenueID'
						AND <code>post_id</code> IN (  )
				)
			) AS <code>coords</code>
		 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/the-events-calendar/src/views/default-template.php'), get_header, locate_template, load_template, require_once('/themes/hemingway-rewritten-wpcom/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wp_enqueue_scripts, do_action('wp_enqueue_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__Pro__Main->enqueue_pro_scripts, Tribe__Events__Pro__Geo_Loc->get_min_max_coords

[mrjarbenne]

Related: https://theeventscalendar.com/support/forums/topic/apparent-database-problem-in-4-4-19/

[Cliff]

Hi. Thanks for this detailed information. This is a confirmed bug in Events Calendar PRO 4.4.19

I marked this thread as Pending Fix, which means it should receive a reply once the applicable fix has been released. I cannot guarantee when it will be fixed as it’s in the development team’s hands now. They need to assign it, code it, test it, and schedule it for release.

I apologize for this issue and appreciate your understanding and patience.

[Nico]

Hi there,

Just wanted to share with you that a new maintenance release (for the Week of 7th January 2018) is out, including a fix for this issue :slightly_smiling_face:

Find out more about this release → https://theeventscalendar.com/maintenance-release-week-7-january-2018/

Please update the plugins and let us know if the fix works for your site,
Best,
Nico

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts