Hello!
I’m getting errors like this:
[Mon Jul 18 10:16:48 2005] [error] [client xxx.xxx.xxx.xx] FastCGI:
server “/appl/rt2/rt2/bin/mason_handler.fcgi” stderr:
RT::Handle=HASH(0x8bdf5bc) couldn’t execute the query ‘SELECT
DISTINCT main.* FROM (Tickets main LEFT JOIN Users Users_2 ON (
Users_2.id = Watchers_1.Owner)) , Watchers Watchers_1 WHERE
((LOWER(Watchers_1.Email) =
‘user@domain’)OR(LOWER(Users_2.EmailAddress) =
‘user@domain’)) AND ((Watchers_1.Scope = ‘Ticket’)) AND
((Watchers_1.Type = ‘Requestor’)) AND ((main.EffectiveId = main.id))
AND ((main.Status = ‘new’)OR(main.Status = ‘open’)) AND ((main.id =
Watchers_1.Value)) ORDER BY main.Priority DESC LIMIT 25’ at
/appl/rt2/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line
494, line 580., referer: https://rt.domain/rt2/
If I run that SQL command in psql I get this error:
ERROR: Relation “watchers_1” does not exist
This is RT 2.0.17 (yes, I know I really should upgrade…) and
PostgreSQL 7.2.3 (yes, I should upgrade that too).
I googled a bit and found that this has something to do with
DBIx::SearchBuilder. I’m currently running 1.27. Is there a fix
available?
-=[ Count Zero / TBH - Jussi H�m�l�inen - email count@theblah.fi ]=-