Bild-prefix is added to il_to value of imagelinks table
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	Merl
	Nov 3 2011, 12:06 PM

Description

On dewiki the imagelinks tables contains values like "Bild:<imagename>" at il_to although the page source correctly contains [[Datei:<imagename>]]. The image namespace prefix must not be add to the il_to value.

If you are doing a null edit using index.php the wrong entry is deleted. But we made a null edit on all pages and there are some few news ones every day.

You can find examples on the missing file reported created twice a week on http://de.wikipedia.org/wiki/Wikipedia:Redaktion_Bilder/Arbeitsliste_Fehlende_Bilder if you are searching for "Datei:Bild:"

I don't know the reason, but perhaps there is a single not updated squid or an old mantanace scripts that run on wmf.

Version: unspecified
Severity: normal
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=32171

Details

Reference: bz32170

	Title	Reference	Author	Source Branch	Dest Branch
	Change test instance scap target to an-test-client1002	repos/data-engineering/airflow-dags-scap-analytics_test!1	stevemunene	change_test_instance_to_1002	main

Customize query in GitLab

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:59 PM

• bzimport added a project: WMF-General-or-Unknown.

• bzimport set Reference to bz32170.

• bzimport added a subscriber: Unknown Object (MLST).

Merl created this task.Nov 3 2011, 12:06 PM

The test cases I've checked all involve <gallery>. One of them has a gallery which uses a mixture of Bild: and Datei: namespaces:

https://de.wikipedia.org/w/index.php?title=Haleakal%C4%81-Nationalpark&oldid=96185932&action=edit

The imagelinks table row for the image with Datei: is correct, but the one with Bild: has the prefix.

mysql> select il_to from imagelinks,page where page_id=il_from and page_namespace=0 and page_title='Haleakalā-Nationalpark';
+-----------------------------------------+

il_to

+-----------------------------------------+

Bild:Kipahulu_coast.jpg

Bild:Panorama_Haleakala.jpg

Bild:Panorama_Haleakala2.jpg

Commons-logo.svg

Haleakala_National_Park_map_2008.08.jpg

Haleakala_crater.jpg

Maui_moku_map_2.jpg

+-----------------------------------------+

It's consistent with the namespaceAliases item in the localisation cache being empty, but the namespaceNames being correct. If Bild is not a recognised namespace, then normal image links would be converted to pagelinks entries, but in a gallery they get put in the imagelinks table. Sure enough:

mysql> select pl_namespace,pl_title from pagelinks,page where page_id=pl_from and page_namespace=0 and page_title='Haleakalā-Nationalpark';

...

0	Bild:USA_Hawaii_location_map.svg

...

Probably shares a root cause with bug 31576.

https://bugzilla.wikimedia.org/show_bug.cgi?id=32404#c11

This bug has been marked as a duplicate of bug 33409 ***

Bild-prefix is added to il_to value of imagelinks tableClosed, ResolvedPublicActions

Description

Details

Event Timeline

Bild-prefix is added to il_to value of imagelinks table
Closed, ResolvedPublic
Actions