[rt-users] Postgres "invalid input syntax for integer" errors

[Matt Jennings]

RT 3.2.1 / Perl 5.8.3-5 / DBIx::SearchBuilder 1.10 / Postgres 7.4.1

I've noticed SQL errors appearing in syslog during most updating
operations; although everything appears to work.

I also get the invalid input syntax for integer error.

Sep  8 12:21:21 RT: DBD::Pg::st execute failed: ERROR:  invalid input
syntax for integer: "" at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478. 
(/opt/rt3/lib/RT.pm:250)
Sep  8 12:21:21 RT: RT::Handle=HASH(0x99031f4) couldn't execute the
query 'UPDATE Queues SET InitialPriority=? WHERE id=? ' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492. 
(/opt/rt3/lib/RT.pm:250)
Sep  8 12:21:21 RT: DBD::Pg::st execute failed: ERROR:  invalid input
syntax for integer: "" at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478. 
(/opt/rt3/lib/RT.pm:250)
Sep  8 12:21:21 RT: RT::Handle=HASH(0x99031f4) couldn't execute the
query 'UPDATE Queues SET FinalPriority=? WHERE id=? ' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492. 
(/opt/rt3/lib/RT.pm:250)

The queue in question has only the name, description and "requests
should be due in" fields set. After creation the "Priority starts at"
and "Priority moves forward" fields are set to zero, presumably the
default.

I've looked through the mailing list archives and STW but can't seem to
find any resolution for this issue nor am I familiar enough with the RT
and related code, or Perl, to look into this.


Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040908/4ddd5477/attachment.htm>