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

Discuss Technical Queries about OrangeHRM
Post Reply
chris87
Posts: 4
Joined: Mon May 18, 2020 11:12 am

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

Post by chris87 » Mon May 18, 2020 11:20 am

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.

rajitha
Posts: 19
Joined: Tue Feb 11, 2020 9:54 am

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

Post by rajitha » Tue May 19, 2020 4:54 am

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 184 times
Screenshot from 2020-05-19 10-05-02.png
Screenshot from 2020-05-19 10-05-02.png (38.5 KiB) Viewed 184 times
Screenshot from 2020-05-19 10-05-26.png
Screenshot from 2020-05-19 10-05-26.png (61.86 KiB) Viewed 184 times
It seems from your screenshot, the provider customized OrangeHRM upgrader bit for your ease

chris87
Posts: 4
Joined: Mon May 18, 2020 11:12 am

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

Post by chris87 » Tue May 19, 2020 5:52 am

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

rajitha
Posts: 19
Joined: Tue Feb 11, 2020 9:54 am

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

Post by rajitha » Tue May 19, 2020 6:24 am

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?

chris87
Posts: 4
Joined: Mon May 18, 2020 11:12 am

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

Post by chris87 » Tue May 19, 2020 6:44 am

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.

rajitha
Posts: 19
Joined: Tue Feb 11, 2020 9:54 am

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

Post by rajitha » Tue May 19, 2020 6:57 am

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?

chris87
Posts: 4
Joined: Mon May 18, 2020 11:12 am

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

Post by chris87 » Tue May 19, 2020 7:32 am

ok I will contact synology and keep you posted.
Thank you

Post Reply