Page MenuHomePhabricator

The column us_props is missing from the mediawiki.uploadstash table with PostgreSQL
Closed, ResolvedPublic

Description

Mediawiki 1.22.5 with PostgreSQL 8.4.7, unable to upload files :
ERROR: column "us_props" of relation "uploadstash" does not exist

I see that into maintenance/postgres/tables.sql the "CREATE TABLE uploadstash" statement is missing the us_props field.

It seems that other versions of Mediawiki are affected :
https://www.mediawiki.org/wiki/Thread:Project:Support_desk/postgres:_column_%22us_props%22_of_relation_%22uploadstash%22_does_not_exist


Version: 1.22.5
Severity: normal

Details

Reference
bz63893

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to Normal.
bzimport set Reference to bz63893.
bzimport added a subscriber: Unknown Object (MLST).

I can verify that us_props is not there, but I cannot get this to cause problems during file upload. It seems the common file upload method does not try to use the uploadstash table at all. Can you describe what upload process, or what configuration settings, you use in order to invoke this behavior?

(In reply to Jeff Janes from comment #1)

I can verify that us_props is not there, but I cannot get this to cause
problems during file upload. It seems the common file upload method does
not try to use the uploadstash table at all. Can you describe what upload
process, or what configuration settings, you use in order to invoke this
behavior?

Try stashed uploads (its part of the api). Normal uploads do not use it, but it is used by the upload wizard extension, or can be triggered by using the api directly.

I only just now realized that this is already fixed in 1.23 in
Change-Id: I057b1dd845a5ab7ae05f5597454981a6e2c12698

Do we want to backport it to 1.22 and 1.21, or is the fix to the upcoming release good enough?

Bug 64067 affects upgrades to 1.23 just as it does 1.22.

Was backported to REL1_22 with gerrit 132192

Is this fixed, now?

Tgr closed this task as Resolved.Dec 27 2014, 6:56 PM
Tgr claimed this task.

Fixed in 1.22/1.23, not fixed in 1.21 but that branch was end-of-lifed in June.

Jdforrester-WMF added a subscriber: Jdforrester-WMF.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.

Restricted Application added subscribers: TerraCodes, Matanya. · View Herald TranscriptNov 2 2016, 8:16 PM