start date and end date active filters displaying no results in Events Calendar

[Helen]

Hi–

We are currently running Events Calendar 3.11.2, Events Calendar Pro 3.11.1, and Filter bar 3.11. These all appear to be the current versions of the available software. In the Events module in the dashboard, we are able to filter results by all active filters except start date and end date, which result in no upcoming events (although there are many on the calendar). We believe that this issue began recently with one of the newer updates, but we are not sure which update caused the filters to stop working. The public facing date filters appear to be working properly, but we are unable to sort events by date on the dashboard interface.

Is this an issue with non matching versions to the installed software, or could another issue have caused this function to stop working? Thank you for your help

[Geoff]

Hi Helen and sorry for the trouble here!

That’s definitely a new issue I haven’t come across yet and am having trouble trying to reproduce it on my test site. By chance, have there been any updates to other plugins or your theme?

It sounds like you’re all synced up as far as version numbers go, so that shouldn’t be a concern.

I’d also like to have you try running through these troubleshooting steps just to make sure there isn’t some other conflict going on.

Let’s start there and see what we find.

Thanks!
Geoff

[Helen]

Seems like this issue may be related to the issue we are experiencing:

Date filters not working in backend

Here is a DB error that debug bar has caught ->

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, tribe_event_start_date.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) LEFT JOIN wp_postmeta AS tribe_event_start_date ON wp_posts.ID = tribe_event_start_date.post_id AND tribe_event_start_date.meta_key = ‘_EventStartDate’ WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) AND eventStart.meta_value >= ‘2015-08-10 00:00:00’ ORDER BY tribe_event_start_date.meta_value DESC, tribe_event_end_date.meta_value DESC LIMIT 0, 20
Unknown column ‘eventStart.meta_value’ in ‘where clause’

[George]

Hey Helen,

If you do mean that these errors arise for you in your dashboard by way of the “Advanced Post Manager” filets, then yes, unfortunately this a known bug 🙁

As you can imagine, as a set of “calendar” and “events”-related plugins the ability to sort things by start and end date is pretty important! We’re working really hard to figure out this problem, because it did originally work in our first QA passes for the most recent Advanced Post Manager release, but then other bug behavior rose.

I do not have a specific date in mind for when we will release the fix, as we are still working on the fix, but I assure we will release it as soon as possible.

I’m really sorry about the frustration that this leaves us with 🙁 Please let me know if there’s anything I can help with in the meantime or if you have any other questions at all.

Thank you!
George

[Helen]

No problem, I will install whichever updates come out in the plugin suite, when they come out, and report back here if it fixes the issue.

Thanks

[George]

Thank you so much Helen – I’m really sorry for the inconvenience here, but we hopefully we will have a fix for this published within the next month so (hopefully sooner!)

[Brad]

Any further updates?

[George]

Hey Brad,

There are not at this time, unfortunately 🙁

Stay tuned to updates within your WordPress dashboard, the changelog there will list fixes for the release and we’ll also publish about it here on http://theeventscalendar.com/blog

Thank you all for your patience on this!

[Nico]

Hi everyone,

Just quick heads up, while you wait for the fix to be included in upcoming releases you can try the solution provided by Jared in this post: https://theeventscalendar.com/support/forums/topic/date-filters-no-longer-working-with-latest-version-of-ecp-solution/.

Hope that helps for now,
Best,
Nico

[George]

Thanks for posting this Nico – definitely try out that solution, folks, it might work well for you!

Cheers,
George

[Leah]

Hello,

Thank you so much for reporting this. We are happy to tell you that a solution to this issue is part of our upcoming 3.12 release! We are doing the final testing and then the new version will be released. Keep an eye on your dashboard Updates page!

If you experience any difficulty with the update or find that the issue you reported in this thread is not resolved in 3.12, please open a new thread and we can help you. Thank you for your patience and support as we work to improve our plugins!

Best,
Leah
and The Events Calendar team

[George]

🙂

[Author]

Posts