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

[Kevin Falcone]

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.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 221 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140922/8e4c75d3/attachment.sig>