Order of Event Listings is Varying

This topic contains 26 replies, has 4 voices, and was last updated by  Greg Barr 5 years, 4 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • #460379

    Greg Barr
    Full Member
    Post count: 182

    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:

    #460383

    Guust
    Moderator
    Post count: 29970

    Sorting 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

    #460387

    Greg Barr
    Full Member
    Post count: 182

    Oh 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?

    #460388

    Greg Barr
    Full Member
    Post count: 182

    Sorry, 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.

    #460391

    Greg Barr
    Full Member
    Post count: 182

    Fun 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. : )

    #460392

    Greg Barr
    Full Member
    Post count: 182

    Here’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
    #460394

    Guust
    Moderator
    Post count: 29970

    Please post WP admin details in a private reply.
    Thanks

    #460396

    Greg Barr
    Full Member
    Post count: 182
    This reply has been marked as private.
    #460450

    Greg Barr
    Full Member
    Post count: 182
    This reply has been marked as private.
    #460453

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    #460454

    Greg Barr
    Full Member
    Post count: 182
    This reply has been marked as private.
    #460455

    Greg Barr
    Full Member
    Post count: 182
    This reply has been marked as private.
    #460463

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    #460514

    Greg Barr
    Full Member
    Post count: 182
    This reply has been marked as private.
    #460571

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
Viewing 15 posts - 1 through 15 (of 27 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket