Defect #829

Trackers doubled in New Issue on Issues page

Added by Marc Horowitz over 9 years ago. Updated over 9 years ago.

Status:ClosedStart date:2008-03-11
Priority:NormalDue date:
Assignee:-% Done:

100%

Category:-
Target version:-
Resolution: Affected version:

Description

A picture is worth 1000 words. See attached.

Snapshot_2008-03-11_03-45-50.png - doubled (11.7 KB) Marc Horowitz, 2008-03-11 08:46


Related issues

Related to Redmine - Defect #13059: Custom fields are listed two times in workflow/Fields per... Closed

Associated revisions

Revision 1263
Added by Jean-Philippe Lang over 9 years ago

Trac importer:
  • prevent duplication of associated trackers when the target project already exists (closes #829)
  • warn user if the target project already exists

History

#1 Updated by Jean-Philippe Lang over 9 years ago

Did you use the Trac importer for this project ?

#2 Updated by Marc Horowitz over 9 years ago

Ah, yes I did.

#3 Updated by Jean-Philippe Lang over 9 years 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.

#4 Updated by Marc Horowitz over 9 years 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.

#5 Updated by Jean-Philippe Lang over 9 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Applied in changeset r1263.

Also available in: Atom PDF