Hello,
i have V8.3.3,
I'm trying to configure the Leave module,
when i try to create a leave type i'm getting this error
From what i understand i need to create an activity type, but the code shown in error message can't by type in the code field in the activity type.
Can you help please
Regards
Did you try to desactivate / reactivate thje module (the type should be created automatically)
Hi
Thanks for your reply, you were right, by disabling/enabling the module the type were created automaticly
Regards
see attach file for all my activity type,
I have only one type with code "leave"
i dot not have any type with the code "leavesyst"
So sure, you need to add (or change existing) to have type with code "LEAVESYST"
Hi,
Don't know how you got there, but it seems only issue is db update
UPDATE type SET code='LEAVESYST" where id=407
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]
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.
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
Hello,
Ok so i tried disabling/enabling the module, no success
The first time i disabled/enabled the module, I was able to create an activity type with LEAVESYST code.
I was also able to create a Leave TYPe
But i was not able to set a RESSOURCE as an EMPLOYEE
got this error again.
so, I disabled/enables again
i was now able to set a RESSOURCE as an EMPLOYEE
but now, i can't create a leave Type
getting this error again
so now, i don't really know what to do more
i tried on to separate instance of projector and i'm always getting stuck at some point with the same error.
Any idea ?
Regards
OK, let's investigate step by step
Do you have Activity Type with code 'LEAVESYST' => it is the leave activity type TYPE
Do you have Activity with the leave activity type ? => it is the Leave activity
What is the project of thses activities ? => it is the Leave Project
When you look at the leave project, you should not see tha allocation of reource part.
This is because this project is check 'isLEaveProject' in the DB.
It you don't get such a project, you must create it.
Moreover, there must be only one project of this kind... delete extra ones.
Hello
I finally got it working, all that was missing is a project with 'isLEaveProject' set to 1 in the DB. I created a new project, set the value to 1. And everything is working now.
Thanks for your help
Regards







