[rt-users] Problem creating users

[Jon Daley]

 	I had this same error.  My wife thought it was when she was 
trying to search for all users (the search function changed from 3.0 to 
3.4, and so it is harder to search for all users -- unless someone knows 
of a better way than, "email address contains @" or other such things)

 	But, anyway, the users were successfully created, and everything 
seems fine now.  And the users could be added to privileged groups.

 	I believe by default users are "invisible" as they are 
unprivileged, and the default search only shows privileged users.

Postgres 7.4.7
RT 3.4.1

On Wed, 20 Apr 2005, Rainer Duffner wrote:
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> RT Administrator and Developer training is coming to your town soon! (Boston, 
> San Francisco, Austin, Sydney) Contact training at bestpractical.com for 
> details.
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>