Rt-dump-metadata selecting nonextistent column

RT Users
1

Per the excellent advice I received at Ohio LinuxFest, I tried to run
rt-dump-metadata, but received the following error message:

[Sat Sep 21 00:04:11 2013] [warning]: DBD::Oracle::db prepare failed:
ORA-00904: “PRIVATEKEY”: invalid identifier (DBD ERROR: error possibly near
<> indicator at char 7 in 'SELECT <>privatekey FROM Users WHERE id =
:p1’) [for Statement “SELECT privatekey FROM Users WHERE id = ?”] at
/webdata/perl5/perlbrew/perls/perl-5.18.0/lib/site_perl/5.18.0/DBIx/SearchBuilder/Handle.pm
line 549.

I checked, and my Users table does not have a privatekey column.

This installation started with 4.0.15, and I’ve since installed 4.016 and
4.0.17 over the top, but I don’t recall being instructed to upgrade the
database with either point release.

Did I miss a memo?

Len.

lenjaffe@jaffesystems.com 614-404-4214 @lenjaffe
Host of Columbus Code Jam http://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.

2

Per the excellent advice I received at Ohio LinuxFest, I tried to run rt-dump-metadata, but
received the following error message:
[Sat Sep 21 00:04:11 2013] [warning]: DBD::Oracle::db prepare failed: ORA-00904: “PRIVATEKEY”:
invalid identifier (DBD ERROR: error possibly near <> indicator at char 7 in 'SELECT
<>privatekey FROM Users WHERE id = :p1’) [for Statement “SELECT privatekey FROM Users WHERE
id = ?”] at
/webdata/perl5/perlbrew/perls/perl-5.18.0/lib/site_perl/5.18.0/DBIx/SearchBuilder/Handle.pm
line 549.
I checked, and my Users table does not have a privatekey column.
This installation started with 4.0.15, and I’ve since installed 4.016 and 4.0.17 over the top,
but I don’t recall being instructed to upgrade the database with either point release.
Did I miss a memo?

http://issues.bestpractical.com/Ticket/Display.html?id=22465

-kevin

3

I swear I searched before I posted.

Given that I’m getting a XML file back from rt-d-m, what’s your opinion of
it’s trustworthyness?

Is there an ETA on an update or a patch?

Thank you,
Len.On Fri, Sep 20, 2013 at 8:24 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Fri, Sep 20, 2013 at 08:12:21PM -0400, Len Jaffe wrote:

Per the excellent advice I received at Ohio LinuxFest, I tried to run
rt-dump-metadata, but
received the following error message:
[Sat Sep 21 00:04:11 2013] [warning]: DBD::Oracle::db prepare failed:
ORA-00904: “PRIVATEKEY”:
invalid identifier (DBD ERROR: error possibly near <> indicator at
char 7 in 'SELECT
<>privatekey FROM Users WHERE id = :p1’) [for Statement “SELECT
privatekey FROM Users WHERE
id = ?”] at

/webdata/perl5/perlbrew/perls/perl-5.18.0/lib/site_perl/5.18.0/DBIx/SearchBuilder/Handle.pm

line 549.
I checked, and my Users table does not have a privatekey column.
This installation started with 4.0.15, and I’ve since installed 4.016
and 4.0.17 over the top,
but I don’t recall being instructed to upgrade the database with
either point release.
Did I miss a memo?

Login

-kevin

–
RT Training in New York, October 8th and 9th:
http://bestpractical.com/training

lenjaffe@jaffesystems.com 614-404-4214 @lenjaffe
Software Engineer, Founder Volunteerable http://www.volunteerable..com/,
Host of Columbus Code Jam http://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.

4

It looks like it dumped enough data for me to bootstrap my new instance.
I’m pretty pleased.

Len.On Mon, Sep 23, 2013 at 9:41 AM, Len Jaffe lenjaffe@jaffesystems.comwrote:

I swear I searched before I posted.

Given that I’m getting a XML file back from rt-d-m, what’s your opinion of
it’s trustworthyness?

Is there an ETA on an update or a patch?

Thank you,
Len.

On Fri, Sep 20, 2013 at 8:24 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Fri, Sep 20, 2013 at 08:12:21PM -0400, Len Jaffe wrote:

Per the excellent advice I received at Ohio LinuxFest, I tried to
run rt-dump-metadata, but
received the following error message:
[Sat Sep 21 00:04:11 2013] [warning]: DBD::Oracle::db prepare
failed: ORA-00904: “PRIVATEKEY”:
invalid identifier (DBD ERROR: error possibly near <> indicator at
char 7 in 'SELECT
<>privatekey FROM Users WHERE id = :p1’) [for Statement “SELECT
privatekey FROM Users WHERE
id = ?”] at

/webdata/perl5/perlbrew/perls/perl-5.18.0/lib/site_perl/5.18.0/DBIx/SearchBuilder/Handle.pm

line 549.
I checked, and my Users table does not have a privatekey column.
This installation started with 4.0.15, and I’ve since installed
4.016 and 4.0.17 over the top,
but I don’t recall being instructed to upgrade the database with
either point release.
Did I miss a memo?

Login

-kevin

–
RT Training in New York, October 8th and 9th:
http://bestpractical.com/training

–
lenjaffe@jaffesystems.com 614-404-4214 @lenjaffe
Software Engineer, Founder Volunteerable http://www.volunteerable..com/,
Host of Columbus Code Jam http://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.

lenjaffe@jaffesystems.com 614-404-4214 @lenjaffe
Software Engineer, Founder Volunteerable http://www.volunteerable..com/,
Host of Columbus Code Jam http://www.meetup.com/techlifecolumbus/
www.lenjaffe.com http://www.theycomewithcheese.com
Perl Advent Planet http://www.lenjaffe.com/PerlAdventPlanet/ - Advent
Calendars: Perlish and otherwise.