日付範囲がおかしいようです

zogstrip · 2025 年 12 月 5 日午後 3:15

動画ありがとうございます。ローカルで再現できるようになりました🙌

非常に微妙な問題でしたが、修正はこちらです。

github.com/discourse/discourse

FIX: event not found after being edited to earlier date

main ← fix-event-not-found-after-being-moved-to-earlier-date

opened 03:15PM - 05 Dec 25 UTC

ZogStriP

+100 -22

Events that were edited to an earlier date multiple times were not appearing in …EventFinder search results when querying their new date range. The SQL query in `EventFinder.latest_event_date_join` used a different ordering than the Ruby `Event#current_event_date` logic: - SQL: `ORDER BY finished_at DESC NULLS FIRST, starts_at DESC` - Ruby: pending dates by `starts_at`, finished dates by `updated_at, id` This mismatch caused the SQL to return a different "current" event date than what the Ruby model expected, breaking date range filtering for rescheduled events. - Extracted duplicated logic in `Event#starts_at` and `Event#ends_at` into a shared `current_event_date` method - Updated the SQL ordering to mirror the Ruby logic: `finished_at IS NOT NULL, CASE WHEN finished_at IS NULL THEN starts_at ELSE updated_at END DESC, id DESC` - Updated the database index to support the new query - Added regression test for the "event edited to earlier date" scenario Bug report - https://meta.discourse.org/t/date-range-seems-wrong/389891

トピック		返信	表示
Calendar event seems broken? Bug calendar-and-events , fixed	11	305	2025 年 6 月 25 日
Date ranges breaks checklists Support checklist	2	254	2024 年 4 月 19 日
Discourse Calendar updated to use fullcalendar 6 Announcements calendar-and-events	35	1621	2026 年 2 月 13 日
Cannot select next month in the calendar when pinning topic Bug	5	1786	2015 年 9 月 23 日
Discourse calendar no longer shows any events (in some browsers only) Bug calendar-and-events	15	1014	2023 年 10 月 10 日

日付範囲がおかしいようです

関連トピック