Wikidata:Translators' noticeboard/Archive/2021/08

Linking a translated page

I recently became an auto-confirmed user, but I still don't have permission to link a translated page to a main page. The page does, however, say that auto-confirmed users can perform this activity. I was auto-confirmed about 20 minutes ago, so perhaps it takes some time? I would like to know more about this/when I'll have permission. I get this message: "This page is currently create-protected and can be created only be established registered users."

The user was not autoconfirmed, I have already answered him on my talk page. --Ameisenigel (talk) 07:31, 4 August 2021 (UTC)

I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Ameisenigel (talk) 07:31, 4 August 2021 (UTC)

Перевод страницы художника Макарова Виктора на русский

Добрый день. Нужно сделать русский перевод этой страницы Мне нужно самому опубликовать статью? До этого создал страницу на русском языке, но ее удалили.  – The preceding unsigned comment was added by Maxer252 (talk • contribs) at 11:12, 7 August 2021 (UTC).

Привет @Maxer252:! Ваш пост в русскоязычной Википедии удален, потому что он не важен. Это не связано с Викиданными. Пожалуйста, обсудите ваши опасения прямо в русскоязычной Википедии. (ru:Википедия:Оспаривание итогов) --Ameisenigel (talk) 11:15, 8 August 2021 (UTC)

I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Ameisenigel (talk) 11:15, 8 August 2021 (UTC)

ًwhere do I find this list !

Hello everyone,

I am just wondering where do I find the list of languages that appear in the header box in the item's pages?--Michel Bakni (talk) 13:28, 28 August 2021 (UTC)

@Michel Bakni: Help:Wikimedia language codes/lists/all --Ameisenigel (talk) 06:53, 17 October 2021 (UTC)

I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Ameisenigel (talk) 06:53, 17 October 2021 (UTC)

Query for translatable and translated pages

Tracked in Phabricator
Task T289952

(This is a bit offtopic on this noticeboard, but I hope to find for expertise here.)

I would like to query the MediaWiki SQL database and retrieve these:

• Some marker whether a page is a translatable page, such as Wikidata:Notability for instance
• Some marker whether a page is a translated page, such as Wikidata:Notability/de for instance
• Some relation between a translated page and the translation sections (the ones in "Translation" namespace)

Right now I have no clue where this information resides, so it is a bit difficult to get started. I do not need full SQL queries, just a pointer which tables I need to look at. Thanks, —MisterSynergy (talk) 06:20, 28 August 2021 (UTC)

@MisterSynergy: The PHP code checking the first two is in tag/TranslatablePage.php (TranslatablePage::isSourcePage and TranslatablePage::isTranslationPage methods, respectively). If I get the code correctly,

SELECT DISTINCT rt_page
	FROM revtag JOIN page ON rt_page = page_id
	WHERE rt_revision = page_latest AND rt_type IN ('tp:mark', 'tp:tag');

returns the list of all translatable pages; you can add more filters for the page table to find out whether a particular page is translatable (first question).

The second question is more difficult, as this information doesn’t seem to be stored in the DB: a page is considered translated if its base page is a translatable page (see first question) and its subpage title is a valid language code (this is a runtime information, not stored in the database).

I didn’t look up the third question, but I fear it also depends on a runtime bit of information, namely the namespace name: the translation units’ titles are in the format Translation:fullpagename/unitid/langcode, where fullpagename/langcode is the translation page; fullpagename contains the human-readable namespace name, not the numeric namespace ID. unitid is usually a number, although it’s not enforced.

Also, if you want to use this on Wikimedia sites, there’s one more slight issue: the revtag table is not available in public replica databases for some reason. I’m not sure if it’s intentional, though. —Tacsipacsi (talk) 22:08, 28 August 2021 (UTC)

Thanks a lot, this is extremely valuable for me.

Unfortunately I am trying to query this information for Wikidata, so the non-public revtag table is a problem here. I am going to talk to WMF technicians whether this can be changed or not. —MisterSynergy (talk) 22:36, 28 August 2021 (UTC)