Page MenuHomePhabricator

bldrwnsch update is broken – Unknown column 'pagelinks.pl_title'
Closed, ResolvedPublic

Description

2024/05/21 14:57:03 Reading Bilderwuensche from database
panic: Error 1054 (42S22): Unknown column 'pagelinks.pl_title' in 'field list'

goroutine 7 [running]:
github.com/simon04/bldrwnsch/bldrwnsch.(*MediawikiDB).SelectBilderwuensche(0xc000014050, {0xc000012168, 0x3, 0x0?})
	/home/simon/src/bldrwnsch/bldrwnsch/mediawiki.go:36 +0x365
created by main.main
	/home/simon/src/bldrwnsch/updateBilderwuensche.go:27 +0x19c
SELECT page.page_title, pagelinks.pl_title, geo_tags.gt_lat, geo_tags.gt_lon
FROM pagelinks JOIN page ON pagelinks.pl_from = page.page_id
LEFT JOIN geo_tags ON geo_tags.gt_primary=1 AND geo_tags.gt_globe='earth' AND geo_tags.gt_page_id=page.page_id
WHERE page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to LIKE 'Wikipedia:Bilderwunsch%')
AND pagelinks.pl_title LIKE 'Bilderwunsch/code%';

Related Objects

StatusSubtypeAssignedTask
Resolvedsimon04
ResolvedLadsgroup
ResolvedLadsgroup
ResolvedABran-WMF
ResolvedLadsgroup
ResolvedLadsgroup
ResolvedLadsgroup
ResolvedJAllemandou
ResolvedLadsgroup
ResolvedSBisson
ResolvedLadsgroup
ResolvedLadsgroup
Resolved Marostegui
Resolved Marostegui
Resolved Marostegui
Resolved Marostegui
Resolved Marostegui
Resolved Marostegui
Resolved Marostegui
Declined Marostegui
Resolved Marostegui
ResolvedUmherirrender
Resolved Marostegui
Resolved Marostegui
Resolved Marostegui

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Jdforrester-WMF changed the subtype of this task from "Production Error" to "Task".May 21 2024, 3:34 PM
Jdforrester-WMF subscribed.

This is not a production error.

That query is wrong, JOIN pagelinks ON pagelinks.pl_target_id = page.page_id won't work. pl_target_id is not FK to page_id, pl_from is but it depends on your usecase.