changelog | [dreamwidth/dreamwidth] 509bbe: Fix support search falling back to relevance order...

Branch: refs/heads/main Home: https://github.com/dreamwidth/dreamwidth Commit: 509bbe7db1da795134ca05853263af4adb140022 https://github.com/dreamwidth/dreamwidth/commit/509bbe7db1da795134ca05853263af4adb140022 Author: Mark Smith mark@dreamwidth.org Date: 2026-05-24 (Sun, 24 May 2026)

Changed paths: M bin/search-tool

Log Message:

Fix support search falling back to relevance order instead of newest-first

bin/search-tool's import-support selected UNIX_TIMESTAMP(timelogged) AS touchtime, but supportlog.timelogged is already an int-unsigned Unix epoch. Re-parsing that integer as a datetime yields 0, so every dwsupport row was stored with touchtime=0. With all rows tied on the sort key, Manticore's ORDER BY touchtime DESC became a no-op and results fell back to BM25 relevance order. Select timelogged raw, matching how the column is read everywhere else and the legacy bin/maint/search.pl copier.

Existing rows need a re-import (TRUNCATE dwsupport, then rerun import-support) to backfill correct touchtimes.

Co-Authored-By: Claude Opus 4.7 (1M context) noreply@anthropic.com

Commit: fd606abb872deda1a30437ca267344ebb29565b0 https://github.com/dreamwidth/dreamwidth/commit/fd606abb872deda1a30437ca267344ebb29565b0 Author: Mark Smith mark@dreamwidth.org Date: 2026-05-24 (Sun, 24 May 2026)

Changed paths: M cgi-bin/DW/External/Site.pm M cgi-bin/DW/Task/SearchCopier.pm

Log Message:

Tidy SearchCopier and External::Site

Formatting-only changes from tidyall -a; no logic changes. Brings both files into line with .tidyallrc so t/02-tidy.t passes.

Co-Authored-By: Claude Opus 4.7 (1M context) noreply@anthropic.com

Compare: https://github.com/dreamwidth/dreamwidth/compare/41eb4c6eded5...fd606abb872d

To unsubscribe from these emails, change your notification settings at https://github.com/dreamwidth/dreamwidth/settings/notifications