Page 1 of 1

Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Mon May 18, 2020 11:20 am
by chris87
Hi,

We have orange HRM installed on a synology nas, after updating OrangeHRM to 4.3.4. users can login but the message "Internal Error Occurred" is displayed, however the admin account is working, admin is able to login and all functionalities seem ok.

When we open the application from the "package center" of the synology NAS, we are still redirected to the upgrade wizard which cannot be completed since it seems we are already on 4.3.4 version after the update.

Image

When any other user except the admin logs in we have message "Internal Error Occurred", after a search in the log file I found the following error is displayed:

[15564] ERROR filter.ExceptionCatcherFilter - Uncaught Exception: Doctrine_Connection_Mysql_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'orangehrm.ohrm_employee_subscription' doesn't exist in /volume1/web/orangehrm/symfony/lib/vendor/lexpress/doctrine1/lib/Doctrine/Connection.php:1090

I checked on mariaDB and the specific table does not exist.
Thank you in advance for your time.

Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Tue May 19, 2020 4:54 am
by rajitha
Hi
Thanks for the detailed reporting. It seems upgrader not successfully executed database migrations. And your instance Admin does not have a employee account. That's why admin user can working. But it's fine. Major issue is `ohrm_employee_subscription` not populated to `orangehrm` database.
Can you verify if you go through below steps also,
Screenshot from 2020-05-19 10-04-33.png
Screenshot from 2020-05-19 10-04-33.png (40.81 KiB) Viewed 1156 times
Screenshot from 2020-05-19 10-05-02.png
Screenshot from 2020-05-19 10-05-02.png (38.5 KiB) Viewed 1156 times
Screenshot from 2020-05-19 10-05-26.png
Screenshot from 2020-05-19 10-05-26.png (61.86 KiB) Viewed 1156 times
It seems from your screenshot, the provider customized OrangeHRM upgrader bit for your ease

Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Tue May 19, 2020 5:52 am
by chris87
Hi rajitha,

Thank you for your prompt response.

I cannot go through the "Version info" step, since in the dropdown only Current OrangeHRM Version 4.3.2 is available, if I leave option "4.3.2" selected and click on proceed i get the following screen:

Step 1: Image

Result: Image

Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Tue May 19, 2020 6:24 am
by rajitha
So you mean you couldn't go to next steps "Database Changes", "Configuration Info", "Completion" while your first upgrade attempt?
Edit:
Did you have backup database before the upgrade?
Can you revert your codebase back to 4.3.2 and see instance working?

Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Tue May 19, 2020 6:44 am
by chris87
No I cannot go to next steps "Database Changes", "Configuration Info", "Completion", neither on my first upgrade attempt.

No I don't have a backup of the database, neither I can revert my codebase back to 4.3.2. The installation was made automatically after clicking on update button on the synology package center console.

Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Tue May 19, 2020 6:57 am
by rajitha
Oops. We are sorry, seems it's out of control. Because the provider bit customized OrangeHRM upgrader. Can you contact the provider and back to us?

Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4

Posted: Tue May 19, 2020 7:32 am
by chris87
ok I will contact synology and keep you posted.
Thank you