search

gamonoid / icehrm

Manage your employees easily with a robust and efficient Human Resource Management System
http://icehrm.com
Other
565 stars 367 forks source link

"Uncaught mysqli_sql_exception: Table 'icehrm.systemdata' doesn't exist" error logged in log file after installation of icehrm using xampp #325

Closed namanpatilps closed 1 year ago

namanpatilps commented 1 year ago

05-Jan-2023 12:51:02 Asia/Colombo] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'icehrm.systemdata' doesn't exist in C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\MyORM\MySqlActiveRecord.php:163 Stack trace:

0 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\MyORM\MySqlActiveRecord.php(163): mysqli->prepare('SELECT * FROM S...')

1 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\Model\BaseModel.php(317): MyORM\MySqlActiveRecord->Load('name = ?', Array)

2 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\Classes\BaseService.php(2030): Model\BaseModel->Load('name = ?', Array)

3 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\Connection\Common\ConnectionService.php(98): Classes\BaseService->getSystemData('sysDataTime')

4 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\Connection\Admin\Api\ConnectionAdminManager.php(14): Connection\Common\ConnectionService->dispatchInstallationRequest()

5 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\server.includes.inc.php(150): Connection\Admin\Api\ConnectionAdminManager->initialize()

6 C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\login.php(5): include('C:\xampp2\htdoc...')

7 C:\xampp2\htdocs\icehrm_v32.1.0.OS\app\login.php(3): include('C:\xampp2\htdoc...')

8 {main}

thrown in C:\xampp2\htdocs\icehrm_v32.1.0.OS\core\src\MyORM\MySqlActiveRecord.php on line 163

KyleRitchie20 commented 1 year ago

I have the same issue...Doesnt make 100% sense to me:

[24-Jan-2023 23:37:49 Asia/Colombo] PHP Fatal error:  Uncaught mysqli_sql_exception: Table '{user}_iceh616.SystemData' doesn't exist in /home/{user}/public_html/{website}/core/src/MyORM/MySqlActiveRecord.php:163
Stack trace:
#0 /home/{user}/public_html/{website}/core/src/MyORM/MySqlActiveRecord.php(163): mysqli->prepare()
#1 /home/{user}/public_html/{website}/core/src/Model/BaseModel.php(317): MyORM\MySqlActiveRecord->Load()
#2 /home/{user}/public_html/{website}/core/src/Classes/BaseService.php(2030): Model\BaseModel->Load()
#3 /home/{user}/public_html/{website}/core/src/Connection/Common/ConnectionService.php(98): Classes\BaseService->getSystemData()
#4 /home/{user}/public_html/{website}/core/src/Connection/Admin/Api/ConnectionAdminManager.php(14): Connection\Common\ConnectionService->dispatchInstallationRequest()
#5 /home/{user}/public_html/{website}/core/server.includes.inc.php(150): Connection\Admin\Api\ConnectionAdminManager->initialize()
#6 /home/{user}/public_html/{website}/core/login.php(5): include('/home/{user}/...')
#7 /home/{user}/public_html/{website}/app/login.php(3): include('/home/{user}/...')
#8 {main}
  thrown in /home/{user}/public_html/{website}/core/src/MyORM/MySqlActiveRecord.php on line 163
ddave001 commented 1 year ago

This issue is fixed with v32.4.0. Earlier icehrm wasn't supporting mysql 8.0.32.