Order of Event Listings is Varying
This topic contains 26 replies, has 4 voices, and was last updated by Greg Barr 5 years, 11 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
December 28, 2018 at 10:48 pm #460379
I have a lot of recurring events, so it’s very important that my event pages present events in order of date. I have set sorting to do that, and it works fine…most of the time.
For example, my main events page it lists events, including recurrings, in order of date.
If you search in a state, say “In: Illinois (region)” it works too, looks like this
But if you search by proximity, say just enter “St. Louis” and go, it puts them in order of event name, which means the event with the first name, alpabetically speaking, shows up dozens of times before any other event appears. Unacceptable.
Just noticed a surely-related symptom or indicator of whatever the problem is.
I just added “title” to sort options, figuring that’d at least give option to get it right.Check this out…
On main events page, or by category, or searching “in” a city or region, the results now includes the option to sort by Title or Date.
But if you just pop “St. Louis” into the search field and go, it returns accurate results, but the sorting sucks and the sorting OPTIONS you’ve decided to provide are not presented as a dropdown:
December 28, 2018 at 11:12 pm #460383Sorting by title etc is not available for searches, only for archive pages.
Search results are relevant to the search query.Regarding your other question, if you search near a location, how do you think the results should be shown? Only the first upcoming one of every recurring event?
For the moment they are all shown based on the closest distance to the location, which is what you searched for, there is no date restriction in that search.
If a visitor does not want events closest to the location, but on certain dates, they would use the date search if you make it available.
Or a combination of location and dates.
Search results are relevant to the search query.Thanks
December 28, 2018 at 11:25 pm #460387Oh no way, please say it ain’t so! You just HAVE to be able to present events by date instead of title even within location-specific search results. Presenting events by date is the most/only logical way to present them, at least as a default. I don’t understand why you wouldn’t do that, and why you wouldn’t allow users to pick their sorting option. It’s just as relevant/valuable on search results pages as it is on main/category pages.
Or, sigh, I guess an alternative lies in the answer to your question/suggestion about displaying “Only the first upcoming one of every event?” Because yes, that would work. At least that way the screen wouldn’t be FLOODED with umpteen instances of whatever random event that just happpens to have the first alphabetical name, pushing the rest into offscreen oblivion.
Is it possible to do that now? Or would that be easier to enable than allowing sorting by title?
December 28, 2018 at 11:26 pm #460388Sorry, I had missed that you said they’re actually being presented in order of proximity, vs. date. Personally I think that’s useless, or at least WAY less intuitive and useful than presenting them in date order. Just stack up all the events that hit within the search parameters and present them by date. That’s what people expect for events.
December 28, 2018 at 11:32 pm #460391Fun little followup. I tried to test what you suggested, i.e. searching by proximity then setting date parameters. I set a “To: Search By Date” of Jan 10 2019 and got this beautiful bugginess.
Crap, I guess this post is going in a new direction because I hadn’t tested those fields, but it does the same thing on ALL of my Events page, i.e. main, category or search results. I’m gonna need some expert assistance with this one, eh. : )
December 28, 2018 at 11:33 pm #460392Here’s the text of the error at the top of the page:
WordPress database error: [Unknown column 'wp_hxtk_geodir_gd_event_detail.event' in 'where clause'] SELECT SQL_CALC_FOUND_ROWS wp_hxtk_posts.*, wp_hxtk_geodir_gd_event_detail.* , wp_hxtk_geodir_event_schedule.* FROM wp_hxtk_posts INNER JOIN wp_hxtk_geodir_gd_event_detail ON (wp_hxtk_geodir_gd_event_detail.post_id = wp_hxtk_posts.ID) LEFT JOIN wp_hxtk_geodir_event_schedule ON ( wp_hxtk_geodir_event_schedule.event_id = wp_hxtk_posts.ID ) WHERE 1=1 AND ( ( 1=1 ) ) AND wp_hxtk_posts.post_type in ('gd_event') AND wp_hxtk_posts.post_status = 'publish' AND UNIX_TIMESTAMP( wp_hxtk_geodir_gd_event_detail.event ) <= UNIX_TIMESTAMP( '2019-01-31' ) AND ( wp_hxtk_geodir_event_schedule.start_date >= '2018-12-28' OR ( wp_hxtk_geodir_event_schedule.start_date <= '2018-12-28' AND wp_hxtk_geodir_event_schedule.end_date >= '2018-12-28' ) ) GROUP BY wp_hxtk_posts.ID, wp_hxtk_geodir_event_schedule.start_date ORDER BY wp_hxtk_geodir_event_schedule.start_date ASC, wp_hxtk_geodir_event_schedule.start_time ASC LIMIT 0, 100
And here’s the error message that appears above the search/filtration form.
Notice: Undefined offset: 0 in /nas/content/live/corncendev/wp-includes/class-wp-query.php on line 3149
December 28, 2018 at 11:35 pm #460394Please post WP admin details in a private reply.
ThanksDecember 28, 2018 at 11:38 pm #460396This reply has been marked as private.December 29, 2018 at 8:54 am #460450This reply has been marked as private.December 29, 2018 at 9:27 am #460453This reply has been marked as private.December 29, 2018 at 9:48 am #460454This reply has been marked as private.December 29, 2018 at 9:49 am #460455This reply has been marked as private.December 29, 2018 at 11:12 am #460463This reply has been marked as private.December 29, 2018 at 3:38 pm #460514This reply has been marked as private.December 30, 2018 at 12:31 am #460571This reply has been marked as private. -
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket