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
pgpdi_W9RhKjN.pgp
Description: PGP signature
-- RT Training November 4 & 5 Los Angeles http://bestpractical.com/training
