Unexpected Error Occurred - In multiple parts of the application

BDAthans commented 2 months ago

OrangeHRM version

5.6

Environment details

OrangeHRM source: SourceForge
Platform: Linux PhoenixNJ03 4.18.0-513.9.1.el8_9.x86_64 #1 SMP Sat Dec 2 05:23:44 EST 2023 x86_64 x86_64 x86_64 GNU/Linux
PHP version: 8.0
Database and version: mysql, Ver 8.0.35 for Linux on x86_64 (MySQL Community Server - GPL)
Web server: team-ap.net
Browser: Firefox, Microsoft Edge and Chrome

Describe the bug

Currently, a bunch of admin users are getting errors when trying to do multiple things on our deployment of OrangeHRM. We get the same generic error message, "Error - Unexpected Error Occurred", on the site for many actions.

When trying to add a new user under 'User Management'.
When going to Time > Attendance > Employee Records > select an employee.
When clicking on 'Leave' on left side bar.
When opening Time > Timesheet > Employee timesheet.

OrangeHRM - Unexpected Error Occurred

To reproduce

Go to User management, click on the add button, enter in employee information and click Save, and the error displays in the bottom left. Also when filling out the password, the error displays as well.
When trying to pull attendance records, the same error displayed.
And when clicking on 'Leave' on the left sidebar, the same error shows, but the page loads.

Expected behavior

Not to receive these error messages.

Relevant log output

