[rt-users] Oddity within the RT database

[Ruslan Zakirov]

Have you tried to delete them in ui?

Use rt-attributes viewer that is shipped with rt and installed into sbin
directory. Decide which one you need and just delete an attribute. As far
as I recall dashboards handle this properly.

Ruslan from phone.
19.03.2012 20:54 пользователь "Tim Cutts" <tjrc at sanger.ac.uk> написал:
>
> It looks as though at some point, probably a long time ago during an
upgrade, that I accidentally ran part of the upgrade database task twice,
and as a result some of the standard portlet searches are duplicated:
>
> select id, Name from Attributes where ObjectType = 'RT::System' order by
Name
>
> returns:
>
> id,Name
> 1470,BrandedSubjectTag
> 494,HomepageSettings
> 497,HomepageSettings
> 18200,QueueCacheNeedsUpdate
> 498,"Search - Bookmarked Tickets"
> 499,"Search - My Requested Tickets"
> 492,"Search - My Tickets"
> 495,"Search - My Tickets"
> 493,"Search - Unowned Tickets"
> 496,"Search - Unowned Tickets"
>
> Obviously in the RT-at-a-glance page, and in dashboard content pages,
these searches appear twice, which is a bit messy, if harmless.
>
> If I wanted to clean this up, obviously I could remove one of the
duplicated entries in each case, but then I presumably need to also
sanitise where they are referenced from.  Are the references going to be
embedded in blobs in other Attributes?  I can see some of them are
referenced in the Name of some other Attributes (for example
Pref-RT::Attribute-492 and likewise 493 and 496) which presumably could be
fairly easily fixed with a simple update.  But I imagine these things are
referenced within saved home page settings and dashboards somewhere, which
could be messy to fix.
>
> Any thoughts?
>
> Tim
>
> --
>  The Wellcome Trust Sanger Institute is operated by Genome Research
>  Limited, a charity registered in England with number 1021457 and a
>  company registered in England with number 2742969, whose registered
>  office is 215 Euston Road, London, NW1 2BE.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120320/88f88f9c/attachment.htm>