ProjeQtOr free project management software - Leave type creation error - Page 2 - ProjeQtOr
 

Leave type creation error

More
30 Mar 2020 00:04 - 30 Mar 2020 00:04 #7 by babynus
Replied by babynus on topic Leave type creation error
So sure, you need to add (or change existing) to have type with code "LEAVESYST"

Babynus
Administrator of ProjeQtOr web site
Last edit: 30 Mar 2020 00:04 by babynus.

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

More
01 Apr 2020 13:39 #8 by karl.binet
Hi,

tks for your reply, yes i would love to do that, but here what happens when i try to change the code from "LEAVE" to "LEAVESYST"



Regards
Attachments:

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

More
04 Apr 2020 18:50 #9 by babynus
Replied by babynus on topic Leave type creation error
Hi,

Don't know how you got there, but it seems only issue is db update
UPDATE type SET code='LEAVESYST" where id=407

Babynus
Administrator of ProjeQtOr web site

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

More
06 Apr 2020 16:38 - 06 Apr 2020 20:54 #10 by karl.binet
Hi,

Thanks for your reply,

I did update the DB, i now have the code LEAVESYST for my activity type,

Now when i try again to create a new Leave Type, i'm getting this error

Regards



here is the inscription in the log file

2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'idProject' doesn't have a default value
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] For query : insert into assignment ( refType , refId , idResource , uniqueResource , idle , isNotImputable , optional , isResourceTeam , surbooked , hasSupport ) values ('Activity', '7778', '27', '0', '0', '0', '0', '0', '0', '0')
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] Strack trace :
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:1295]
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] #1 SqlElement->insertSqlElement called at [/var/www/html/model/persistence/SqlElement.php:1077]
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] #2 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:883]
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] #3 SqlElement->saveForced called at [/var/www/html/model/Assignment.php:386]
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] #4 Assignment->simpleSave called at [/var/www/html/model/LeaveTypeMain.php:346]
2020-04-06 10:31:36.504 ***** ERROR ***** [V8.3.3] #5 LeaveTypeMain->save called at [/var/www/html/tool/saveObject.php:78]
Attachments:
Last edit: 06 Apr 2020 20:54 by karl.binet.

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

More
08 Apr 2020 08:41 #11 by babynus
Replied by babynus on topic Leave type creation error
You don't have the expected Leave project.
Difficult to manage all of this manually.

I suggest to : disable HR module
Then re-enable it and be sure all is "automaticelly" created.

You may try with new instance of back-up to be sure.

Babynus
Administrator of ProjeQtOr web site

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

More
15 Apr 2020 15:44 #12 by karl.binet
Hello,

Thanks for your reply, i can disable/enable again the module, but already tried it when you ask me to do it at the beginning of this post.

Will try it again and let you know

regards

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

Moderators: babynusprotion
Time to create page: 0.043 seconds