Page MenuHomePhabricator

Can't Replace Images (PostgreSQL)
Closed, ResolvedPublic

Description

Author: harding.ian

Description:
When trying to replace an image the following error occurs.

A database error has occurred Query: INSERT INTO oldimage (oi_name,oi_archive_name,oi_size,oi_width,oi_height,oi_bits,oi_timestamp,oi_description,oi_user,oi_user_text,oi_metadata,oi_media_type,oi_major_mime,oi_minor_mime,oi_sha1) SELECT img_name,'20080313142648!rGPAR625671445735.jpg',img_size,img_width,img_height,img_bits,img_timestamp,img_description,img_user,img_user_text,img_metadata,img_media_type,img_major_mime,img_minor_mime,img_sha1 FROM image WHERE img_name = 'rGPAR625671445735.jpg' Function: LocalFile::recordUpload2 Error: 1 ERROR: column "oi_metadata" is of type bytea but expression is of type text LINE 1: ...,oi_timestamp,oi_description,oi_user,oi_user_text,oi_metadat... ^ HINT: You will need to rewrite or cast the expression.


Version: 1.11.x
Severity: enhancement

Details

Reference
bz13345

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.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:07 PM
bzimport set Reference to bz13345.
bzimport added a subscriber: Unknown Object (MLST).

Please run maintenance/update.php . Dunno if that'll fix it, but it just might.

harding.ian wrote:

Oh hi. I did that and it didn't help.

There have been some changes in the last week or so to related code - can you try again with a recent subversion snapshot?

  • This bug has been marked as a duplicate of bug 11363 ***
Jdforrester-WMF subscribed.

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