Page MenuHomePhabricator

IF () calls do not work for Postgres
Closed, ResolvedPublic

Description

Author: dioptre

Description:
in the file: /var/www/includes/filerepo/LocalFile.php
there are two locations which must be changed so that the system works with postgres.....

'fa_storage_key' => "CASE WHEN img_sha1='' THEN '' ELSE img_sha1||$encExt END",

//'fa_storage_key'   => "IF(img_sha1='', '', CONCAT(img_sha1,$encExt))",

:0


Version: 1.11.x
Severity: critical

Details

Reference
bz11598

Event Timeline

bzimport raised the priority of this task from to High.Nov 21 2014, 9:55 PM
bzimport set Reference to bz11598.
bzimport added a subscriber: Unknown Object (MLST).

dioptre wrote:

ps included the diff showing what should be corrected

  • Bug 14337 has been marked as a duplicate of this bug. ***