Obsolete labels showing up in Labels list

Lotta Lilja

I have problems with old, deleted, labels still showing up in the labels lists. The labels list show both current and obsolete labels, i. e. not currently used on any page in the space. Now these label names show up in the list anyway, which will be confusing to my users, since the obsolete and current labels sometimes have very similar names.

I am using Brikit Targeted Search to get Label groups, but Brikit tells me this is a Confluence labels functionality problem. 

So how do I get the labels list macro to show only the lables actually existing on the current pages?

 

Igor M_

Hey,

You can try clearing the plugins cache by following steps in:  How to clear confluence plugins cache

Then try rebuilding the index from scratch by following steps in: How to rebuild the content indexes from scratch

If you still facing issues after that, you can try DB edit, to remove any orphaned labels.

(!) Please test changes first in a test environment before applying to Production.
(!) Always take a backup of your database, confluence home and install directories.

You can run below query to check if any page and which is still using the label in question:

SELECT * FROM CONTENT
WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT_LABEL
WHERE LABELID IN (SELECT LABELID FROM LABEL
WHERE NAME='[label name]' ));

If no pages show up or pages that do show up don't actually have said label, you can use bellow queries to remove label from DB

Remove the relevant entries form the content_label table first:

DELETE FROM content_label WHERE labelid IN (SELECT labelid FROM label WHERE name = '[label name]');

Then follow that with:

DELETE FROM label WHERE name = '[label name]';

After above edits, make sure you rebuild your index from scratch and clear plug-ins cache, as per first steps in KB.

Hope this helps

Regards,

Igor