[rt-users] rt-dump-metadata selecting nonextistent column

Len Jaffe lenjaffe at jaffesystems.com
Mon Sep 23 16:33:48 EDT 2013


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 at jaffesystems.com>wrote:

> 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 at bestpractical.com>wrote:
>
>> 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?
>>
>> http://issues.bestpractical.com/Ticket/Display.html?id=22465
>>
>> -kevin
>>
>>
>> --
>> RT Training in New York, October 8th and 9th:
>> http://bestpractical.com/training
>>
>
>
>
> --
> lenjaffe at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130923/d4a0c374/attachment.htm>


More information about the rt-users mailing list