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
746 stars 537 forks source link

Database Error #1785

Closed sohailk784 closed 2 months ago

sohailk784 commented 4 months ago

OrangeHRM version

5.5

Environment details

Database

Describe the bug

I am getting below error while installing the OrangeHRM on my server. We tried to off the foreign key checks but still no luck.

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'ohrm_job_interview_ibfk_1' of table 'ohrm_job_int erview'

To reproduce

No response

Expected behavior

No response

Relevant log output

No response

devishke-orange commented 4 months ago

Hi @sohailk784

This is a known issue. Please see https://github.com/orangehrm/orangehrm/issues/1731#issuecomment-1727583099

devishke-orange commented 4 months ago

Hi @sohailk784,

This issue is fixed in OrangeHRM 5.6: https://github.com/orangehrm/orangehrm/releases/tag/v5.6

devishke-orange commented 2 months ago

I'm closing this since the issue was fixed.