Bug in Events Calendar PRO 4.4.19

[cfoellmann]

There is a bug in Pro 4.4.19. I havent found a better location to post this.
Following Error is logged:

[05-Dec-2017 08:08:56 UTC] WordPress-Datenbank-Fehler You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
				)
			) AS <code>coords</code>' at line 27 für Abfrage 
			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_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_postmeta</code>
					WHERE
						<code>meta_key</code> = '_EventVenueID'
						AND <code>post_id</code> IN (  )
				)
			) AS <code>coords</code>
		 von require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/twentyseventeen/page.php'), get_header, locate_template, load_template, require_once('/themes/twentyseventeen/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, wp_enqueue_scripts, do_action('wp_enqueue_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, Tribe__Events__Pro__Main->enqueue_pro_scripts, Tribe__Events__Pro__Geo_Loc->get_min_max_coords, QM_DB->query

[Jaime Marchwinski]

Hi Christian,

Thanks so much for reaching out!

We are actually aware of this bug and are actively working on a fix for it.

We apologize for the inconvenience caused by this glitch and we are actively working on a solution for this.  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.  The good news is that you will be contacted as soon as a fix is available.

Thank you for your patience as we see this through.

 

Thanks,

Jaime

[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