[Rt-devel] Errors in log files with search

[Tina Schade]

Hello,

sometimes when I search for tickets I get the result "0 Tickets found". 
Today I installed the release 3.0.11. I have SearchBuilder 0.99 (tried to 
install 1.0.1, but I get Error with make test, that "Want" isn´t found, there 
is a "use Want", but I don´t know from where I can get this), Apache 1.3, 
modperl 1.27 and use a Postgresdatabase.

In the logfiles I found the following:

in rt - log file:
[warning]: DBIx::SearchBuilder error:ERROR:  Relation "tickets" does not exist
        Query String is SELECT count(main.id) FROM Tickets main   WHERE 
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
((main.Type = 'ticket')) AND ( ( (main.Status = 'open') ) AND ( (main.Owner = 
'52') ) )  (/opt/rt3/lib/RT.pm:247)

[warning]: DBD::Pg::st fetchrow_array failed: no statement executing at 
/usr/lib/perl5/site_perl/5.8.1/DBIx/SearchBuilder.pm line 248.
 (/opt/rt3/lib/RT.pm:247)


in postgres log file:
 LOG:  query: SELECT count(main.id) FROM Tickets main   WHERE 
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
((main.Type = 'ticket')) AND ( ( (main.Owner = '58') ) AND ( (main.Status = 
'resolved') ) )
ERROR:  Relation "tickets" does not exist
LOG:  query: SELECT DISTINCT main.* FROM Users main , Principals Principals_1, 
CachedGroupMembers CachedGroupMembers_2  WHERE ((CachedGroupMembers_2.GroupId 
= '4')) AND ((Principals_1.Disabled = '0')) AND ((Principals_1.PrincipalType 
= 'User')) AND ((Principals_1.id = CachedGroupMembers_2.MemberId)) AND 
((main.id = Principals_1.id)) ORDER BY main.Name ASC

when I reload the page, then it´s all right. And postgres logs:

LOG:  query: SELECT count(main.id) FROM Tickets main   WHERE 
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
((main.Type = 'ticket')) AND ( ( (main.Owner = '58') ) AND ( (main.Status = 
'resolved') ) )
LOG:  query: SELECT main.* FROM Tickets main   WHERE ((main.EffectiveId = 
main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( 
( (main.Owner = '58') ) AND ( (main.Status = 'resolved') ) ) ORDER BY 
main.Created DESC LIMIT 100

Does someone else have this Problem? If so, is there a solution for this 
problem?

Thanks much,

Tina