[2024-02-26T21:54:45.026972+00:00] orangehrm.CRITICAL: Cannot assign null to property OrangeHRM\Authentication\Service\PasswordStrengthService::$minLength of type int [] [] [2024-02-26T21:54:45.028285+00:00] orangehrm.CRITICAL: #0 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(159): OrangeHRM\Authentication\Service\PasswordStrengthService->getMinLength() #1 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(275): OrangeHRM\Authentication\Service\PasswordStrengthService->checkMinPasswordLength('BlackTurtle27!') #2 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/PublicApi/PasswordStrengthValidationAPI.php(104): OrangeHRM\Authentication\Service\PasswordStrengthService->checkPasswordPolicies(Object(OrangeHRM\Authentication\Dto\UserCredential), 3) #3 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(112): OrangeHRM\Authentication\PublicApi\PasswordStrengthValidationAPI->create() #4 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(149): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handlePostRequest(Object(OrangeHRM\Core\Api\V2\Request)) #5 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #6 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #7 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #8 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #9 {main} [] [] [2024-02-26T21:55:05.092453+00:00] orangehrm.CRITICAL: Cannot assign null to property OrangeHRM\Authentication\Service\PasswordStrengthService::$minLength of type int [] [] [2024-02-26T21:55:05.093592+00:00] orangehrm.CRITICAL: #0 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(159): OrangeHRM\Authentication\Service\PasswordStrengthService->getMinLength() #1 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(275): OrangeHRM\Authentication\Service\PasswordStrengthService->checkMinPasswordLength('JW') #2 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/PublicApi/PasswordStrengthValidationAPI.php(104): OrangeHRM\Authentication\Service\PasswordStrengthService->checkPasswordPolicies(Object(OrangeHRM\Authentication\Dto\UserCredential), 0) #3 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(112): OrangeHRM\Authentication\PublicApi\PasswordStrengthValidationAPI->create() #4 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(149): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handlePostRequest(Object(OrangeHRM\Core\Api\V2\Request)) #5 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #6 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #7 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #8 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #9 {main} [] [] [2024-02-26T21:55:07.294077+00:00] orangehrm.CRITICAL: Cannot assign null to property OrangeHRM\Authentication\Service\PasswordStrengthService::$minLength of type int [] [] [2024-02-26T21:55:07.295569+00:00] orangehrm.CRITICAL: #0 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(159): OrangeHRM\Authentication\Service\PasswordStrengthService->getMinLength() #1 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(275): OrangeHRM\Authentication\Service\PasswordStrengthService->checkMinPasswordLength('JWPass') #2 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/PublicApi/PasswordStrengthValidationAPI.php(104): OrangeHRM\Authentication\Service\PasswordStrengthService->checkPasswordPolicies(Object(OrangeHRM\Authentication\Dto\UserCredential), 1) #3 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(112): OrangeHRM\Authentication\PublicApi\PasswordStrengthValidationAPI->create() #4 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(149): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handlePostRequest(Object(OrangeHRM\Core\Api\V2\Request)) #5 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #6 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #7 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #8 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #9 {main} [] [] [2024-02-26T21:55:09.128120+00:00] orangehrm.CRITICAL: Cannot assign null to property OrangeHRM\Authentication\Service\PasswordStrengthService::$minLength of type int [] [] [2024-02-26T21:55:09.129880+00:00] orangehrm.CRITICAL: #0 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(159): OrangeHRM\Authentication\Service\PasswordStrengthService->getMinLength() #1 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(275): OrangeHRM\Authentication\Service\PasswordStrengthService->checkMinPasswordLength('JWPass12345') #2 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/PublicApi/PasswordStrengthValidationAPI.php(104): OrangeHRM\Authentication\Service\PasswordStrengthService->checkPasswordPolicies(Object(OrangeHRM\Authentication\Dto\UserCredential), 3) #3 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(112): OrangeHRM\Authentication\PublicApi\PasswordStrengthValidationAPI->create() #4 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(149): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handlePostRequest(Object(OrangeHRM\Core\Api\V2\Request)) #5 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #6 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #7 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #8 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #9 {main} [] [] [2024-02-26T21:55:09.363171+00:00] orangehrm.CRITICAL: Cannot assign null to property OrangeHRM\Authentication\Service\PasswordStrengthService::$minLength of type int [] [] [2024-02-26T21:55:09.364389+00:00] orangehrm.CRITICAL: #0 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(159): OrangeHRM\Authentication\Service\PasswordStrengthService->getMinLength() #1 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(275): OrangeHRM\Authentication\Service\PasswordStrengthService->checkMinPasswordLength('JWPass12345!') #2 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/PublicApi/PasswordStrengthValidationAPI.php(104): OrangeHRM\Authentication\Service\PasswordStrengthService->checkPasswordPolicies(Object(OrangeHRM\Authentication\Dto\UserCredential), 3) #3 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(112): OrangeHRM\Authentication\PublicApi\PasswordStrengthValidationAPI->create() #4 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(149): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handlePostRequest(Object(OrangeHRM\Core\Api\V2\Request)) #5 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #6 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #7 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #8 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #9 {main} [] [] [2024-02-26T21:55:19.038923+00:00] orangehrm.CRITICAL: Cannot assign null to property OrangeHRM\Authentication\Service\PasswordStrengthService::$minLength of type int [] [] [2024-02-26T21:55:19.040830+00:00] orangehrm.CRITICAL: #0 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(159): OrangeHRM\Authentication\Service\PasswordStrengthService->getMinLength() #1 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/Service/PasswordStrengthService.php(275): OrangeHRM\Authentication\Service\PasswordStrengthService->checkMinPasswordLength('JWPass12345!') #2 /home/teamapne/public_html/src/plugins/orangehrmAuthenticationPlugin/PublicApi/PasswordStrengthValidationAPI.php(104): OrangeHRM\Authentication\Service\PasswordStrengthService->checkPasswordPolicies(Object(OrangeHRM\Authentication\Dto\UserCredential), 3) #3 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(112): OrangeHRM\Authentication\PublicApi\PasswordStrengthValidationAPI->create() #4 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(149): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handlePostRequest(Object(OrangeHRM\Core\Api\V2\Request)) #5 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #6 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #7 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #8 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #9 {main} [] [] [2024-02-26T21:55:38.205535+00:00] orangehrm.ERROR: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'teamapneorangehrm.o1.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [] [] [2024-02-26T21:55:38.208958+00:00] orangehrm.ERROR: #0 /home/teamapne/public_html/src/vendor/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #1 /home/teamapne/public_html/src/vendor/doctrine/dbal/src/Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /home/teamapne/publichtml/src/vendor/doctrine/dbal/src/Connection.php(1055): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT o0.id A...', Array, Array) #3 /home/teamapne/publichtml/src/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery('SELECT o0.id A...', Array, Array, NULL) #4 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #5 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1188): Doctrine\ORM\Query->_doExecute() #6 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1142): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, NULL) #7 /home/teamapne/public_html/src/plugins/orangehrmLeavePlugin/Dao/LeaveRequestDao.php(535): Doctrine\ORM\AbstractQuery->execute() #8 /home/teamapne/public_html/src/plugins/orangehrmLeavePlugin/Api/EmployeeLeaveRequestAPI.php(246): OrangeHRM\Leave\Dao\LeaveRequestDao->getLeaveRequests(Object(OrangeHRM\Leave\Dto\LeaveRequestSearchFilterParams)) #9 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(76): OrangeHRM\Leave\Api\EmployeeLeaveRequestAPI->getAll() #10 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(145): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handleGetRequest(Object(OrangeHRM\Core\Api\V2\Request)) #11 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #12 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #13 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #14 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #15 {main} [] [] [2024-02-26T21:57:47.551856+00:00] orangehrm.ERROR: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'teamapneorangehrm.o0.punch_in_user_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [] [] [2024-02-26T21:57:47.553177+00:00] orangehrm.ERROR: #0 /home/teamapne/public_html/src/vendor/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #1 /home/teamapne/public_html/src/vendor/doctrine/dbal/src/Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 /home/teamapne/public_html/src/vendor/doctrine/dbal/src/Connection.php(1055): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT SUM(ROUN...', Array, Array) #3 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(ROUN...', Array, Array, NULL) #4 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #5 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1188): Doctrine\ORM\Query->_doExecute() #6 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1142): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, NULL) #7 /home/teamapne/public_html/src/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(930): Doctrine\ORM\AbstractQuery->execute(NULL, NULL) #8 /home/teamapne/public_html/src/plugins/orangehrmAttendancePlugin/Dao/AttendanceDao.php(529): Doctrine\ORM\AbstractQuery->getOneOrNullResult() #9 /home/teamapne/public_html/src/plugins/orangehrmAttendancePlugin/Api/EmployeeAttendanceRecordAPI.php(190): OrangeHRM\Attendance\Dao\AttendanceDao->getTotalWorkingTime(Object(OrangeHRM\Attendance\Dto\AttendanceRecordSearchFilterParams)) #10 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/GenericRestController.php(76): OrangeHRM\Attendance\Api\EmployeeAttendanceRecordAPI->getAll() #11 /home/teamapne/public_html/src/plugins/orangehrmCorePlugin/Controller/Rest/V2/AbstractRestController.php(145): OrangeHRM\Core\Controller\Rest\V2\GenericRestController->handleGetRequest(Object(OrangeHRM\Core\Api\V2\Request)) #12 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Core\Controller\Rest\V2\AbstractRestController->handle(Object(OrangeHRM\Framework\Http\Request)) #13 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #14 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #15 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #16 {main} [] [] [2024-02-26T21:57:48.587236+00:00] orangehrm.ERROR: [] [] [2024-02-26T21:57:48.588214+00:00] orangehrm.ERROR: #0 /home/teamapne/public_html/src/vendor/symfony/event-dispatcher/EventDispatcher.php(230): OrangeHRM\Authentication\Subscriber\AuthenticationSubscriber->onControllerEvent(Object(Symfony\Component\HttpKernel\Event\ControllerEvent), 'kernel.controll...', Object(OrangeHRM\Framework\Event\EventDispatcher)) #1 /home/teamapne/public_html/src/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'kernel.controll...', Object(Symfony\Component\HttpKernel\Event\ControllerEvent)) #2 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(140): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Symfony\Component\HttpKernel\Event\ControllerEvent), 'kernel.controll...') #3 /home/teamapne/public_html/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #4 /home/teamapne/public_html/src/lib/framework/Framework.php(156): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #5 /home/teamapne/public_html/web/index.php(41): OrangeHRM\Framework\Framework->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #6 {main} [] []

