https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292008-03-11T16:08:54ZRedmineRedmine - Defect #829: Trackers doubled in New Issue on Issues pagehttps://www.redmine.org/issues/829?journal_id=17532008-03-11T16:08:54ZJean-Philippe Langjp_lang@yahoo.fr
<ul></ul><p>Did you use the Trac importer for this project ?</p> Redmine - Defect #829: Trackers doubled in New Issue on Issues pagehttps://www.redmine.org/issues/829?journal_id=17542008-03-11T18:56:34ZMarc Horowitz
<ul></ul><p>Ah, yes I did.</p> Redmine - Defect #829: Trackers doubled in New Issue on Issues pagehttps://www.redmine.org/issues/829?journal_id=17562008-03-11T19:35:46ZJean-Philippe Langjp_lang@yahoo.fr
<ul></ul><p>That's a bug in the Trac importer. I'll fix it to prevent this problem in the future.<br />Go to projects settings, uncheck the trackers, save, re-check them and re-save. You should no longer see duplicates.</p> Redmine - Defect #829: Trackers doubled in New Issue on Issues pagehttps://www.redmine.org/issues/829?journal_id=17582008-03-11T19:37:03ZMarc Horowitz
<ul></ul><p>I think that was enough of a hint. The database looks like this:</p>
<p>redmine=# select * from projects_trackers;<br /> project_id | tracker_id <br />------------+------------<br /> 1 | 1<br /> 1 | 2<br /> 1 | 1<br /> 1 | 2<br />(4 rows)</p>
<p>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.</p> Redmine - Defect #829: Trackers doubled in New Issue on Issues pagehttps://www.redmine.org/issues/829?journal_id=18522008-03-16T15:17:31ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>Applied in changeset <a class="changeset" title="Trac importer: * prevent duplication of associated trackers when the target project already exist..." href="https://www.redmine.org/projects/redmine/repository/svn/revisions/1263">r1263</a>.</p>