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]