BDAthans commented 2 months ago

Our installer.log and a fresh orangehrm.log after recreating these errors:

installer.log orangehrm.log

devishke-orange commented 2 months ago

Hi @BDAthans,

You have created the issue for OrangeHRM 5.6 but from your installer.log it seems you are using OrangeHRM 5.3. Can you confirm the version?

BDAthans commented 2 months ago

Confirmed we are using OrangeHRM 5.6. We have previously upgraded from 5.3 to 5.6

BDAthans commented 2 months ago

Hi @BDAthans,

You have created the issue for OrangeHRM 5.6 but from your installer.log it seems you are using OrangeHRM 5.3. Can you confirm the version?

We have previously upgraded from 5.3 to 5.6. But I confirmed we are running OrangeHRM v5.6

devishke-orange commented 2 months ago

Hi @BDAthans,

Sorry for the late response. Please try disabling ONLY_FULL_GROUP_BY in your database's sql_mode. Check this reference: https://github.com/orangehrm/orangehrm/issues/1582#issuecomment-1367186952

We are currently working on fixing this issue: https://github.com/orangehrm/orangehrm/pull/1818

BDAthans commented 2 months ago

Hi @BDAthans,

Sorry for the late response. Please try disabling ONLY_FULL_GROUP_BY in your database's sql_mode. Check this reference: #1582 (comment)

