Update queries using image or oldimage tables
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Lokal_Profil
	Apr 18 2026, 7:47 AM

Project Tags

Referenced Files

None

Subscribers

Lokal_Profil

Description

On the 28th of May the image and oldimage tables go away <1>.

We should investigate if and where these tables are used in the heritage repo and update these queries.

Migration info can be found via T28741

Details

Related Changes in Gerrit:

	Subject	Author	Repo	Branch	Lines +/-
	Port check_emailable_users image lookup to file/filerevision join	Lokal Profil	labs/tools/heritage	master	+8 -6

Customize query in gerrit

Related Objects

Mentioned In: T55271: Add Hamburg in German to the monuments database
T423771: Move definition of scheduled Toolforge jobs into the heritage repository
Mentioned Here: T55271: Add Hamburg in German to the monuments database
T423771: Move definition of scheduled Toolforge jobs into the heritage repository
rTHERaea7a548b175: Avoid fill_table_monuments_all timeout on large monuments_all
rTHERd437bd87924b: Port cl_to lookups to linktarget join
rTHERfc241dbe6dd6: Port ContestStatsBuilder cl_to lookups to linktarget join
rTHER4f06be2e5859: Silence curl progress meter and drop response body in create_toolforge_job
rTHER9834961bdee6: Truncate muni on character boundary to avoid invalid UTF-8
rTHER2e13511cfd15: ignoring some more fields
rTHER762aedff98b1: always use PYWIKIBOT_BIN env variable
rTHER7e5f507c53b7: Pin venv interpreter via TOOLFORGE_VENV_PYTHON
rTHERe47c613c9ecd: Tighten requires-python to ~=3.11.0
rTHERf63e7843248d: Sync scheduled Toolforge jobs from jobs.yml.template
rTHER7fea33bae222: Port check_emailable_users image lookup to file/filerevision join
T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)

Event Timeline

Lokal_Profil created this task.Apr 18 2026, 7:47 AM

Quixk code search identifies these two:

api/includes/ContestStatsBuilder.php uses it, that is however a service saving WLM 2011!! stats. So might just be worth dropping it (and related classes)
erfgoedbot/check_emailable_users.py - to identify uploader

Lokal_Profil updated the task description. (Show Details)Apr 18 2026, 8:18 AM

There are additional occcurences in the tools/ directory (ranking, wlmlast, gallery-all). But those are already broken from before (neither using the actor or the linktarget tables). Worth having an active decision whether to keep and maintain or drop these tools.

Change #1275114 had a related patch set uploaded (by Lokal Profil; author: Lokal Profil):

[labs/tools/heritage@master] Port check_emailable_users image lookup to file/filerevision join

https://gerrit.wikimedia.org/r/1275114

gerritbot added a project: Patch-For-Review.Apr 18 2026, 9:50 PM

Change #1275114 merged by jenkins-bot:

[labs/tools/heritage@master] Port check_emailable_users image lookup to file/filerevision join

https://gerrit.wikimedia.org/r/1275114

Maintenance_bot removed a project: Patch-For-Review.Apr 19 2026, 10:31 PM

Mentioned in SAL (#wikimedia-cloud) [2026-04-20T06:52:36Z] <wmbot~lokal-profil@tools-bastion-15> Deploy aea7a54, d437bd8, fc241db, 4f06be2, 9834961, 2e13511 (T55271), 762aedf, 7e5f507, e47c613, f63e784 (T423771), 7fea33b (T423764)

Stashbot mentioned this in T423771: Move definition of scheduled Toolforge jobs into the heritage repository.Apr 20 2026, 6:52 AM

Stashbot mentioned this in T55271: Add Hamburg in German to the monuments database.

Lokal_Profil closed this task as Resolved.Apr 23 2026, 9:19 PM

Lokal_Profil claimed this task.

Update queries using image or oldimage tablesClosed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

Update queries using image or oldimage tables
Closed, ResolvedPublic
Actions