Topic on Project:Support desk

Jump to navigation Jump to search

postgres: column "us_props" of relation "uploadstash" does not exist

Bergonz (talkcontribs)

mediawiki 1.21.3, postgresql 9.1.9, PHP 5.4.4-14+deb7u5 (apache2handler), internal wiki not internet accessible. Fresh installation (not an update).

The column us_props is missing from the mediawiki.uploadstash table. This causes the error:

ERROR: column "us_props" of relation "uploadstash" does not exist

I tried deleting the table and recreating with php maintenance/update.php, but it doesn't add it. I created it in psql:

alter table mediawiki.uploadstash add column us_props bytea null;

and now I can upload files.

Hope this helps. (talkcontribs)

You say you created a new installation with Postgres and a column is missing. This should not happen. Is this behaviour reproducable for you? (talkcontribs)

I can confirm the problem: Debian GNU/Linux, PostgreSQL 9.1.9-1, MediaWiki 1.21.3. I see that into maintenance/postgres/tables.sql the "CREATE TABLE uploadstash" statement is missing the us_props field. (talkcontribs)

Alright. Can you please open an issue for that in the bugzilla bugtracker?

And when you are at it: Can you please add, if - apart from column us_props of table uploadstash - if there also are other columns, which you are missing?

Reply to "postgres: column "us_props" of relation "uploadstash" does not exist"