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. 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:31 2014] [info]: RT's SMIME libraries couldn't successfully read your configured SMIME keyring directory (/opt/rt4/var/data/smime). (/opt/rt4/sbin/../lib/RT/Config.pm:722) [6238] [Mon Sep 22 11:25:31 2014] [warning]: Auth::GnuPG and Auth::SMIME (from an extension) have been replaced with Auth::Crypt. @MailPlugins has been adjusted, but should be updated to replace both with Auth::Crypt to silence this warning. (/opt/rt4/sbin/../lib/RT/Config.pm:644) [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. Joop -- RT Training November 4 & 5 Los Angeles http://bestpractical.com/training
