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