search

orangehrm / orangehrm

OrangeHRM is a comprehensive Human Resource Management (HRM) System that captures all the essential functionalities required for any enterprise.
GNU General Public License v3.0
740 stars 538 forks source link

Stuck on 'Request failed with status code 500' #1804

Open flashzander99 opened 3 months ago

flashzander99 commented 3 months ago

OrangeHRM version

5.6

Environment details

Describe the bug

image

To reproduce

No response

Expected behavior

Continue installation

Relevant log output

[2024-02-02T09:25:56.904408+01:00] installer.INFO: {"version":"4.5"} [] []
[2024-02-02T09:25:57.015452+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:25:58.709798+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ryrsecurity_db.ohrm_oauth_client' doesn't exist [] []
[2024-02-02T09:25:58.709967+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1163): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE ohr...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE ohr...') #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(820): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('ALTER TABLE ohr...') #5 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\SchemaHelper.php(110): Doctrine\DBAL\Schema\AbstractSchemaManager->alterTable(Object(Doctrine\DBAL\Schema\TableDiff)) #6 C:\xampp\htdocs\ryrsecurity\installer\Migration\V4_5_0\Migration.php(38): OrangeHRM\Installer\Util\V1\SchemaHelper->addColumn('ohrm_oauth_clie...', 'grant_types', 'string', Array) #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(526): OrangeHRM\Installer\Migration\V4_5_0\Migration->up() #8 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(514): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration('OrangeHRM\\Insta...') #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\Upgrader\Api\MigrationAPI.php(49): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor('4.5') #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #13 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #14 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #15 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #16 {main} [] []
flashzander99 commented 3 months ago 
[2024-02-01T22:20:17.690310+01:00] installer.INFO: Matched route "{route}". {"route":"installer_home","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\HomeController::handle","_route":"installer_home"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/","method":"GET"} []
[2024-02-01T22:20:17.854766+01:00] installer.INFO: Matched route "{route}". {"route":"installer_welcome","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\WelcomeController::handle","_route":"installer_welcome"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/welcome","method":"GET"} []
[2024-02-01T22:20:31.634616+01:00] installer.INFO: Matched route "{route}". {"route":"installer_licence_acceptance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\LicenceAcceptanceController::handle","_route":"installer_licence_acceptance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/licence-acceptance","method":"GET"} []
[2024-02-01T22:20:45.249935+01:00] installer.INFO: Matched route "{route}". {"route":"installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\DatabaseConfigController::handle","_route":"installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/database-config","method":"GET"} []
[2024-02-01T22:20:45.898244+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-01T22:25:57.837220+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"POST"} []
[2024-02-01T22:25:58.100559+01:00] installer.INFO: Matched route "{route}". {"route":"installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\SystemCheckController::handle","_route":"installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/system-check","method":"GET"} []
[2024-02-01T22:25:59.271917+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:26:54.033026+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:26:57.221666+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:28:19.286135+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:29:28.158091+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:34:30.434976+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:41:06.942788+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:41:15.102539+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T22:41:16.258990+01:00] installer.INFO: Matched route "{route}". {"route":"installer_instance_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstanceCreationController::handle","_route":"installer_instance_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/instance-creation","method":"GET"} []
[2024-02-01T22:41:18.040450+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_countries","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CountryAPI::handle","_route":"api_installer_countries"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/countries","method":"GET"} []
[2024-02-01T22:41:18.237755+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_languages","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\LanguageAPI::handle","_route":"api_installer_languages"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/languages","method":"GET"} []
[2024-02-01T22:41:18.411221+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_timezones","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\TimezoneAPI::handle","_route":"api_installer_timezones"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/timezones","method":"GET"} []
[2024-02-01T22:41:18.641057+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"GET"} []
[2024-02-01T22:42:31.554280+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"POST"} []
[2024-02-01T22:42:31.767350+01:00] installer.INFO: Matched route "{route}". {"route":"installer_admin_user_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\AdminUserCreationController::handle","_route":"installer_admin_user_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/admin-user-creation","method":"GET"} []
[2024-02-01T22:42:32.459540+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-01T22:43:23.698205+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"POST"} []
[2024-02-01T22:43:23.886505+01:00] installer.INFO: Matched route "{route}". {"route":"installer_confirmation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\ConfirmationController::handle","_route":"installer_confirmation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/confirmation","method":"GET"} []
[2024-02-01T22:43:24.586392+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-01T22:43:24.802292+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-01T22:43:48.579577+01:00] installer.INFO: Matched route "{route}". {"route":"installer_process","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstallerController::handle","_route":"installer_process"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/process","method":"GET"} []
[2024-02-01T22:43:49.262519+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_start_registration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallerDataRegistrationAPI::handle","_route":"api_installer_start_registration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/send-data/installer-start","method":"POST"} []
[2024-02-01T22:43:49.350327+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallationDatabaseAPI::handle","_route":"api_installer_database"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/database","method":"POST"} []
[2024-02-01T22:43:49.649538+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_pre_migration_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\PreMigrationCheck::handle","_route":"api_installer_pre_migration_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/pre-migration","method":"POST"} []
[2024-02-01T22:43:49.743705+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:43:55.015590+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_versions","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\VersionAPI::handle","_route":"api_installer_versions"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/versions?excludeLatest=false","method":"GET"} []
[2024-02-01T22:43:55.276783+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:43:55.326015+01:00] installer.INFO: {"version":"3.3.3"} [] []
[2024-02-01T22:43:55.394732+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:45:55.766553+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:45:55.786565+01:00] installer.INFO: {"version":"4.0"} [] []
[2024-02-01T22:45:55.847577+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:45:58.105071+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:45:58.137094+01:00] installer.INFO: {"version":"4.1"} [] []
[2024-02-01T22:45:58.209992+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:46:02.661807+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:46:02.693198+01:00] installer.INFO: {"version":"4.1.1"} [] []
[2024-02-01T22:46:02.781969+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:46:07.891673+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:46:07.916944+01:00] installer.INFO: {"version":"4.1.2"} [] []
[2024-02-01T22:46:08.001373+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:46:08.614852+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:46:08.636899+01:00] installer.INFO: {"version":"4.1.2.1"} [] []
[2024-02-01T22:46:08.718767+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:46:09.954860+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:46:09.976909+01:00] installer.INFO: {"version":"4.2"} [] []
[2024-02-01T22:46:10.037100+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:46:11.249349+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ryrsecurity_db`.`ohrm_user_role_data_group`, CONSTRAINT `ohrm_user_role_data_group_ibfk_1` FOREIGN KEY (`user_role_id`) REFERENCES `ohrm_user_role` (`id`) ON DELETE CASCADE) [] []
[2024-02-01T22:46:11.249545+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1055): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'INSERT INTO ohr...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Query\QueryBuilder.php(310): Doctrine\DBAL\Connection->executeQuery('INSERT INTO ohr...', Array, Array) #4 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\DataGroupHelper.php(347): Doctrine\DBAL\Query\QueryBuilder->executeQuery() #5 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\DataGroupHelper.php(172): OrangeHRM\Installer\Util\V1\DataGroupHelper->addDataGroupPermissions('GDPR Employee', 'Admin', true, true, true, true, true) #6 C:\xampp\htdocs\ryrsecurity\installer\Migration\V4_2\Migration.php(59): OrangeHRM\Installer\Util\V1\DataGroupHelper->insertDataGroupPermissions('C:\\xampp\\htdocs...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(526): OrangeHRM\Installer\Migration\V4_2\Migration->up() #8 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(514): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration('OrangeHRM\\Insta...') #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\Upgrader\Api\MigrationAPI.php(49): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor('4.2') #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #13 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #14 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #15 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #16 {main} [] []
[2024-02-01T22:50:33.190616+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-01T22:50:33.249061+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:50:59.904512+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-01T22:50:59.947263+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:50:59.951146+01:00] installer.ERROR: An exception occurred in the driver: SQLSTATE[HY000] [1049] Unknown database 'ryrsecurity_db' [] []
[2024-02-01T22:50:59.951250+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #1 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1757): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(343): Doctrine\DBAL\Connection->convertException(Object(Doctrine\DBAL\Driver\PDO\Exception)) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1531): Doctrine\DBAL\Connection->connect() #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1135): Doctrine\DBAL\Connection->getWrappedConnection() #5 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('DROP DATABASE r...') #6 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(386): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('DROP DATABASE r...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(573): Doctrine\DBAL\Schema\AbstractSchemaManager->dropDatabase('ryrsecurity_DB') #8 C:\xampp\htdocs\ryrsecurity\installer\Controller\Installer\Api\CleanUpInstallAPI.php(36): OrangeHRM\Installer\Util\AppSetupUtility->dropDatabase() #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Installer\Api\CleanUpInstallAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #13 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #14 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #15 {main} [] []
[2024-02-01T22:50:59.957032+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-01T22:51:00.025991+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:51:00.030735+01:00] installer.ERROR: An exception occurred in the driver: SQLSTATE[HY000] [1049] Unknown database 'ryrsecurity_db' [] []
[2024-02-01T22:51:00.030832+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #1 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1757): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(343): Doctrine\DBAL\Connection->convertException(Object(Doctrine\DBAL\Driver\PDO\Exception)) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1531): Doctrine\DBAL\Connection->connect() #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1135): Doctrine\DBAL\Connection->getWrappedConnection() #5 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('DROP DATABASE r...') #6 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(386): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('DROP DATABASE r...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(573): Doctrine\DBAL\Schema\AbstractSchemaManager->dropDatabase('ryrsecurity_DB') #8 C:\xampp\htdocs\ryrsecurity\installer\Controller\Installer\Api\CleanUpInstallAPI.php(36): OrangeHRM\Installer\Util\AppSetupUtility->dropDatabase() #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Installer\Api\CleanUpInstallAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #13 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #14 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #15 {main} [] []
[2024-02-01T22:51:00.036070+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-01T22:51:00.085061+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:51:00.088988+01:00] installer.ERROR: An exception occurred in the driver: SQLSTATE[HY000] [1049] Unknown database 'ryrsecurity_db' [] []
[2024-02-01T22:51:00.089089+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #1 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1757): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(343): Doctrine\DBAL\Connection->convertException(Object(Doctrine\DBAL\Driver\PDO\Exception)) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1531): Doctrine\DBAL\Connection->connect() #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1135): Doctrine\DBAL\Connection->getWrappedConnection() #5 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('DROP DATABASE r...') #6 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(386): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('DROP DATABASE r...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(573): Doctrine\DBAL\Schema\AbstractSchemaManager->dropDatabase('ryrsecurity_DB') #8 C:\xampp\htdocs\ryrsecurity\installer\Controller\Installer\Api\CleanUpInstallAPI.php(36): OrangeHRM\Installer\Util\AppSetupUtility->dropDatabase() #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Installer\Api\CleanUpInstallAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #13 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #14 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #15 {main} [] []
[2024-02-01T22:51:00.094711+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-01T22:51:00.140435+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:51:00.156185+01:00] installer.ERROR: An exception occurred in the driver: SQLSTATE[HY000] [1049] Unknown database 'ryrsecurity_db' [] []
[2024-02-01T22:51:00.156279+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #1 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1757): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(343): Doctrine\DBAL\Connection->convertException(Object(Doctrine\DBAL\Driver\PDO\Exception)) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1531): Doctrine\DBAL\Connection->connect() #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1135): Doctrine\DBAL\Connection->getWrappedConnection() #5 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('DROP DATABASE r...') #6 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(386): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('DROP DATABASE r...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(573): Doctrine\DBAL\Schema\AbstractSchemaManager->dropDatabase('ryrsecurity_DB') #8 C:\xampp\htdocs\ryrsecurity\installer\Controller\Installer\Api\CleanUpInstallAPI.php(36): OrangeHRM\Installer\Util\AppSetupUtility->dropDatabase() #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Installer\Api\CleanUpInstallAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #13 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #14 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #15 {main} [] []
[2024-02-01T22:51:00.160261+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-01T22:51:00.179745+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallationDatabaseAPI::handle","_route":"api_installer_database"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/database","method":"POST"} []
[2024-02-01T22:51:00.237818+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_start_registration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallerDataRegistrationAPI::handle","_route":"api_installer_start_registration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/send-data/installer-start","method":"POST"} []
[2024-02-01T22:51:00.426443+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_pre_migration_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\PreMigrationCheck::handle","_route":"api_installer_pre_migration_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/pre-migration","method":"POST"} []
[2024-02-01T22:51:00.469113+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:51:08.643964+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_versions","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\VersionAPI::handle","_route":"api_installer_versions"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/versions?excludeLatest=false","method":"GET"} []
[2024-02-01T22:51:08.854310+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:51:08.864540+01:00] installer.INFO: {"version":"3.3.3"} [] []
[2024-02-01T22:51:08.898050+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:08.873631+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:53:08.884362+01:00] installer.INFO: {"version":"4.0"} [] []
[2024-02-01T22:53:08.916713+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:10.235175+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:53:10.246940+01:00] installer.INFO: {"version":"4.1"} [] []
[2024-02-01T22:53:10.280457+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:13.484410+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:53:13.494373+01:00] installer.INFO: {"version":"4.1.1"} [] []
[2024-02-01T22:53:13.522740+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:17.238772+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:53:17.248418+01:00] installer.INFO: {"version":"4.1.2"} [] []
[2024-02-01T22:53:17.276579+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:17.864284+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:53:17.877943+01:00] installer.INFO: {"version":"4.1.2.1"} [] []
[2024-02-01T22:53:17.931012+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:18.352685+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T22:53:18.362759+01:00] installer.INFO: {"version":"4.2"} [] []
[2024-02-01T22:53:18.394660+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T22:53:19.352607+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ryrsecurity_db`.`ohrm_user_role_data_group`, CONSTRAINT `ohrm_user_role_data_group_ibfk_1` FOREIGN KEY (`user_role_id`) REFERENCES `ohrm_user_role` (`id`) ON DELETE CASCADE) [] []
[2024-02-01T22:53:19.352872+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1055): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'INSERT INTO ohr...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Query\QueryBuilder.php(310): Doctrine\DBAL\Connection->executeQuery('INSERT INTO ohr...', Array, Array) #4 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\DataGroupHelper.php(347): Doctrine\DBAL\Query\QueryBuilder->executeQuery() #5 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\DataGroupHelper.php(172): OrangeHRM\Installer\Util\V1\DataGroupHelper->addDataGroupPermissions('GDPR Employee', 'Admin', true, true, true, true, true) #6 C:\xampp\htdocs\ryrsecurity\installer\Migration\V4_2\Migration.php(59): OrangeHRM\Installer\Util\V1\DataGroupHelper->insertDataGroupPermissions('C:\\xampp\\htdocs...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(526): OrangeHRM\Installer\Migration\V4_2\Migration->up() #8 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(514): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration('OrangeHRM\\Insta...') #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\Upgrader\Api\MigrationAPI.php(49): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor('4.2') #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #13 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #14 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #15 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #16 {main} [] []
[2024-02-01T23:01:45.236694+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-01T23:01:45.280034+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:02:19.900543+01:00] installer.INFO: Matched route "{route}". {"route":"installer_confirmation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\ConfirmationController::handle","_route":"installer_confirmation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/confirmation","method":"GET"} []
[2024-02-01T23:02:21.342815+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-01T23:02:21.998598+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-01T23:03:15.757457+01:00] installer.INFO: Matched route "{route}". {"route":"installer_admin_user_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\AdminUserCreationController::handle","_route":"installer_admin_user_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/admin-user-creation","method":"GET"} []
[2024-02-01T23:03:16.831800+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-01T23:03:22.908381+01:00] installer.INFO: Matched route "{route}". {"route":"installer_instance_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstanceCreationController::handle","_route":"installer_instance_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/instance-creation","method":"GET"} []
[2024-02-01T23:03:23.644129+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_countries","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CountryAPI::handle","_route":"api_installer_countries"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/countries","method":"GET"} []
[2024-02-01T23:03:23.829837+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_languages","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\LanguageAPI::handle","_route":"api_installer_languages"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/languages","method":"GET"} []
[2024-02-01T23:03:23.996962+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_timezones","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\TimezoneAPI::handle","_route":"api_installer_timezones"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/timezones","method":"GET"} []
[2024-02-01T23:03:24.170302+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"GET"} []
[2024-02-01T23:03:25.760313+01:00] installer.INFO: Matched route "{route}". {"route":"installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\SystemCheckController::handle","_route":"installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/system-check","method":"GET"} []
[2024-02-01T23:03:26.557023+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T23:03:28.939410+01:00] installer.INFO: Matched route "{route}". {"route":"installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\DatabaseConfigController::handle","_route":"installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/database-config","method":"GET"} []
[2024-02-01T23:03:29.623390+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-01T23:07:29.555119+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"POST"} []
[2024-02-01T23:07:29.633867+01:00] installer.ERROR: An exception occurred in the driver: SQLSTATE[HY000] [2002] The requested address is not valid in its context [] []
[2024-02-01T23:07:29.634010+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #1 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1757): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), NULL) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(343): Doctrine\DBAL\Connection->convertException(Object(Doctrine\DBAL\Driver\PDO\Exception)) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(405): Doctrine\DBAL\Connection->connect() #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(367): Doctrine\DBAL\Connection->getDatabasePlatformVersion() #5 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(284): Doctrine\DBAL\Connection->detectDatabasePlatform() #6 C:\xampp\htdocs\ryrsecurity\installer\Util\DatabaseServerConnection.php(44): Doctrine\DBAL\Connection->getDatabasePlatform() #7 C:\xampp\htdocs\ryrsecurity\installer\Util\DatabaseServerConnection.php(53): OrangeHRM\Installer\Util\DatabaseServerConnection->__construct() #8 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(123): OrangeHRM\Installer\Util\DatabaseServerConnection::getConnection() #9 C:\xampp\htdocs\ryrsecurity\installer\Util\Dto\DatabaseConnectionWrapper.php(103): OrangeHRM\Installer\Util\AppSetupUtility->OrangeHRM\Installer\Util\{closure}() #10 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(123): OrangeHRM\Installer\Util\Dto\DatabaseConnectionWrapper::establishConnection(Object(Closure)) #11 C:\xampp\htdocs\ryrsecurity\installer\Controller\Installer\Api\DatabaseConfigAPI.php(76): OrangeHRM\Installer\Util\AppSetupUtility->connectToDatabaseServer() #12 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Installer\Api\DatabaseConfigAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #13 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #14 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #15 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #16 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #17 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #18 {main} [] []
[2024-02-01T23:08:35.217815+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"POST"} []
[2024-02-01T23:08:35.457170+01:00] installer.INFO: Matched route "{route}". {"route":"installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\SystemCheckController::handle","_route":"installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/system-check","method":"GET"} []
[2024-02-01T23:08:36.041396+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-01T23:08:37.659567+01:00] installer.INFO: Matched route "{route}". {"route":"installer_instance_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstanceCreationController::handle","_route":"installer_instance_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/instance-creation","method":"GET"} []
[2024-02-01T23:08:38.219814+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_countries","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CountryAPI::handle","_route":"api_installer_countries"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/countries","method":"GET"} []
[2024-02-01T23:08:38.366721+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_languages","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\LanguageAPI::handle","_route":"api_installer_languages"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/languages","method":"GET"} []
[2024-02-01T23:08:38.508249+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_timezones","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\TimezoneAPI::handle","_route":"api_installer_timezones"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/timezones","method":"GET"} []
[2024-02-01T23:08:38.676207+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"GET"} []
[2024-02-01T23:08:42.933144+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"POST"} []
[2024-02-01T23:08:43.090279+01:00] installer.INFO: Matched route "{route}". {"route":"installer_admin_user_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\AdminUserCreationController::handle","_route":"installer_admin_user_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/admin-user-creation","method":"GET"} []
[2024-02-01T23:08:43.652689+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-01T23:08:55.497229+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"POST"} []
[2024-02-01T23:08:55.687127+01:00] installer.INFO: Matched route "{route}". {"route":"installer_confirmation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\ConfirmationController::handle","_route":"installer_confirmation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/confirmation","method":"GET"} []
[2024-02-01T23:08:56.292884+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-01T23:08:56.448868+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-01T23:08:59.179168+01:00] installer.INFO: Matched route "{route}". {"route":"installer_process","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstallerController::handle","_route":"installer_process"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/process","method":"GET"} []
[2024-02-01T23:08:59.794021+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallationDatabaseAPI::handle","_route":"api_installer_database"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/database","method":"POST"} []
[2024-02-01T23:08:59.845071+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_start_registration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallerDataRegistrationAPI::handle","_route":"api_installer_start_registration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/send-data/installer-start","method":"POST"} []
[2024-02-01T23:09:00.009064+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_pre_migration_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\PreMigrationCheck::handle","_route":"api_installer_pre_migration_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/pre-migration","method":"POST"} []
[2024-02-01T23:09:00.053553+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:09:03.971688+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_versions","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\VersionAPI::handle","_route":"api_installer_versions"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/versions?excludeLatest=false","method":"GET"} []
[2024-02-01T23:09:04.121921+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:09:04.131935+01:00] installer.INFO: {"version":"3.3.3"} [] []
[2024-02-01T23:09:04.163212+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:04.813082+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:11:04.826824+01:00] installer.INFO: {"version":"4.0"} [] []
[2024-02-01T23:11:04.861119+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:08.351494+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:11:08.365835+01:00] installer.INFO: {"version":"4.1"} [] []
[2024-02-01T23:11:08.402477+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:12.114758+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:11:12.128370+01:00] installer.INFO: {"version":"4.1.1"} [] []
[2024-02-01T23:11:12.175686+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:18.358205+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:11:18.369620+01:00] installer.INFO: {"version":"4.1.2"} [] []
[2024-02-01T23:11:18.399235+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:23.693605+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:11:24.007914+01:00] installer.INFO: {"version":"4.1.2.1"} [] []
[2024-02-01T23:11:25.268419+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:26.607459+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-01T23:11:26.637819+01:00] installer.INFO: {"version":"4.2"} [] []
[2024-02-01T23:11:26.733239+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"127.0.0.1 via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-01T23:11:28.536620+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ryrsecurity_db`.`ohrm_user_role_data_group`, CONSTRAINT `ohrm_user_role_data_group_ibfk_1` FOREIGN KEY (`user_role_id`) REFERENCES `ohrm_user_role` (`id`) ON DELETE CASCADE) [] []
[2024-02-01T23:11:28.536816+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1055): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'INSERT INTO ohr...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Query\QueryBuilder.php(310): Doctrine\DBAL\Connection->executeQuery('INSERT INTO ohr...', Array, Array) #4 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\DataGroupHelper.php(347): Doctrine\DBAL\Query\QueryBuilder->executeQuery() #5 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\DataGroupHelper.php(172): OrangeHRM\Installer\Util\V1\DataGroupHelper->addDataGroupPermissions('GDPR Employee', 'Admin', true, true, true, true, true) #6 C:\xampp\htdocs\ryrsecurity\installer\Migration\V4_2\Migration.php(59): OrangeHRM\Installer\Util\V1\DataGroupHelper->insertDataGroupPermissions('C:\\xampp\\htdocs...') #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(526): OrangeHRM\Installer\Migration\V4_2\Migration->up() #8 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(514): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration('OrangeHRM\\Insta...') #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\Upgrader\Api\MigrationAPI.php(49): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor('4.2') #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #13 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #14 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #15 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #16 {main} [] []
[2024-02-02T09:16:09.847645+01:00] installer.INFO: Matched route "{route}". {"route":"installer_home","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\HomeController::handle","_route":"installer_home"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/","method":"GET"} []
[2024-02-02T09:16:10.905663+01:00] installer.INFO: Matched route "{route}". {"route":"installer_welcome","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\WelcomeController::handle","_route":"installer_welcome"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/welcome","method":"GET"} []
[2024-02-02T09:16:25.880653+01:00] installer.INFO: Matched route "{route}". {"route":"installer_licence_acceptance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\LicenceAcceptanceController::handle","_route":"installer_licence_acceptance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/licence-acceptance","method":"GET"} []
[2024-02-02T09:16:32.068774+01:00] installer.INFO: Matched route "{route}". {"route":"installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\DatabaseConfigController::handle","_route":"installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/database-config","method":"GET"} []
[2024-02-02T09:16:33.219244+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-02T09:19:31.296711+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"POST"} []
[2024-02-02T09:19:32.025975+01:00] installer.INFO: Matched route "{route}". {"route":"installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\SystemCheckController::handle","_route":"installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/system-check","method":"GET"} []
[2024-02-02T09:19:33.357406+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_system_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\SystemCheckAPI::handle","_route":"api_installer_system_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/system-check","method":"GET"} []
[2024-02-02T09:19:35.714595+01:00] installer.INFO: Matched route "{route}". {"route":"installer_instance_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstanceCreationController::handle","_route":"installer_instance_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/instance-creation","method":"GET"} []
[2024-02-02T09:19:36.439349+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_countries","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CountryAPI::handle","_route":"api_installer_countries"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/countries","method":"GET"} []
[2024-02-02T09:19:36.821535+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_languages","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\LanguageAPI::handle","_route":"api_installer_languages"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/languages","method":"GET"} []
[2024-02-02T09:19:36.992293+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_timezones","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\TimezoneAPI::handle","_route":"api_installer_timezones"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/timezones","method":"GET"} []
[2024-02-02T09:19:37.250533+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"GET"} []
[2024-02-02T09:19:39.674847+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_instance","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstanceAPI::handle","_route":"api_installer_instance"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/instance","method":"POST"} []
[2024-02-02T09:19:39.835431+01:00] installer.INFO: Matched route "{route}". {"route":"installer_admin_user_creation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\AdminUserCreationController::handle","_route":"installer_admin_user_creation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/admin-user-creation","method":"GET"} []
[2024-02-02T09:19:40.498851+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-02T09:19:51.269398+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"POST"} []
[2024-02-02T09:19:51.449364+01:00] installer.INFO: Matched route "{route}". {"route":"installer_confirmation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\ConfirmationController::handle","_route":"installer_confirmation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/confirmation","method":"GET"} []
[2024-02-02T09:19:52.066257+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-02T09:19:52.237934+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-02T09:19:56.412586+01:00] installer.INFO: Matched route "{route}". {"route":"installer_process","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstallerController::handle","_route":"installer_process"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/process","method":"GET"} []
[2024-02-02T09:19:57.067962+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_start_registration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallerDataRegistrationAPI::handle","_route":"api_installer_start_registration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/send-data/installer-start","method":"POST"} []
[2024-02-02T09:19:57.244713+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallationDatabaseAPI::handle","_route":"api_installer_database"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/database","method":"POST"} []
[2024-02-02T09:19:57.438446+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1007 Can't create database 'ryrsecurity_db'; database exists [] []
[2024-02-02T09:19:57.438553+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1163): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'CREATE DATABASE...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('CREATE DATABASE...') #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(514): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('CREATE DATABASE...') #5 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(110): Doctrine\DBAL\Schema\AbstractSchemaManager->createDatabase('ryrsecurity_DB') #6 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(191): OrangeHRM\Installer\Util\AppSetupUtility->createNewDatabase('ryrsecurity_DB') #7 C:\xampp\htdocs\ryrsecurity\installer\Controller\Installer\Api\InstallationDatabaseAPI.php(36): OrangeHRM\Installer\Util\AppSetupUtility->createDatabase() #8 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Installer\Api\InstallationDatabaseAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #10 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #12 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #13 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #14 {main} [] []
[2024-02-02T09:19:57.571745+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_pre_migration_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\PreMigrationCheck::handle","_route":"api_installer_pre_migration_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/pre-migration","method":"POST"} []
[2024-02-02T09:19:57.741669+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:20:04.293553+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_versions","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\VersionAPI::handle","_route":"api_installer_versions"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/versions?excludeLatest=false","method":"GET"} []
[2024-02-02T09:20:04.572984+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:20:04.622011+01:00] installer.INFO: {"version":"3.3.3"} [] []
[2024-02-02T09:20:04.772123+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:20:04.964886+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'hs_hr_config' already exists [] []
[2024-02-02T09:20:04.964980+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1163): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'create table `h...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\installer\Migration\V3_3_3\Migration.php(42): Doctrine\DBAL\Connection->executeStatement('create table `h...') #4 C:\xampp\htdocs\ryrsecurity\installer\Migration\V3_3_3\Migration.php(27): OrangeHRM\Installer\Migration\V3_3_3\Migration->execQueries('dbscript-1.sql') #5 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(526): OrangeHRM\Installer\Migration\V3_3_3\Migration->up() #6 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(514): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration('OrangeHRM\\Insta...') #7 C:\xampp\htdocs\ryrsecurity\installer\Controller\Upgrader\Api\MigrationAPI.php(49): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor('3.3.3') #8 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #10 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #12 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #13 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #14 {main} [] []
[2024-02-02T09:20:08.868444+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_clean_up_install","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\CleanUpInstallAPI::handle","_route":"api_installer_clean_up_install"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/clean-up-install","method":"POST"} []
[2024-02-02T09:20:08.955002+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:20:41.385024+01:00] installer.INFO: Matched route "{route}". {"route":"installer_confirmation","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\ConfirmationController::handle","_route":"installer_confirmation"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/confirmation","method":"GET"} []
[2024-02-02T09:20:42.006500+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database_config","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\DatabaseConfigAPI::handle","_route":"api_installer_database_config"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/database-config","method":"GET"} []
[2024-02-02T09:20:42.346388+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_admin_user","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\AdminUserAPI::handle","_route":"api_installer_admin_user"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/admin-user","method":"GET"} []
[2024-02-02T09:21:41.095232+01:00] installer.INFO: Matched route "{route}". {"route":"installer_process","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\InstallerController::handle","_route":"installer_process"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/process","method":"GET"} []
[2024-02-02T09:21:44.670572+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_database","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallationDatabaseAPI::handle","_route":"api_installer_database"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/database","method":"POST"} []
[2024-02-02T09:21:49.486540+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_start_registration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\InstallerDataRegistrationAPI::handle","_route":"api_installer_start_registration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/send-data/installer-start","method":"POST"} []
[2024-02-02T09:21:50.516128+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_pre_migration_check","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\PreMigrationCheck::handle","_route":"api_installer_pre_migration_check"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/pre-migration","method":"POST"} []
[2024-02-02T09:21:50.748400+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:22:04.995258+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_versions","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\VersionAPI::handle","_route":"api_installer_versions"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/versions?excludeLatest=false","method":"GET"} []
[2024-02-02T09:22:05.226636+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:22:05.475710+01:00] installer.INFO: {"version":"3.3.3"} [] []
[2024-02-02T09:22:05.580606+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:07.035322+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:07.050046+01:00] installer.INFO: {"version":"4.0"} [] []
[2024-02-02T09:24:07.196699+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:10.329408+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:10.345316+01:00] installer.INFO: {"version":"4.1"} [] []
[2024-02-02T09:24:10.491079+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:13.790791+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:13.800524+01:00] installer.INFO: {"version":"4.1.1"} [] []
[2024-02-02T09:24:13.884238+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:18.412387+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:18.422709+01:00] installer.INFO: {"version":"4.1.2"} [] []
[2024-02-02T09:24:18.522792+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:19.034956+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:19.051432+01:00] installer.INFO: {"version":"4.1.2.1"} [] []
[2024-02-02T09:24:19.337466+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:19.954325+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:19.984563+01:00] installer.INFO: {"version":"4.2"} [] []
[2024-02-02T09:24:20.068099+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:24.185622+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:24.196904+01:00] installer.INFO: {"version":"4.2.0.1"} [] []
[2024-02-02T09:24:24.264797+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:25.011222+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:25.022908+01:00] installer.INFO: {"version":"4.3"} [] []
[2024-02-02T09:24:25.199962+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:27.884688+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:27.896853+01:00] installer.INFO: {"version":"4.3.1"} [] []
[2024-02-02T09:24:28.172551+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:29.276377+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:29.287944+01:00] installer.INFO: {"version":"4.3.2"} [] []
[2024-02-02T09:24:29.683461+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:24:30.886511+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:24:30.896921+01:00] installer.INFO: {"version":"4.3.3"} [] []
[2024-02-02T09:24:31.004389+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:25:06.999020+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:25:07.009392+01:00] installer.INFO: {"version":"4.3.4"} [] []
[2024-02-02T09:25:07.215849+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:25:08.648719+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:25:08.658522+01:00] installer.INFO: {"version":"4.3.5"} [] []
[2024-02-02T09:25:08.744017+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:25:10.071363+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:25:10.095533+01:00] installer.INFO: {"version":"4.4"} [] []
[2024-02-02T09:25:10.626074+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:25:56.894468+01:00] installer.INFO: Matched route "{route}". {"route":"api_installer_migration","route_parameters":{"_controller":"OrangeHRM\\Installer\\Controller\\Installer\\Api\\MigrationAPI::handle","_route":"api_installer_migration"},"request_uri":"http://localhost/ryrsecurity/installer/index.php/installer/api/installation/migration","method":"POST"} []
[2024-02-02T09:25:56.904408+01:00] installer.INFO: {"version":"4.5"} [] []
[2024-02-02T09:25:57.015452+01:00] installer.INFO: Instance details: {"os":{"os":"Windows NT","release_name":"10.0","version_info":"build 19045 (Windows 10)"},"php":{"version":"8.2.12"},"mysql":{"client_version":"mysqlnd 8.2.12","server_version":"10.4.32-MariaDB","conn_type":"localhost via TCP\/IP"},"server":"Apache\/2.4.58 (Win64) OpenSSL\/3.1.3 PHP\/8.2.12","ohrm":{"version":"5.6"}} [] []
[2024-02-02T09:25:58.709798+01:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ryrsecurity_db.ohrm_oauth_client' doesn't exist [] []
[2024-02-02T09:25:58.709967+01:00] installer.ERROR: #0 C:\xampp\htdocs\ryrsecurity\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 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) #2 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Connection.php(1163): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'ALTER TABLE ohr...', Array, Array) #3 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(1204): Doctrine\DBAL\Connection->executeStatement('ALTER TABLE ohr...') #4 C:\xampp\htdocs\ryrsecurity\src\vendor\doctrine\dbal\src\Schema\AbstractSchemaManager.php(820): Doctrine\DBAL\Schema\AbstractSchemaManager->_execSql('ALTER TABLE ohr...') #5 C:\xampp\htdocs\ryrsecurity\installer\Util\V1\SchemaHelper.php(110): Doctrine\DBAL\Schema\AbstractSchemaManager->alterTable(Object(Doctrine\DBAL\Schema\TableDiff)) #6 C:\xampp\htdocs\ryrsecurity\installer\Migration\V4_5_0\Migration.php(38): OrangeHRM\Installer\Util\V1\SchemaHelper->addColumn('ohrm_oauth_clie...', 'grant_types', 'string', Array) #7 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(526): OrangeHRM\Installer\Migration\V4_5_0\Migration->up() #8 C:\xampp\htdocs\ryrsecurity\installer\Util\AppSetupUtility.php(514): OrangeHRM\Installer\Util\AppSetupUtility->_runMigration('OrangeHRM\\Insta...') #9 C:\xampp\htdocs\ryrsecurity\installer\Controller\Upgrader\Api\MigrationAPI.php(49): OrangeHRM\Installer\Util\AppSetupUtility->runMigrationFor('4.5') #10 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerRestController.php(56): OrangeHRM\Installer\Controller\Upgrader\Api\MigrationAPI->handlePost(Object(OrangeHRM\Framework\Http\Request)) #11 C:\xampp\htdocs\ryrsecurity\installer\Controller\AbstractInstallerController.php(84): OrangeHRM\Installer\Controller\AbstractInstallerRestController->execute(Object(OrangeHRM\Framework\Http\Request)) #12 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(152): OrangeHRM\Installer\Controller\AbstractInstallerController->handle(Object(OrangeHRM\Framework\Http\Request)) #13 C:\xampp\htdocs\ryrsecurity\src\vendor\symfony\http-kernel\HttpKernel.php(74): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(OrangeHRM\Framework\Http\Request), 1) #14 C:\xampp\htdocs\ryrsecurity\installer\Framework\HttpKernel.php(243): Symfony\Component\HttpKernel\HttpKernel->handle(Object(OrangeHRM\Framework\Http\Request), 1, true) #15 C:\xampp\htdocs\ryrsecurity\installer\index.php(65): OrangeHRM\Installer\Framework\HttpKernel->handleRequest(Object(OrangeHRM\Framework\Http\Request)) #16 {main} [] []
yashiscool123 commented 3 months ago

I am facing the same issue in v5.6:

Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (ohrm.ohrm_user_role_data_group, CONSTRAINT ohrm_user_role_data_group_ibfk_1 FOREIGN KEY (user_role_id) REFERENCES ohrm_user_role (id) ON DELETE CASCADE) [] []

installer.log

devishke-orange commented 1 month ago

Hi @flashzander99,

I'm sorry for missing your issue. We identified that this is most likely related to the PHP max_execution_time defined be XAMPP. Please see this comment for a solution: https://github.com/orangehrm/orangehrm/issues/1780#issuecomment-1982220098

We have handled this issue in our upcoming 5.6.1. release as well.