RT search error - http://ticket/Display.html bug in request-tracker

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’ }, },);

  1. 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