Defect #829
Trackers doubled in New Issue on Issues page
| Status: | Closed | Start: | 2008-03-11 | |
| Priority: | Normal | Due date: | ||
| Assigned to: | - | % Done: | 100% |
|
| Category: | - | |||
| Target version: | - | |||
| Affected version: | Resolution: | |||
Description
A picture is worth 1000 words. See attached.
Associated revisions
- prevent duplication of associated trackers when the target project already exists (closes
#829) - warn user if the target project already exists
History
Updated by Jean-Philippe Lang 303 days ago
That's a bug in the Trac importer. I'll fix it to prevent this problem in the future.
Go to projects settings, uncheck the trackers, save, re-check them and re-save. You should no longer see duplicates.
Updated by Marc Horowitz 303 days ago
I think that was enough of a hint. The database looks like this:
redmine=# select * from projects_trackers;
project_id | tracker_id
------------+------------
1 | 1
1 | 2
1 | 1
1 | 2
(4 rows)
Deleting the duplicate rows solved the problem. Perhaps this table should have a unique constraint across both columns? I believe this would remove the need for the existing index on project_id, as well.
Updated by Jean-Philippe Lang 298 days ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Applied in changeset r1263.