Fix duplicate project long names [#396014]

Issue on http://drupal.org/node/321076 should belong to Serbian translation project on http://drupal.org/project/sr (node/43878).

But when you visit 321076 issue, in a breadcrumb "Serbian translation" link is going to http://drupal.org/node/13514 - which is "Access denied" at least for me.

Comments

Comment #1

pivica commented 11 March 2009 at 00:23

OK it seems this is bigger problem then I thought. Same thing happened with the new http://drupal.org/node/397932 issue for "Serbian translation" project.

Issue was OK (referencing to correct project) when it was created, but as soon as I commented issue (http://drupal.org/node/397932#comment-1340690) it started to belong to non existent project on node/13514.

Comment #2

damien tournoud commented 11 March 2009 at 00:39

Title:

Issue is not referencing to correct project anymore

» Fix duplicate project long names

The new version of Project relies on the fact that project short and long names are unique. The uniqueness of long project names is enforced at node creation and edit time, but we still have some duplicates in our database.

In addition to "Serbian translation", which I fixed by renaming the old node to "(Old) Serbian translation", we have:

mysql> SELECT n1.nid, n1.title FROM node n1, node n2 WHERE n1.title = n2.title AND n1.nid != n2.nid AND n1.type = 'project_project' AND n2.type = 'project_project';
+--------+---------------------+
| nid    | title               |
+--------+---------------------+
|   3313 | Title               | 
|  11063 | Title               | 
|  14513 | Persian translation | 
|  14536 | Persian Translation | 
|  26160 | Journal             | 
|  28068 | IMAP Auth           | 
|  52587 | Google earth        | 
|  57296 | Imap Auth           | 
| 120759 | Google Earth        | 
| 193122 | Journal             | 
+--------+---------------------+