[rt-users] Problem creating users

Rainer Duffner rainer at ultra-secure.de
Wed Apr 20 08:33:47 EDT 2005


Hi,

when I enter the "create user"-page, I get the following:

Apr 20 14:31:29 rt3 postgres[67228]: [1-1] ERROR:  invalid input syntax 
for integer: ""
Apr 20 14:31:29 rt3 RT: DBD::Pg::st execute failed: ERROR:  invalid 
input syntax for integer: ""  (/usr/local/rt3/lib/RT.pm:277)
Apr 20 14:31:29 rt3 RT: RT::Handle=HASH(0xa8e86c8) couldn't execute the 
query 'SELECT  * FROM Principals WHERE LOWER(PrincipalType) = ? AND 
(ObjectId IS NULL OR ObjectId = '')' at 
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 
494.  (/usr/local/rt3/lib/RT.pm:277)
Apr 20 14:31:29 rt3 postgres[67228]: [2-1] ERROR:  invalid input syntax 
for integer: ""
Apr 20 14:31:29 rt3 RT: DBD::Pg::st execute failed: ERROR:  invalid 
input syntax for integer: ""  (/usr/local/rt3/lib/RT.pm:277)
Apr 20 14:31:29 rt3 RT: RT::Handle=HASH(0xa8e86c8) couldn't execute the 
query 'SELECT  * FROM Principals WHERE LOWER(PrincipalType) = ? AND 
(ObjectId IS NULL OR ObjectId = '')' at 
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 
494.  (/usr/local/rt3/lib/RT.pm:277)
Apr 20 14:31:29 rt3 postgres[67228]: [3-1] ERROR:  invalid input syntax 
for integer: ""
Apr 20 14:31:29 rt3 RT: DBD::Pg::st execute failed: ERROR:  invalid 
input syntax for integer: ""  (/usr/local/rt3/lib/RT.pm:277)
Apr 20 14:31:29 rt3 RT: RT::Handle=HASH(0xa8e86c8) couldn't execute the 
query 'SELECT  * FROM Principals WHERE LOWER(PrincipalType) = ? AND 
(ObjectId IS NULL OR ObjectId = '')' at 
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 
494.  (/usr/local/rt3/lib/RT.pm:277)

(rt3.4.1 on FreeBSD 5.4RC2, postgres8).
The user can be created, but I seem to be unable to subsequently move it 
to a group - the user is also "invisible" in that I can't see him in the 
list of users, but I can search for him and then edit him.



Rainer



More information about the rt-users mailing list