Page MenuHomePhabricator

langlinks table not being updated for many pages
Closed, DuplicatePublic

Description

for many case the langlinks API and database query can not purge or update themself and show the old wrong interwiki link!

API: for example:
http://en.wikipedia.org/w/api.php?action=query&prop=langlinks&titles=Oldsmobile_Intrigue

<ll lang="fa" xml:space="preserve">الگو:اولدزموبیل</ll>

Query in labs :

sql enwiki_p

SELECT page_title,ll_title FROM page JOIN langlinks ON page_id = ll_from WHERE page_is_redirect = 0 AND page_title='Oldsmobile_Intrigue' and page_namespace=0 AND ll_lang='fa' GROUP BY ll_from;

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

page_titlell_title

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

Oldsmobile_Intrigueالگو:اولدزموبیل

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

which should be اولدزموبیل_اینتریگ

Also For these case it is the same!

Oldsmobile 
Oldsmobile_88 
Oldsmobile_Intrigue 
Oldsmobile_Cutlass_Supreme 
Oldsmobile_Silhouette 
Oldsmobile_Firenza 
Oldsmobile_Bravada 
Oldsmobile_Cutlass_Calais 
Oldsmobile_Custom_Cruiser 
Oldsmobile_Achieva 
Compressed_hydrogen 
Bastak 
Bastak_County 
Guwdah 
Azdi_Bastak 
Pisah 
Lard-e_Basto 
Moghdan-e_Bastak 
Morwa,_Hormozgan 
Tang-e_Dalan,_Hormozgan 
Nakhahry 

and more than 200 other cases!


Version: unspecified
Severity: major

Details

Reference
bz55958

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:20 AM
bzimport added a project: MediaWiki-JobQueue.
bzimport set Reference to bz55958.
bzimport added a subscriber: Unknown Object (MLST).
Yamaha5 created this task.Oct 21 2013, 7:27 AM

This bug cause some bot and gadgets get wrong interwiki and do wrong works!

this bug didn't update interwikis since 9 OCT!
See: https://en.wikipedia.org/w/index.php?title=Template:Oldsmobile&diff=prev&oldid=576489983

after this change API and query should show article's interwiki not the template's.

Certainly not an API bug, the API is correctly returning the contents of the langlinks table.

Bug 50924 also seems unrelated, as that has to do with edits on Wikidata not propagating to local wikis.

The problem here seems to be that the job queue did not properly update langlinks for the transcluding pages after https://en.wikipedia.org/w/index.php?title=Template:Oldsmobile&diff=prev&oldid=576489983.

it is not only for templates please see

http://fa.wikipedia.org/w/api.php?action=query&prop=langlinks&titles=%D8%B2%D8%A8%D8%A7%D9%86_%D8%AA%D8%A7%DB%8C
or

http://fa.wikipedia.org/w/api.php?action=query&prop=langlinks&titles=%D8%AF%D8%B3%D8%AA%DA%AF%D8%A7%D9%87_%D8%AA%D9%86%D9%81%D8%B3%DB%8C

it shouldn't have any interwiki!
or
please get this query

SELECT /*SLOW OK */ page_title,ll_lang FROM page JOIN langlinks ON page_id = ll_from WHERE page_namespace = 0 AND page_is_redirect = 1 GROUP BY page_title ORDER BY count(ll_from) DESC;

the result will show many pages which doesn't have any interwiki:

page_title ll_lang

زبان_تای af
ولگاگراد_(شهر) af
ناحیه_(فرانسه) af
لئوناردو_فیبوناچی af
زبان‌های_ترکی an
تغییر_ساعت_تابستانی af
ازن_(مولکول) af
استان_لاریخا an
ماده‌گرایی af
شارلوت،_کارولینای_شمالی an
فهرست_ناحیه‌های_ایتالیا af
دستگاه_تنفسی an
سوسمار an
نیایشگاه_آرتمیس ar
پاپ_فرانسیس af
فهرست_استان‌های_ترکیه ar
کارون_(ماه) af
هسته_سیستم‌عامل af
لایه_ازن af
وال_کوسه af
تقسیمات_کشوری_ژاپن af
استان_سند ar
قانون_جهانی_گرانش_نیوتون af
باشگاه_فوتبال_گالاتاسرای ar
پراگماتیسم ar
سرآغاز_(فیلم) ar
پاپ_مارک af
سدنا ar

aaron added a comment.Nov 6 2013, 1:36 AM

Do null (no change) edits help any of these pages?

I null edited [[Oldsmobile Intrigue]], and it was fixed after I did so. So I guess the job could have been lost, or not yet executed.

(In reply to comment #6)

Do null (no change) edits help any of these pages?

before this report I clicked on purge but it doesn't change!

can we do the null edit by bot because they are more than 300 pages!

Aklapper lowered the priority of this task from High to Normal.Apr 9 2015, 12:37 PM