Forum

[SOLVED] Unable to ...
 
Notifications
Clear all

[SOLVED] Unable to assigne same person twice to same project with different rates

3 Posts
2 Users
0 Reactions
3,509 Views
(@stephane-pelletier)
Posts: 19
Active Member
Topic starter
 
[#2966]

When I am trying to add a new assignment for same resource to my Project to same project I receive attached error message "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ '99-57' pour la clef 'idx_project_user'

It was not the case in previous versions. I could assign several time the same person to project (with different rates on different period of time for example)


 
Posted : 26 Jan 2016 21H49
(@babynus)
Posts: 14952
Member Admin
 

This index idx_project_user is not an existing index in ProjeQtOr database :sick:
Indexes in "standard" ProjeQtOr are never names with underscores :whistle:
Such index would have bben named affectationProjectUser :S
So you added a new index and this adds a non existant constraint. 👿
In standard ProjeQtOr, it is possible to affect resource seval times on same project 😉


 
Posted : 26 Jan 2016 22H36
(@stephane-pelletier)
Posts: 19
Active Member
Topic starter
 

Thanks for your answer.
Investigation on my side: this index was set by the installation of another product (KAnban) linked with Projeqtor.

Issue os resolved
Sorry for the confusion!


 
Posted : 26 Jan 2016 23H29
Share:

Scroll to Top