search

sapplica / sentrifugo

Sentrifugo is a FREE and powerful Human Resource Management System (HRMS) that can be easily configured to meet your organizational needs.
http://www.sentrifugo.com/
GNU General Public License v3.0
484 stars 426 forks source link

error 500 when trying to create / update leave #318

Closed aMozejko1 closed 4 years ago

aMozejko1 commented 4 years ago

when a user updates or creates a leave request the page does not complete properly.

when creating a leave request there is a call to https://mydomain.com/index.php/leaverequest/saveleaverequestdetails/format/json which returns a 500 error. once the page is refreshed the leave request appears in the calendar however there no notification emails are sent.

when updating a leave request there is a call to https://mydomain.com/index.php/leaverequest/updateleavedetails/format/html which also returns a 500 error. once the page is refreshed the leave request disappears from the calendar however there no notification emails are sent.

sentrifugo version is 3.2, php version 7.1, nginx version 1.14, ubuntu version 18.04.

aMozejko1 commented 4 years ago

for anyone seeing the same thing this was caused by the non-existence of the 'main_leaverequest_history' DB table.

the 'hrms.sql' which sets up db tables toggles between the myisam and innodb engines. if your mysql is configured with only one of these engines (as is the case when using azure mysql) then tables with the wrong engine are silently not created.