Time of Day filter showing no events

[Stephan]

I have ~350 events with beginning and ending dates and times. All events show properly when unfiltered, and the category and day of week filters also work properly. When I select a time of day filter, though, no events show. Any ideas?

[Nico]

Hi Stephan,

Thanks for reaching out to us! I’ll help you out on this one 🙂

I’m checking this locally and it seems to be working fine on my end. Can you please follow the steps described in our Testing for conflicts guide? This way we can see if this is a problem in our plugin or a conflict with the theme or other installed plugins. Is the site online? Do you mind sharing the URL with me?

Also it would be great if you could share your system information with me so I can check if everything looks right on that end.

Thanks,
Have a great weekend,
Nico

[Stephan]

This reply is private.

[Stephan]

Just found something that should help diagnose the problem and determine a fix. All of my events were imported using the CSV import tool. I’ve since had to edit a couple of the events by hand and those events now show up when I use the time of day filter.

[Nico]

Hey Stephan,

That’s a good catch!

Can you check if the event date in the CSV file is correct and includes time? I’ve heard of different troubles while importing events with incomplete dates (for example lacking the year or so). If the events are well formatted and they get imported correctly there should not be any troubles while filtering.

Please check on that and let me know,
Best,
Nico

[Stephan]

All dates and times are formatted according to ISO 8601. Dates are YYYY-MM-DD and times are HH:MM:SS as per the guidelines in your documentation. Looks like something else is afoul.

[Nico]

Thanks for confirming Stephan,

Can you send me a link to download the file? I’ll try to reproduce this locally. We might be facing a bug here and I would like to confirm that 🙁

Thanks,
Nico

[Stephan]

This reply is private.

[Nico]

Hi Stephan,

Thanks for sending the file over! I was able to reproduce the issue you describe locally, so most probably we are facing a bug here 🙁

Before I log this in our product backlog I would like to make some additional tests to narrow this down and see if why this is happening.

Please hold on a bit, I’ll get back to you with further details tomorrow,
Thanks,
Nico

[Stephan]

Thanks, Nico!

We are in a bit of a time crunch to get the issue resolved, but I understand that a fix (if it is a bug) will take some time. Do you have any recommendations on how to update the data tables to resolve the issue? We have an experienced database programmer who can make the changes on our side and it would help to know where to start looking.

Best,
Stephan

[Nico]

Hey Stephan,

Just finished doing some more tests on this, but couldn’t find what causing this unexpected behavior. I’ve logged it as a Bug in our product backlog, and yes a fix for this won’t be available very soon.

I’ve pinged the dev on this, but not sure if a temporary fix will be possible. Looking at the generated post_meta entries everything looks solid, so not clue on my end.

If we are not talking about lot’s of events maybe you can manage to update them manually after import?

Please let me know if manual update is a valid option or not at all,
Best,
Nico

[Stephan]

Thanks, Nico. I have ~350 events that would need to be updated. Not an impossible task to be done manually, but one I’d prefer to avoid. I’ll ask our db guy if he can find a solution.

[Nico]

Hi Stephan,

Thanks for following! I’ve tried a couple of things one of the dev suggested but could make it work without updating. I think 350 events is surely a big amount, I’ll take a second look at this tomorrow and see if I’m able to find a workaround although I cannot promise I will.

Thanks for your patience on this,
Best,
Nico

[Nico]

Hey Stephan,

Good news before the weekend 🙂

Taking a second look into what happens to the database after updating the event, I noticed that if you delete the row ‘_EventAllDay’ from the post meta table for the event this issue gets fixed. You can run a SQL query like this one to fix this for all imported events:


DELETE FROM wp_postmeta WHERE meta_key = '_EventAllDay' AND meta_value = 'no'


IMPORTANT: make a back-up of the wp_postmeta table before doing this! Also note that ‘wp_’ is the default table prefix in WordPress, but it might be different in your site.

Please let me know if the issue gets fixed after running the query,
Have a great weekend,
Nico

[Stephan]

Great, thank you! Before reading your reply, I found a way to automate the process by using iMacros in Firefox. I appreciate all your help with this!

-Stephan

[Author]

Posts