Run ReadingLists normalizeEntryTitles.php script
Open, MediumPublic1 Estimated Story Points
Actions

Assigned To

Authored By

	aude
	May 11 2026, 3:07 PM

Project Tags

Referenced Files

None

Subscribers

Aklapper

AnneT

aude

Description

In T422041, we created a maintenance script to normalize reading list entries in the reading_list_entries DB table, to ensure entries page titles are stored with underscores. Entries ended up with spaces if they were saved via iOS or via the API endpoints. They were stored spaces if saved via Android or web.

There are ~21 million such entries with spaces (out of ~67 million entries overall).

We need to run the script to cleanup the entries that have spaces, and convert them to be stored with underscores.

Requirements

Run script

QA

Confirm the work in T422009: Add instrumentation and benchmarks for ReadingLists bloom filter lookups has been implemented correctly.

Related Objects

Mentioned In: T422009: Add instrumentation and benchmarks for ReadingLists bloom filter lookups
Mentioned Here: T422009: Add instrumentation and benchmarks for ReadingLists bloom filter lookups
T422041: Create maintenance script to apply normalization and deduplicate existing reading list entries

Event Timeline

aude created this task.May 11 2026, 3:07 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 11 2026, 3:08 PM

aude moved this task from Incoming to Needs refinement on the Reader Experience Team board.May 11 2026, 5:30 PM

Volker_E triaged this task as High priority.May 11 2026, 5:32 PM

Volker_E edited projects, added: Reader Experience Team (REx Sprint 20 [Q4 May 5 - May 18]); removed: Reader Experience Team.

Volker_E set the point value for this task to 2.

aude claimed this task.Fri, May 15, 7:22 PM

aude moved this task from Ready to In progress on the Reader Experience Team (REx Sprint 20 [Q4 May 5 - May 18]) board.

AnneT moved this task from REx Sprint 20 [Q4 May 5 - May 18] to Ready for sprint on the Reader Experience Team board.Tue, May 19, 5:12 PM

AnneT edited projects, added: Reader Experience Team; removed: Reader Experience Team (REx Sprint 20 [Q4 May 5 - May 18]).

Jdlrobson-WMF moved this task to Backlog on the Reader Experience Team board.Tue, May 19, 5:40 PM

AnneT moved this task from Backlog to Ready for sprint on the Reader Experience Team board.Tue, May 19, 5:40 PM

Jdlrobson-WMF updated the task description. (Show Details)Tue, May 19, 5:46 PM

Jdlrobson-WMF mentioned this in T422009: Add instrumentation and benchmarks for ReadingLists bloom filter lookups.

hey @aude, we kicked this back to ready for sprint so we can focus on 2 high-priority sprint goals with a very reduced capacity due to vacations and offsites. If we wrap up the donor badge experiment work and the donor identification script, and there's nothing to do on the other sprint tasks (e.g. the rotor fix), I think it'd be fine to bring this into sprint 21.

aude moved this task from Ready for sprint to REx Sprint 21 [Q4 May 19 - Jun 1] on the Reader Experience Team board.Tue, May 26, 5:27 PM

aude edited projects, added: Reader Experience Team (REx Sprint 21 [Q4 May 19 - Jun 1]); removed: Reader Experience Team.

aude moved this task from Ready to In progress on the Reader Experience Team (REx Sprint 21 [Q4 May 19 - Jun 1]) board.Tue, May 26, 5:47 PM

HFan-WMF edited projects, added: Reader Experience Team (REx Sprint 22 [Q4 Jun 2 - Jun 15]); removed: Reader Experience Team (REx Sprint 21 [Q4 May 19 - Jun 1]).Tue, Jun 2, 5:23 PM

HFan-WMF changed the point value for this task from 2 to 1.

aude moved this task from Ready to In progress on the Reader Experience Team (REx Sprint 22 [Q4 Jun 2 - Jun 15]) board.Tue, Jun 2, 5:32 PM

Jdlrobson-WMF lowered the priority of this task from High to Medium.Mon, Jun 8, 5:51 PM

aude updated the task description. (Show Details)Wed, Jun 10, 5:57 PM