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.
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.
Orange HRM user login "Internal Error Occurred" after update to 4.3.4
Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4
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, It seems from your screenshot, the provider customized OrangeHRM upgrader bit for your ease
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, 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
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:
Result:
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:
Result:
Re: Orange HRM user login "Internal Error Occurred" after update to 4.3.4
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?
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
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.
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
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
ok I will contact synology and keep you posted.
Thank you
Thank you