Actions
Defect #41975
closed
Uniqueness of Project model fields is not checked sufficiently
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Fixed
Affected version:
Description
In the Project model, :identifier is defined as unique, but it is not guaranteed to be unique in the database.
If transactions are processed in parallel, projects with the same identifier may be created.
Therefore, we propose to add unique-index to the database to guarantee uniqueness.A patch for this purpose is attached.
Files
Updated by Hiroyuki Kano about 1 month ago
- File add_unique_index_to_projects_identifier.patch add_unique_index_to_projects_identifier.patch added
The attached patch was incomplete and will be replaced.
Updated by Go MAEDA about 1 month ago
- Status changed from New to Confirmed
- Target version set to 6.1.0
Thank you for your report.
This issue affects almost all versions of Redmine. However, as a general policy, maintenance releases of Redmine do not include database migrations. Therefore, I set the target version of this issue to 6.1.0, instead of 5.1.6 or 6.0.3.
Updated by Go MAEDA about 1 month ago
- Status changed from Confirmed to Closed
- Assignee set to Go MAEDA
- Resolution set to Fixed
Committed the fix in r23407. Thank you for your contribution.
Actions