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

[Niels Bakker]

> On Sep 7, 2004, at 9:09 AM, Susan McConnell wrote:
>>I'm seeing lots of log entries of the form:
>>
>> 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 410.
>> (/usr/local/rt/lib/RT.pm:250)
>> 
>> RT 3.2.1, PostgreSQL 7.4

Seeing them too on RT 3.0.11, psql 7.4


* jesse at bestpractical.com (Jesse Vincent) [Tue 07 Sep 2004, 15:51 CEST]:
> What SQL query is RT generating that does this?

I think it happens when the Basics of a ticket are modified, and the
Time Worked / Time Left fields are not initialised to 0.


	-- Niels.

--