View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Unable to assigne same person twice to same project with different rates - ProjeQtOr
 
 

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

More
26 Jan 2016 19:49 #1 by stephane.pelletier
Unable to assigne same person twice to same project with different rates was created by stephane.pelletier
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)

Attachments:

Please Log in or Create an account to join the conversation.

More
26 Jan 2016 20:36 #2 by babynus
Replied by babynus on topic Unable to assigne same person twice to same project with different rates
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. :evil:
In standard ProjeQtOr, it is possible to affect resource seval times on same project ;)
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
26 Jan 2016 21:29 #3 by stephane.pelletier
Replied by stephane.pelletier on topic Unable to assigne same person twice to same project with different rates
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!

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.037 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form