[rt-users] RT 3.4.2 installation woes

[Adrian Close]

On Tue, 24 May 2005, Gavin Henry wrote:

> Well done! I am still stuck getting all the modules installed.

I had some trouble with 'make fixdeps' (things apparently not getting 
unpacked correctly), but installing with the CPAN shell ('perl -MCPAN -e 
shell' -> 'install <module>::<submodule>') worked fine.

In other news, the niggly feeling I had about my mod_perl setup got to me 
and I switched to FastCGI.  Now I have more functionality (I can play with
tickets, add users and do searches), but still have the same trouble with 
"left navigation" links like "Tickets", "Tools" and "Preferences".

Does that ring any more bells with anyone?  ;)

I don't have any segfaults in my Apache log - Apache seems quite happy. 
I do have the following database error, which occurs when I go to create a 
new user:

[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: ""
[Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server 
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x953083c) 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.

Postgres doesn't like this query at all if I run it from the monitor - 
complains about the question mark.  I'm not sure what to subsitute...

Thanks,

Adrian Close				email:  adrian.close at hitwise.com
Hitwise					phone:	+61 3 8530 2446
Level 7, 580 St Kilda Road		fax:	+61 3 9529 8907
Melbourne, VIC, 3004, Australia		web:    http://www.hitwise.com/