We are currently working on fixing this issue: #1818

Okay I will look into this and report back if that's helped to resolve any of our issues.

BDAthans commented 2 months ago

@devishke-orange Ran the query SELECT @@sql_mode; and it returned:

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

We have multiple databases on this server, so it's hard to know if running the query referenced in the link is going to cause issues.

devishke-orange commented 2 months ago

Hi @BDAthans ,

We have resolved this issue in our upcoming 5.6.1 release. See here: https://github.com/orangehrm/orangehrm/pull/1818

The release will be out soon.

BDAthans commented 1 month ago

Okay I will wait f or the new upcoming release and hopefully that will resolve the issues I've reported.

devishke-orange commented 1 month ago

Hi @BDAthans

OrangeHRM 5.6.1 is now released https://github.com/orangehrm/orangehrm/releases/tag/v5.6.1

BDAthans commented 1 month ago

@devishke-orange the following issues have been resolved by the latest update:

Time > Attendance > Employee Records > select an employee.
Clicking on 'Leave' on left side bar.
Opening Time > Timesheet > Employee timesheet.

The following issues are still present and generated the same red error bubble message:

When trying to add a new user under 'User Management'. NEW 5. When going to PIM > add employee > entering employee info and login credentials.

devishke-orange commented 1 month ago

Hi @BDAthans

Could you try upgrading your OrangeHRM 5.3 database to 5.6.1? We recently identified some silent failures occurring during installations/upgrades on Windows environments. We attempted to fix some of these issues in the latest version.

Please let me know if that's what you did. I'm assuming you upgraded your 5.6 installation to 5.6.1.

BDAthans commented 1 month ago

@devishke-orange

We are running the latest OrangeHRM v5.6.1 but the issues I last mentioned above are still prevalent. Does the database not get the necessary changes upon upgrading the installation of OrangeHRM?

We are not running OrangeHRM in a windows environment, and we run it on a server in a linux environment.

orangehrm / orangehrm