diff options
| author | mkanat%kerio.com <> | 2005-07-08 11:34:03 +0200 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-07-08 11:34:03 +0200 |
| commit | 0811ac92bf752121208867728aa4629b9eb9c02a (patch) | |
| tree | 730552d2c127f5992639e3852eeea105e1e7c71a /checksetup.pl | |
| parent | 4f25eedf9065f28badf1e5e1df6c925062d8279e (diff) | |
| download | bugzilla-0811ac92bf752121208867728aa4629b9eb9c02a.tar.gz bugzilla-0811ac92bf752121208867728aa4629b9eb9c02a.tar.xz | |
Bug 292119: [PostgreSQL] POSITION(...) clause "must be type boolean, not type integer"
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=dkl, a=justdave
Diffstat (limited to 'checksetup.pl')
| -rwxr-xr-x | checksetup.pl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/checksetup.pl b/checksetup.pl index 42582fa65..176ad463c 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3687,8 +3687,8 @@ if ($dbh->isa('Bugzilla::DB::Mysql') print "Removing paths from filenames in attachments table...\n"; $sth = $dbh->prepare("SELECT attach_id, filename FROM attachments " . - "WHERE " . $dbh->sql_position(q{'/'}, 'filename') . - " OR " . $dbh->sql_position(q{'\\\\'}, 'filename')); + "WHERE " . $dbh->sql_position(q{'/'}, 'filename') . " > 0 OR " . + $dbh->sql_position(q{'\\\\'}, 'filename') . " > 0"); $sth->execute; while (my ($attach_id, $filename) = $sth->fetchrow_array) { |