OrangeHRM version

5.3

Environment details

• OrangeHRM source: Github Releases
• Platform: Ubuntu 22.04
• PHP version: 8.1
• Database and version: 10.6.11-MariaDB-0ubuntu0.22.04.1
• Web server: Apache
• Browser: Firefox

Describe the bug

When installing OrangeHRM it gives me an error when Applying Database changes, saying Request failed with status code 500. For more details check the error log in /src/log/installer.log file

Upon checking the log file I have found the following
[2023-02-15T12:33:46.035837+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'php_version' at row 1 [] [] [2023-02-15T12:33:46.035985+01:00] installer.ERROR: #0 /var/www/hrm/src/vendor/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/hrm/src/vendor/doctrine/dbal/src/Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException() #2 /var/www/hrm/src/vendor/doctrine/dbal/src/Connection.php(1163): Doctrine\DBAL\Connection->convertExceptionDuringQuery() #3 /var/www/hrm/src/vendor/doctrine/dbal/src/Query/QueryBuilder.php(324): Doctrine\DBAL\Connection->executeStatement() #4 /var/www/hrm/installer/Util/MigrationHelper.php(95): Doctrine\DBAL\Query\QueryBuilder->executeStatement() #5 /var/www/hrm/installer/Util/AppSetupUtility.php(523): OrangeHRM\Installer\Util\MigrationHelper->logMigrationStarted() #6 /var/www/hrm/installer/Util/AppSetupUtility.php(512): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration() #7 /var/www/hrm/installer/Controller/Upgrader/Api/MigrationAPI.php(50): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor() #8 /var/www/hrm/installer/Controller/AbstractInstallerRestController.php(57): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost() #9 /var/www/hrm/installer/Controller/AbstractInstallerController.php(85): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute() #10 /var/www/hrm/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle() #11 /var/www/hrm/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #12 /var/www/hrm/installer/Framework/HttpKernel.php(244): Symfony\Component\HttpKernel\HttpKernel->handle() #13 /var/www/hrm/installer/index.php(66): OrangeHRM\Installer\Framework\HttpKernel->handleRequest() #14 {main} [] []

To reproduce

Not Sure

Expected behavior

Installation should not halt

Relevant log output

[2023-02-15T12:33:46.035837+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'php_version' at row 1 [] []
[2023-02-15T12:33:46.035985+01:00] installer.ERROR: #0 /var/www/hrm/src/vendor/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/hrm/src/vendor/doctrine/dbal/src/Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException() #2 /var/www/hrm/src/vendor/doctrine/dbal/src/Connection.php(1163): Doctrine\DBAL\Connection->convertExceptionDuringQuery() #3 /var/www/hrm/src/vendor/doctrine/dbal/src/Query/QueryBuilder.php(324): Doctrine\DBAL\Connection->executeStatement() #4 /var/www/hrm/installer/Util/MigrationHelper.php(95): Doctrine\DBAL\Query\QueryBuilder->executeStatement() #5 /var/www/hrm/installer/Util/AppSetupUtility.php(523): OrangeHRM\Installer\Util\MigrationHelper->logMigrationStarted() #6 /var/www/hrm/installer/Util/AppSetupUtility.php(512): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration() #7 /var/www/hrm/installer/Controller/Upgrader/Api/MigrationAPI.php(50): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor() #8 /var/www/hrm/installer/Controller/AbstractInstallerRestController.php(57): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost() #9 /var/www/hrm/installer/Controller/AbstractInstallerController.php(85): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute() #10 /var/www/hrm/src/vendor/symfony/http-kernel/HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle() #11 /var/www/hrm/src/vendor/symfony/http-kernel/HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #12 /var/www/hrm/installer/Framework/HttpKernel.php(244): Symfony\Component\HttpKernel\HttpKernel->handle() #13 /var/www/hrm/installer/index.php(66): OrangeHRM\Installer\Framework\HttpKernel->handleRequest() #14 {main} [] []