Project

General

Profile

Actions
Copy link

Defect #41975

closed

Uniqueness of Project model fields is not checked sufficiently

Added by Hiroyuki Kano 7 days ago. Updated 6 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Go MAEDA
Category:
Projects
Target version:
6.1.0
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

Download all files
add_unique_index_to_projects_identifier.patch (0 Bytes) add_unique_index_to_projects_identifier.patch Hiroyuki Kano, 2024-12-13 01:46
add_unique_index_to_projects_identifier.patch (460 Bytes) add_unique_index_to_projects_identifier.patch Patch after replacement Hiroyuki Kano, 2024-12-13 01:55
Actions
Copy link
 #1

Updated by Hiroyuki Kano 7 days ago

The attached patch was incomplete and will be replaced.

Actions
Copy link
 #2

Updated by Go MAEDA 7 days 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.

Actions
Copy link
 #3

Updated by Go MAEDA 6 days 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
Copy link

Also available in: Atom PDF