Cannot remove old trackers: "This tracker contains issues and can't be deleted"

Hi, I'm doing a large restructuring of trackers and statuses on my database. There are some trackers that I want to remove entirely. For instance, say I wish to remove the tracker "Foo", I get the message:

"This tracker contains issues and can't be deleted."

So far, I have:

Reassigned all issues with the tracker of "Foo" to another tracker.
Unassociated all projects of the "Foo" tracker in the project settings.
Ressurected archived projects and done the same.

There are, however, a great deal of deleted projects that will contain issues with this tracker set. Do these issues/projects still persist in the database, and could be causing the error message to appear? If so, are there any steps above I've missed that could help to solve this issue?

EDIT: Final thought, if I cannot remove the tracker, would removing the tracker "Foo" from all projects effectively hide it anyway?

Replies (3)

RE: Cannot remove old trackers: "This tracker contains issues and can't be deleted" - Added by Mathieu Villemont over 10 years ago

Hi,

I have the same problem.
Did 'Projects' > 'View all issues' > Added a filter 'Tracker is <My Tracker>' but I don't see any issue in the result.
I also deleted archived projects just in case.
Only solution so far is removing the tracer from all my projects.

BR,

Mat

RE: Cannot remove old trackers: "This tracker contains issues and can't be deleted" - Added by Markus Niklasson about 7 years ago

I have the same issue. As far as it seems, the tracker I try to remove is gone from all projects. I cannot find this tracker being used anywhere as suggested above. Yet when trying to delete it "This tracker contains issues and can't be deleted.".

Environment:
Redmine version 3.3.0.stable
Ruby version 2.3.0-p0 (2015-12-25) [x86_64-linux]
Rails version 4.2.6
Environment production
Database adapter Mysql2

Any Redmine developer reading this thread?

RE: Cannot remove old trackers: "This tracker contains issues and can't be deleted" - Added by Yar n over 3 years ago

they read) but issue doensn't seem to be critical)

related threads:
https://www.redmine.org/boards/2/topics/23245
https://www.redmine.org/issues/12521

my solution is to update issues table in mysql(mariadb):

 update issues set tracker_id='YYY' where tracker_id = 'XXX';

where:

YYY - existing tracker_id. i believe 1 will work in most cases.
XXX - tracker_id which should be deleted.
after updating table it will be possible to clean it from UI.

(1-3/3)

Project

General

Profile

Redmine