[rt-users] SearchBuilder problem?

[Jussi Hamalainen]

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 at domain')OR(LOWER(Users_2.EmailAddress) = 
'user at 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, <GEN8> 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 at theblah.fi ]=-