Problem creating users

RT Users
1

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

2

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.1On 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

The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston,
San Francisco, Austin, Sydney) Contact training@bestpractical.com for
details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

3

Jon Daley wrote:

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

Hm. I looked some more at this.
The “ObjectID” is an integer, at least in my database.
So, the question is: should it be something else or should the
search-string be constructed differently?

Rainer

4

Jon Daley wrote:

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

Seems that the user needs to be privileged to be added to a group.
Hm. I don’t remember doing that last time I setup RT…

I’d still like to know what that error-message means and if it is
harmless or not.

cheers,
Rainer