[rt-users] Mysql -> Postgres

[Jon Daley]

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.


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)

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)

---

Apr 13 07:01:33 orange RT: RT::Handle=HASH(0x8cf9f7c) couldn't execute the 
query 'INSERT INTO Principals
("PrincipalType", "Disabled", "ObjectId") VALUES (?, ?, ?)' at 
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
(/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: Use of uninitialized value in hash element at 
/usr/share/perl5/Cache/Simple/TimedExpiry.pm
line 84.  (/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: RT::Handle=HASH(0x8cf9f7c) couldn't execute the 
query 'UPDATE "Principals" SET "ObjectId"=?
WHERE "id"=? ' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494. 
(/usr/share/request-tracker3.4/lib/RT.pm:277)

Apr 13 07:01:33 orange RT: Couldn't create a Principal on new user create. 
Strange things are afoot at the circle K
(/usr/share/request-tracker3.4/lib/RT/User_Overlay.pm:479)