eme_events shortcode

[Anonymous]

Hi Franky –

Something changed in your last update and apparently it now matters where you place the order parameter inside the eme_events shortcode.

This call –
[eme_events limit=5, notcategory=3, order=ASC, template_id_header=4, template_id_footer=5, template_id=1]

Ends up giving me this error –
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 'ASC, LIMIT 6' at line 2] SELECT * FROM wp_eme_events LEFT JOIN wp_eme_locations ON wp_eme_events.location_id=wp_eme_locations.location_id WHERE event_status IN (1,2) AND (event_start_date >= '2017-01-24' OR (event_end_date >= '2017-01-24' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL)) AND ( NOT FIND_IN_SET(3,event_category_ids)) ORDER BY ASC, LIMIT 6

Looks like the event_start_date is missing after ORDER BY
Using this call eliminates the error
[eme_events limit=5, notcategory=3, template_id_header=4, template_id_footer=5, template_id=1, order=ASC]

[Franky]

Drop the “,” everywhere in there, that is not as documented. So:
[eme_events limit=5 notcategory=3 order=ASC template_id_header=4 template_id_footer=5 template_id=1]

[Author]

Posts