It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Global delete labels

In our large confluence instance we want to delete strange/unwanted labels which have been created by unknown occasion/reason but to delete then manually from the pages is a tedieus task.

Is this prossible with sql, directly on the database or other plugin/option?

4 answers

1 accepted

1 vote
Answer accepted
Robert Chang Atlassian Team Dec 18, 2012

Hi Arthur,

Because of the foreign key, you'd need to remove the relevant entries form the content_label table first. For example:

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

Then follow that with:

DELETE FROM label WHERE name = 'labelname';

Please keep in mind this has not been tested, so be sure you back up your database first, or better yet, test this on a dev instance.

Thanks Robbert, this is realy something for a plugin to support Maintenance on larger installations. Do you now this on some backlog?

Hi Arthur,

Labels are stored in the LABEL table, so you could use SQL to remove the labels that way. The other option would be to use the Command Line Interface plugin as this will also allow you to manage and delete the labels stored in your Confluence instance.

All the best,
John

Hi,

You could do it with Label Manager for Confluence plug in.https://marketplace.atlassian.com/plugins/com.kostebekteknoloji.plugins.confluence.confluence-label-manager
You could search for similar labels in a space and then merge them into one standard label.
You could also do bulk operations like appending , adding and removing labels.
Documentation is here:http://www.confluence.kostebekteknoloji.com/display/PLUG/Label+Manager+for+Confluence
Regards,

When i try to delete a label is complains:

#1451 - Cannot delete or update a parent row: a foreign key constraint fails ("confluencedb"."CONTENT_LABEL", CONSTRAINT "FKF0E7436E27072AEF" FOREIGN KEY ("LABELID") REFERENCES "LABEL" ("LABELID"))

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Apr 18, 2019 in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

361 views 0 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you