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

Upgrading to 5.4 Error on applying Database Changes #1704

Open jgriffithsuk opened 1 year ago

jgriffithsuk commented 1 year ago

OrangeHRM version

5.0

Environment details

Describe the bug

When upgrading I get these errors

[2023-06-02T10:38:20.483294+00:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'apiv2_performance_kpi' for key 'name' [] [] [2023-06-02T10:38:20.483340+00:00] installer.ERROR: #0 /var/www/html/src/vendor/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/html/src/vendor/doct

To reproduce

No response

Expected behavior

No response

Relevant log output

[2023-06-02T10:38:20.483294+00:00] installer.ERROR: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'apiv2_performance_kpi' for key 'name' [] []
[2023-06-02T10:38:20.483340+00:00] installer.ERROR: #0 /var/www/html/src/vendor/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() #1 /var/www/html/src/vendor/doct
RajithaKumara commented 12 months ago

Hi @jgriffithsuk Any possibility try latest release (5.4 at the moment) It seems we added the performance module (for 5.x) in 5.1 version, can you double-check OrangeHRM version also? We will check this further.

jgriffithsuk commented 12 months ago

Hi

I have tried 5.4 that was the errors I got,

Also 5.1 wouldn’t install

From: Rajitha Kumara @.> Sent: 05 June 2023 05:16 To: orangehrm/orangehrm @.> Cc: Jamie Griffiths @.>; Mention @.> Subject: Re: [orangehrm/orangehrm] Upgrading to 5.4 Error on applying Database Changes (Issue #1704)

This mail originated from OUTSIDE the Oakford corporate network. Treat hyperlinks and attachments in this email with caution.

Hi @jgriffithsukhttps://github.com/jgriffithsuk Any possibility try latest releasehttps://sourceforge.net/projects/orangehrm/files/latest/download (5.4 at the moment) It seems we added the performance module (for 5.x) in 5.1 version, can you double-check OrangeHRM version?

— Reply to this email directly, view it on GitHubhttps://github.com/orangehrm/orangehrm/issues/1704#issuecomment-1576018142, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAIPNJOTSQY6C35T57WXNT3XJVMRRANCNFSM6AAAAAAYYE22SQ. You are receiving this because you were mentioned.Message ID: @.**@.>>

Disclaimer Notice: This email has been sent by Oakford Technology Limited, while we have checked this e-mail and any attachments for viruses, we can not guarantee that they are virus-free. You must therefore take full responsibility for virus checking. This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Oakford Technology Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Oakford Technology Limited. Registered address: Oakford Technology Limited, The Manor House, Potterne, Wiltshire. SN10 5PN. Registered in England and Wales No. 5971519

devambrose commented 12 months ago

also got the same issue while using Fedora distro, i had to switch to Ubuntu

devishke-orange commented 2 months ago

Hi @devambrose, @jgriffithsuk

Were you able to upgrade OrangeHRM afterwards?

jgriffithsuk commented 2 months ago

No we were unable too

To many changes / errors in the Database

From: devishke-orange @.> Sent: 27 March 2024 02:44 To: orangehrm/orangehrm @.> Cc: Jamie Griffiths @.>; Mention @.> Subject: Re: [orangehrm/orangehrm] Upgrading to 5.4 Error on applying Database Changes (Issue #1704)

This mail originated from OUTSIDE the Oakford corporate network. Treat hyperlinks and attachments in this email with caution.

Hi @devambrosehttps://github.com/devambrose, @jgriffithsukhttps://github.com/jgriffithsuk

Were you able to upgrade OrangeHRM afterwards?

— Reply to this email directly, view it on GitHubhttps://github.com/orangehrm/orangehrm/issues/1704#issuecomment-2021816426, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAIPNJPW7Q4CYUFC4ZONVXDY2IW7TAVCNFSM6AAAAAAYYE22SSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMRRHAYTMNBSGY. You are receiving this because you were mentioned.Message ID: @.***>

Disclaimer Notice: This email has been sent by Oakford Technology Limited, while we have checked this e-mail and any attachments for viruses, we can not guarantee that they are virus-free. You must therefore take full responsibility for virus checking. This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Oakford Technology Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Oakford Technology Limited. Registered address: Oakford Technology Limited, The Manor House, Potterne, Wiltshire. SN10 5PN. Registered in England and Wales No. 5971519