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
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.
[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.
It looks to me like column id is numeric. If I run the sql from psql
id = '' to
id = 0, the statement runs. It does not return any
records, but it runs.
How do I fix this?