We had to roll back the update on all 3 Toolset plugins. When we ran the updates our Spotlight Events went from showing current (this month) to showing January (years out of date). So now we're stuck and can't update without breaking the site.
I am trying to: The home page should be showing most recent Events posts. This works fine with version currently loaded. But when we updated to the most recent version, it started showing January and we were forced to roll back (via Updraft Plus plugin)
Link to a page where the issue can be seen: hidden link (note right now it shows correct since we rolled back to the previous versions of the plugins.
I expected to see: as it is now (October) under Spotlight Events
Instead, I got: Events showed January.
I'd need to know the precise query and view built there to show this, however, it is possible that you have the View querying by posts with a DATE as (...)?
If so, can you try to change that to a query for posts with a NUMBER as (...)?
This, if the date field used to query is a Custom Types Date Field or any field that is a Timestamp
If that does not help, I think we will need the precise steps to rebuild this and debug it.
What can help is:
- a slimmed copy of that site, which shows the issue with just Toolset
https://toolset.com/faq/provide-supporters-copy-site/
- an exported set of Views and other contents needed to rebuild it (Toolset > Export/Import)
https://toolset.com/documentation/user-guides/how-to-importexport-types-structures/
- or a module with all elements we need
https://toolset.com/documentation/user-guides/using-toolset-module-manager/
With such data and steps of how to replicate the issue, we will be able to see what happened and fix it.
I am aware of the already mentioned issue where we require NUMBER instead of DATE, and that was opposite a few months ago, so that could be what you face here.
https://toolset.com/documentation/user-guides/date-filters/
My issue is resolved now. Thank you!
The solution to Tribe Events' TheEventCalendar date filtering not working since the Toolset Views update was two part for me:
1) I changed the last option in the ordering rule to "As a number" instead of "As a native custom field" as you suggested. That did not work by itself.
2) I also found my exact problem here after more searching: https://toolset.com/forums/topic/date-comparison-error-with-tribe-events-calendar-after-update/
I followed those instructions and finally got it working by adding the custom PHP code to Toolset > Settings > Custom Code. The only trick to that was finding the views ID# so I could replace it in the sample code.
Hope this helps someone else.