[rt-users] Mysql -> Postgres

[Jay R. Ashworth]

On Wed, Apr 13, 2005 at 07:02:14AM -0400, Jon Daley wrote:
> On Tue, 12 Apr 2005, Jay R. Ashworth wrote:
> > On Tue, Apr 12, 2005 at 04:04:18PM -0400, Jon Daley wrote:
> >> On Tue, 12 Apr 2005, Jay R. Ashworth wrote:
> >>> You may have to post the full backtrace, then; this may be something
> >>> different.  Which Pg; did we ask?
> > Hmmm... I thought one came out with that error...
> 
> Ah, there is a bit more in the syslog.

Aha!  (It's a Spenser thing)

I knew there was more somewhere.

> Apr 13 07:01:33 orange RT: DBD::Pg::st execute failed: ERROR:  column 
> "PrincipalType" of relation "principals" does not
> exist at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480. 
> (/usr/share/request-tracker3.4/lib/RT.pm:277)

What version is your SearchBuilder?

> Apr 13 07:01:33 orange RT: DBD::Pg::st execute failed: ERROR:  current 
> transaction is aborted, commands ignored until end
> of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 
> 480. (/usr/share/request-tracker3.4/lib/RT.pm:277)

And for that matter, what's your perl's @INC?

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me