[rt-users] RT search error - http://ticket/Display.html bug in request-tracker

[Klaus Engelmann]

Dear Friends:


 I finished a brand new RT installation on CentOS 5.2 (version rt3-3.6.5-3.el5).

For some days it worked fine. Now I cannot display the tickets after
doing a simple search (or any kind of search). The links are broken:
(http://ticket/Display.html?id=1).

I am using a Virtual Host configuration at apache2.

 I saw inside the initialdata and I found that everything is right.

I tried to change at initialdata __WebPath__ to $RT::__WebPath__  or
$RT::WebPath and nothing changes.

Thanks, Klaus


Some suggestions followed (without success).

http://wiki.bestpractical.com/view/RepairSearches

http://blog.loftninjas.org/2008/01/25/httpticketdisplayhtml-bug-in-request-tracker/

I finally found instructions here which amounted to:

1) Use mysql (mysql, then 'use rtdb;' or whatever the name of your db
is) to find the id of the search entry: 'select id, Name from
Attributes WHERE Name = 'Search - My Tickets';'
2) Delete this entry: 'DELETE FROM Attributes WHERE id = x;' where x
is the ID from above
3) Put the following in a file named repair-search:

@Attributes = (  { Name => 'Search - My Tickets',    Description =>
'[_1] highest priority tickets I own', # loc    Content     =>    {
Format => "'__id__/TITLE:#', '__Subject__/TITLE:Subject', Priority,
QueueName, ExtendedStatus",      Query   => " Owner =
'__CurrentUser__' AND ( Status = 'new' OR Status = 'open')",
OrderBy => 'Priority',      Order   => 'DESC' },  },);

4) run ' rt-setup-database –action insert –datafile repair-search –dba
rtuser' where rtuser is the name of your rtuser.

Things just worked after this, no need to restart apache or clear the
mason cache or anything.



My initialdata at: /etc/rt3/


@Attributes = (
{ Name => 'Search - My Tickets',
Description => '[_1] highest priority tickets I own', # loc
Content =>
{ Format => "'__id__/TITLE:#', '__Subject__/TITLE:Subject', Priority,
QueueName, ExtendedStatus",
Query => " Owner = '__CurrentUser__' AND ( Status = 'new' OR Status = 'open')",
OrderBy => 'Priority',
Order => 'DESC' },
},
{ Name => 'Search - Unowned Tickets',
Description => '[_1] newest unowned tickets', # loc
Content =>
# 'Take' #loc
{ Format => "'__id__/TITLE:#', '__Subject__/TITLE:Subject', QueueName,
ExtendedStatus, CreatedRelative, '__loc(Take)__/TITLE: ' ",
Query => " Owner = 'Nobody' AND ( Status = 'new' OR Status = 'open')",
OrderBy => 'Created',
Order => 'DESC' },
},
{ Name => 'HomepageSettings',
Description => 'HomepageSettings',
Content =>
{ 'body' => # loc
[ { type => 'system', name => 'My Tickets' },
{ type => 'system', name => 'Unowned Tickets' },
{ type => 'component', name => 'QuickCreate'},
],
'summary' => # loc
[
{ type => 'component', name => 'MyReminders' },
{ type => 'component', name => 'Quicksearch' },
{ type => 'component', name => 'RefreshHomepage' },
]
},
}
);


-- 
Klaus Engelmann
CCNA - CSCO10971632