View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Add new Leave period issue - ProjeQtOr
 
 

Add new Leave period issue

More
02 May 2022 16:46 #1 by karl.binet
Hi,
V9.5.2,

Employee have been adding Leave period for a while with no issue.  But now, some employee can't add new leave period, some can.  They are all set the same way.

Let's take this example, i'm having this error when i want to add a leave period for an employee,

 

but if we look at the employee leaves rights earned, there is a quantity of 500 left, so it should work

 

Any ideas why it's not working

Also, i'm having these errors in the logs, but i'm not realy sure when the are generated or i don't know if it is related

Thanks for your help

Regards

2022-05-02 07:31:06.835 ***** ERROR ***** [V9.5.2] Impossible to load class EmployeeLeaveEarnedType<br/>  => Not found in ../model/custom/EmployeeLeaveEarnedType.php <br/>  => Not found in ../model/EmployeeLeaveEarnedType.php <br/>  => Not found in ../model/persistence/EmployeeLeaveEarnedType.php <br/>
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/projeqtor.php at line 1776 calling debugPrintTraceStack()
2022-05-02 07:31:06.835
DEBUG
 => calling projeqtorAutoload()
2022-05-02 07:31:06.835
DEBUG
 => calling spl_autoload_call()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/model/persistence/SqlList.php at line 55 calling class_exists()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/html.php at line 494 calling SqlList:getList()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/displayQuickFilterList.php at line 217 calling htmlDrawOptionForReference()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/selectStoredFilter.php at line 100 calling include()
2022-05-02 07:31:06.835 ***** ERROR ***** [V9.5.2] Impossible to load class EmployeeLeaveEarnedType<br/>  => Not found in ../model/custom/EmployeeLeaveEarnedType.php <br/>  => Not found in ../model/EmployeeLeaveEarnedType.php <br/>  => Not found in ../model/persistence/EmployeeLeaveEarnedType.php <br/>
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/projeqtor.php at line 1776 calling debugPrintTraceStack()
2022-05-02 07:31:06.835
DEBUG
 => calling projeqtorAutoload()
2022-05-02 07:31:06.835
DEBUG
 => calling spl_autoload_call()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/model/persistence/SqlList.php at line 68 calling property_exists()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/model/persistence/SqlList.php at line 364 calling SqlList:getListNotTranslated()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/html.php at line 526 calling SqlList:getFieldFromId()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/displayQuickFilterList.php at line 217 calling htmlDrawOptionForReference()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/selectStoredFilter.php at line 100 calling include()
2022-05-02 07:31:06.835 ***** ERROR ***** [V9.5.2] Impossible to load class EmployeeLeaveEarnedType<br/>  => Not found in ../model/custom/EmployeeLeaveEarnedType.php <br/>  => Not found in ../model/EmployeeLeaveEarnedType.php <br/>  => Not found in ../model/persistence/EmployeeLeaveEarnedType.php <br/>
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/projeqtor.php at line 1776 calling debugPrintTraceStack()
2022-05-02 07:31:06.835
DEBUG
 => calling projeqtorAutoload()
2022-05-02 07:31:06.835
DEBUG
 => calling spl_autoload_call()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/model/persistence/SqlList.php at line 86 calling property_exists()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/model/persistence/SqlList.php at line 68 calling SqlList:getDefaultDisplayCol()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/model/persistence/SqlList.php at line 364 calling SqlList:getListNotTranslated()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/html.php at line 526 calling SqlList:getFieldFromId()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/displayQuickFilterList.php at line 217 calling htmlDrawOptionForReference()
2022-05-02 07:31:06.835
DEBUG
 => /var/www/html/tool/selectStoredFilter.php at line 100 calling include()
2022-05-02 07:31:06.836
DEBUG
WARNING : SqlList::fetchList() called for not valid class 'EmployeeLeaveEarnedType'

2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND idLeaveType=3 AND idle=0 AND id<>11104' at line 1
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    For query : select * from employeeleaveearned where idEmployee =  AND idLeaveType=3 AND idle=0 AND id<>11104
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    Strack trace :
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2871]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:563]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #2 EmployeeLeaveEarnedMain->getEmployeeLeaveEarnedForAnEmployee called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:400]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #3 EmployeeLeaveEarnedMain->control called at [/var/www/html/model/persistence/SqlElement.php:1215]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #4 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:831]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #5 SqlElement->save called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:373]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #6 EmployeeLeaveEarnedMain->save called at [/var/www/html/tool/saveObject.php:114]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND idLeaveType = 3 AND quantity IS NULL AND idle=0 AND id <>11104' at line 1
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    For query : select * from employeeleaveearned where idEmployee =  AND idLeaveType = 3 AND quantity IS NULL AND idle=0 AND id <>11104
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    Strack trace :
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2871]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:439]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #2 EmployeeLeaveEarnedMain->control called at [/var/www/html/model/persistence/SqlElement.php:1215]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #3 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:831]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #4 SqlElement->save called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:373]
2022-05-02 08:19:11.427 ***** ERROR ***** [V9.5.2]    #5 EmployeeLeaveEarnedMain->save called at [/var/www/html/tool/saveObject.php:114]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND idLeaveType = 3 AND quantity IS NOT NULL AND idle=0 AND id <>11104' at line 1
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    For query : select * from employeeleaveearned where idEmployee =  AND idLeaveType = 3 AND quantity IS NOT NULL AND idle=0 AND id <>11104
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    Strack trace :
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2871]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:450]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #2 EmployeeLeaveEarnedMain->control called at [/var/www/html/model/persistence/SqlElement.php:1215]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #3 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:831]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #4 SqlElement->save called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:373]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #5 EmployeeLeaveEarnedMain->save called at [/var/www/html/tool/saveObject.php:114]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND idle=0 AND ( (startDate>='2022-06-01' AND NOT (startDate>'2023-05-31')) OR (' at line 1
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    For query : select * from employeeleaveearned where idLeaveType=3 AND idEmployee= AND idle=0 AND ( (startDate>='2022-06-01' AND NOT (startDate>'2023-05-31')) OR (endDate<='2023-05-31' AND NOT (endDate<'2022-06-01')) OR (startDate<='2022-06-01' AND endDate>='2023-05-31') )AND id <>11104
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    Strack trace :
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:2871]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:465]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #2 EmployeeLeaveEarnedMain->control called at [/var/www/html/model/persistence/SqlElement.php:1215]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #3 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:831]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #4 SqlElement->save called at [/var/www/html/model/EmployeeLeaveEarnedMain.php:373]
2022-05-02 08:19:11.428 ***** ERROR ***** [V9.5.2]    #5 EmployeeLeaveEarnedMain->save called at [/var/www/html/tool/saveObject.php:114]
 
Attachments:

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

More
16 May 2022 19:04 #2 by karl.binet
Hello, Have you had time to look at this issue?

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

More
17 May 2022 19:51 #3 by babynus
Replied by babynus on topic Add new Leave period issue
Hi,

From your screenshot I can see the leave period start on 2022-06-01.
So employee cannot plan leave period on 2022-05-03

Babynus
Administrator of ProjeQtOr web site

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

More
17 May 2022 21:32 #4 by karl.binet
Hi, 

So simple :-) 

Thanks for the reply, everything is back to normal

Regards

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

Moderators: babynusprotion
Time to create page: 0.043 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.