Making WordPress.org

#7071 closed defect (bug) (fixed)

Events aren't sorted by its time on the online events list page

Reported by: renyot's profile renyot Owned by: renyot's profile renyot
Milestone: Priority: normal
Component: WordPress.org Site Keywords: has-patch needs-testing
Cc:

Description

We currently have an issue with the way we sort the list of online events. The events are originally sorted by their local times stored in the database, which leads to incorrect order when viewed globally. For instance, an event happening at 4 PM in New York (20:00 UTC) should be listed after an event at 5 PM in London (17:00 UTC), but the current sorting places the London event after the New York one due to the original local time sort.

In order to rectify this, we need to sort events based on the UTC time rather than the local time. By converting each event's local time to UTC and then reordering the list, we can ensure a globally accurate chronological listing of events.

Change History (4)

#1 @renyot
17 months ago

  • Owner set to renyot
  • Status changed from assigned to accepted

This ticket was mentioned in PR #158 on WordPress/wordpress.org by @renyot.


17 months ago
#2

Fixes https://meta.trac.wordpress.org/ticket/7071.

This PR proposes a code change that sorts all events according to their UTC time on the online events list page, to achieve a globally unified event order.

## Screenshot

Before After
https://i0.wp.com/github.com/WordPress/wordpress.org/assets/18050944/105ee503-c6b0-4b86-887b-acc9573bbd73 https://i0.wp.com/github.com/WordPress/wordpress.org/assets/18050944/3b4dd2f9-dd15-4473-ac40-6e1858476a67

## Testing Steps

  1. Apply the changes.
  2. Go to https://make.wordpress.org/community/events/online/ and see if the order is correct.

@renyot commented on PR #158:


17 months ago
#3

Gonna deploy the change.

  • The function is only used within the same file ✅ .

#4 @renyot
17 months ago

  • Resolution set to fixed
  • Status changed from accepted to closed

Fixed in [12667].

Note: See TracTickets for help on using tickets.