[rt-users] Bug in rt-dump-metadata

[Joop]

> On Mon, Sep 22, 2014 at 01:46:22PM +0200, Joop wrote:
>> I'm looking at migrating some data from one instance of RT to another
>> and I'm using rt-dump-metadata (4.2.7) to see what I can use.
>
> You may actually want to be using the migration tools built into 4.2
>
>> Invoking it with the '-a' option leads to an error and no output:
>> /opt/rt4/sbin/rt-dump-metadata >metadata.dump
>> [6238] [Mon Sep 22 11:25:32 2014] [warning]: DBD::Pg::st execute failed:
>> ERROR:  function lower(integer) does not exist
>> LINE 1: SELECT  * FROM Templates WHERE LOWER(Id) = LOWER($1)
>>
>> Doing a lower on a integer isn't allowed, thats the problem.
>
> Please send this to the bug tracker with
> Set($LogStackTraces, "error");
> enabled.
>
> You should also confirm that this is oracle or Pg in that bug report.
Ticket #30415 as per request.

Joop