View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Error while saving details to workelement table for a Ticket workflow - Page 3 - ProjeQtOr
 
 

[SOLVED] Error while saving details to workelement table for a Ticket workflow

More
16 Aug 2016 11:37 #13 by babynus
Replied by babynus on topic Error while saving details to workelement table for a Ticket workflow
Can you reproduce this issue on Demo ?
If so, please describe how to acces the test case so that I can reproduce.
If not, is it possible to get a dump of your database ? (if required, we can provide Anonymized Backup plugin)
Babynus
Administrator of ProjeQtOr web site

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

More
16 Aug 2016 12:08 #14 by sagar.toshniwal
Replied by sagar.toshniwal on topic Error while saving details to workelement table for a Ticket workflow
I am attaching full SQL export of my database.
I have taken following steps, in version V5.4.4:
1) Values of "Statuses"
2) Values of "Profiles"
3) Values of "Users", "Contacts", "Resources"
4) Created new "Workflow"
5) Change ticket type for "Incident" to the newly created workflow
6) Access rights to "Forms"
7) Access rights to "Project dependent data"
8) Create new "Project" of T&M type
9) Add "Affectation" to the project -- add newly created user/ resource/ contact

Also, attaching screenshot of what I get. You can see "Initiated" status as next one. This is not the status that should come next, as per the workflow.
I am an Eagle. On a mission to help those who want to help themselves...
Attachments:

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

More
16 Aug 2016 16:49 #15 by babynus
Replied by babynus on topic Error while saving details to workelement table for a Ticket workflow
Thanls for sharing the database.
This helped me found the issue.
It appears that new status is created with flag isCopyStatus set to 1, and this is an error that lead sto your issue, and will also generate issues on copy.

To fix your problem, execute script :
UPDATE `${prefix}status` set isCopyStatus=0 where id!=14;

Issue is recorder as Ticket #2271 and will be fixed with a patch.
Babynus
Administrator of ProjeQtOr web site

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

More
17 Aug 2016 08:11 #16 by sagar.toshniwal
Replied by sagar.toshniwal on topic Error while saving details to workelement table for a Ticket workflow
Thanks Babynus. This has resolved the issue. Now my workflow is functioning as desired.
I am an Eagle. On a mission to help those who want to help themselves...

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

Moderators: babynus, protion
Time to create page: 0.040 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