Errors in log files with search

RT Developers
1

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