[rt-users] ERROR: invalid input syntax for integer

[Alex S Moore]

Running RT 3.4.2 on Solaris with perl 5.8.7 and postgre 8.0.3. 
DBIx::SearchBuilder is version 1.27.

I am still fairly new to RT and have most things working like I want.  I 
added a custom field for software release number with values like 1.0.0, 
1.1.0.  I did not see any restrictions on the data type in the 
documentation.

After adding a custom field value to a ticket, I get the following error 
in the rt log.  The ticket does display the value that I entered.

---
[Wed Aug  3 14:58:41 2005] [warning]: DBD::Pg::st execute failed: ERROR: 
  invalid input syntax for integer: "" at 
/opt/csw/share/perl/csw/DBIx/SearchBuilder/Handle.pm line 480.
  (/opt/csw/rt3/lib/RT.pm:277)
[Wed Aug  3 14:58:42 2005] [warning]: RT::Handle=HASH(0xf848d0) couldn't 
execute the query 'SELECT  * FROM ObjectCustomFieldValues WHERE (id IS 
NULL OR id = '')' at 
/opt/csw/share/perl/csw/DBIx/SearchBuilder/Handle.pm line 494.
  (/opt/csw/rt3/lib/RT.pm:277)
---

It looks to me like column id is numeric.  If I run the sql from psql 
and `id = ''` to `id = 0`, the statement runs.  It does not return any 
records, but it runs.

How do I fix this?

Thanks, Alex