DesComm Posted August 29, 2020 Report Share Posted August 29, 2020 Where is the code located that updates a pilots status when "retired" Two issues. 1. When a pilot is inactive it is getting set as "on Leave" 3 in the database. Should be set as "inactive" 1 in the database. 2. Where are the definitions located for retired status currently 0 = Active 1 = Inactive 2 = Locked 3 = On Leave Thanks hope every is staying healthy Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted August 29, 2020 Administrators Report Share Posted August 29, 2020 phpVMS version? PHP version? MySQL/MariaDB version? Shared hosting or VPN? Quote Link to comment Share on other sites More sharing options...
DesComm Posted August 29, 2020 Author Report Share Posted August 29, 2020 (edited) phpVMS version? - simpilot 5.5.2 PHP version? 5.6.40 MySQL/MariaDB version? MySQL 5.7.31 Shared hosting or VPN? - Dedicated - Ubuntu 16.04.7 LTS Edited August 30, 2020 by DesComm version added Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted August 30, 2020 Administrators Report Share Posted August 30, 2020 What MySQL version? Quote Link to comment Share on other sites More sharing options...
DesComm Posted August 30, 2020 Author Report Share Posted August 30, 2020 MySQL - 5.7.31 Quote Link to comment Share on other sites More sharing options...
web541 Posted August 30, 2020 Report Share Posted August 30, 2020 1 - If you've got auto-retire set to true in your local.config.php then it routes (either from cron or every 24hours) to this function: https://github.com/DavidJClark/phpvms_5.5.x/blob/master/core/common/PilotData.class.php#L712 then ultimately to this function: https://github.com/DavidJClark/phpvms_5.5.x/blob/master/core/common/PilotData.class.php#L353 2 - Check your local.config.php file first for PILOT_STATUS_TYPES, otherwise they're defined here: https://github.com/DavidJClark/phpvms_5.5.x/blob/master/core/app.config.php#L466 Can you check your console and inspect the <select name="retired"> when you go to edit a pilot (the dropdown for their status) and check that the value of each <option> matches up with what it should be. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted August 30, 2020 Administrators Report Share Posted August 30, 2020 Check what web541 suggests above, then...... Since you have MySQL 5.7 - check to see if strict mode is on or off. If on, set it to off. Several reports of strict mode errors in many different areas of phpVMS. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.