Where is subversion of the postgresql database schema? There's an error between image and oldimage. Inserts into oldimage are based on nested selects()'s from image -- the casting text::bytea doesn't work.
CREATE TABLE image (
[...snip...] img_metadata TEXT,
);
CREATE TABLE oldimage ( [...snip...] oi_metadata BYTEA NOT NULL DEFAULT '',
);
It looks like the Ubuntu flunkies already picked it up:
http://patches.ubuntu.com/by-release/debian/m/mediawiki/mediawiki_1:1.11.1-1...
Fixed in subversion and RFP/MFC'd to REL_12 branch:
http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3/maintenance/postgres...
r26042 | greg | 2007-09-23 16:47:17 -0400 (Sun, 23 Sep 2007) | 2 lines
(Bug 11363). Change image and filearchive to bytea from text, to match oldimage.
http://svn.wikimedia.org/svnroot/mediawiki/branches/REL1_12/phase3/maintenan... http://svn.wikimedia.org/svnroot/mediawiki/branches/REL1_11/phase3/maintenan...
On Tue, 2008-03-11 at 10:58 -0400, Brian A. Seklecki wrote:
Where is subversion of the postgresql database schema? There's an error between image and oldimage. Inserts into oldimage are based on nested selects()'s from image -- the casting text::bytea doesn't work.
CREATE TABLE image (
[...snip...] img_metadata TEXT,
);
CREATE TABLE oldimage ( [...snip...] oi_metadata BYTEA NOT NULL DEFAULT '',
);
It looks like the Ubuntu flunkies already picked it up:
http://patches.ubuntu.com/by-release/debian/m/mediawiki/mediawiki_1:1.11.1-1...
mediawiki-l@lists.wikimedia.org