Share

Dynamic COMPAS (COMPAS Dynamique®)

Tracker: Bugs

9 Lack of validation of the uniqueness of project code - ID: 1725463
Last Update: Comment added ( osarrat )

Each project has two 'codes': the internal code generated by the system and
the external code used by the users.

When importing a project, the Dynamic COMPAS verify the uniqueness of the
internal code but not the uniqueness of the project name (first champ when
creating the project).

It means that the database can have two projects with the same 'external'
code but with different 'internal' codes.

When accessing the data base the system will automatically use and show the
first information of the database and can even mix the data of both
projects.

Exemple:

Internal codes: 200712339999 and 200712311111
External code: P001

One project can be at the stage T3 and the other at T1 and both data can be
accessed with the same 'external code' P001 and be shown as one unique
project.

Note:
This problem has impacts on the rights assigned to users (import / export)
and can even lock some users.


Karla Levy ( klevy ) - 2007-05-25 10:29

9

Closed

Fixed

Nobody/Anonymous

CDyn Import/Export

None

Public


Comment ( 1 )

Date: 2007-07-04 16:37
Sender: osarratProject Admin


The unique constraint has been added in database on the PRJ_Code column of
the table project. The modification of the database schema has been
reported in the htdocs/install/base.sql file as well as in the function
migrateImportedData() of the htdocs/fonctions/fonctions.php file .

The test of this constraint is now taken into account in the methods
InsertProject and UpdateProject of the htdocs/class/Project.php class
file.
In the htdocs/administration/form_project.php Project creation form, a new
error message has been added in case of an insert error appears (like this
one).
The three htdocs/lang/general_??.php files have been modified to include
this new error message.

SVN revision at this stage : 68


Attached File

No Files Currently Attached

Changes ( 3 )

Field Old Value Date By
status_id Open 2007-07-04 16:37 osarrat
resolution_id None 2007-07-04 16:37 osarrat
close_date - 2007-07-04 16:37 osarrat