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
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
DeclinedMarostegui
ResolvedMarostegui
ResolvedUmherirrender
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedBUG REPORTZabe

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.