Add new Leave period issue

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]
 

Hello, Have you had time to look at this issue?

Hi, 

So simple  

Thanks for the reply, everything is back to normal

Regards