DesComm Posted January 25, 2019 Report Share Posted January 25, 2019 When PIREPS are accepted the hours are not being updated automatically in the pilot logbook. Hours and flights are only updated when the 'maintenance module' is run. Any suggestions? Quote Link to comment Share on other sites More sharing options...
DesComm Posted February 4, 2019 Author Report Share Posted February 4, 2019 BUMP Quote Link to comment Share on other sites More sharing options...
DesComm Posted March 15, 2019 Author Report Share Posted March 15, 2019 BUMP Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 16, 2020 Report Share Posted May 16, 2020 Same problem here... Did you managed to solve it? Quote Link to comment Share on other sites More sharing options...
mahir Posted May 16, 2020 Report Share Posted May 16, 2020 Which phpVMS versions are you guys using? Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 16, 2020 Report Share Posted May 16, 2020 I'm using version simpilot 5.5.2 Quote Link to comment Share on other sites More sharing options...
mahir Posted May 16, 2020 Report Share Posted May 16, 2020 Try doing a clean installation.. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 16, 2020 Administrators Report Share Posted May 16, 2020 @Skytraveler For clarification: PIREP hours don't update when you approve the PIREP? PIREP hours do update after running the maintenance script? Is this something new, or has it been doing it for a while? If new, what were the last modules your added or files you edited since it was working correctly? You already stated you are on phpVMS 5.5.2 Was this a conversion from phpVMS 2.1.x or a totally new install at some point? What PHP version? What MySQL/MariaDB version? Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 16, 2020 Report Share Posted May 16, 2020 Hi. Thanks for your reply. - PIREP hours don't update after PIREP approval; - They do update after running maintenance script; - It's not new, I don't know what triggered it. I just have time now to try to address this; - This was a conversion from phpVMS 2.1.x; - The PHP version is 5.3 - mySQL 5.6.43 Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 16, 2020 Administrators Report Share Posted May 16, 2020 When the conversion from 2.1.x was done, were the database tables updated to add the additional table fields and new tables? To quickly see - In the Schedules table, are columns for week1, week2, week3, week4 ? Is there a Ledger table? There are several other items added to the 5.5.2 database Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 16, 2020 Report Share Posted May 16, 2020 Yes, it appears database tables were updated. I have a schedules table with columns for week1, week2, week3, week4 and a Ledger table too Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 17, 2020 Administrators Report Share Posted May 17, 2020 OK - that's good. Can you try setting up a development site with a new install of phpVMS 5.5.2 and see if it works? Leave our live site alone for now. Run the dev site on the same host in a different directory. Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 17, 2020 Report Share Posted May 17, 2020 (edited) I followed you suggestion and did a new phpVMS 5.5.2 installation on the same host in a different directory. Here, everything runs OK, hours are being updated as they should... Edited May 17, 2020 by Skytraveler Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 17, 2020 Administrators Report Share Posted May 17, 2020 Make a backup of your database and marry that backup database to this new install. Test to see if its working. If so, add you skin and then slowly add any addon modules you use. If its still all working, change the new install to your old live database and redirect your domain to the new install location. If all that goes well, you now have a new install with your original database that is working as intended. If it doesn't work as you are doing the steps, investigate the last item you did which caused the issue to return. Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 17, 2020 Report Share Posted May 17, 2020 I understand. Ok, I will do that. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 17, 2020 Administrators Report Share Posted May 17, 2020 Great... let us know how it works out. Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 17, 2020 Report Share Posted May 17, 2020 Married the old database to the new install. No skin installed yet. Got this first error: Notice: The template file "/home/teaceo/public_html/dev//lib/skins/CURRENT_SKIN/header.php" doesn't exist in /home/teaceo/public_html/dev/core/classes/TemplateSet.class.php on line 231 I don't have a skin called "CURRENT_SKIN" and also there are 2 "//" before lib/skins/... Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 17, 2020 Administrators Report Share Posted May 17, 2020 CURRENT_SKIN refers to the skin selected in the admin panel. If no addon skin installed, that means the crystal skin. But the crystal skin doesn't have a header.php file. I bet the old db is set for your addon skin instead of crystal. Go to admin panel and set the skin to crystal. Or if you can't get to admin panel, go into the active db Settings table and change the skin name there. Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 18, 2020 Report Share Posted May 18, 2020 (edited) Ok, thanks, did it and that is solved. I believe I may have found one possible problem, my installation started having problems accessing data... My site is https. At the local.config.php, if I enter my SITE_URL as https://..., the Airports and Schedules in admin area do not load (but all other admin pages do...). If I go back and change the SITE_URL to http, I get all airports and schedules correctly. I'm still using default phpvms 5.5 skin. Edited May 18, 2020 by Skytraveler Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 18, 2020 Administrators Report Share Posted May 18, 2020 5 hours ago, Skytraveler said: Ok, thanks, did it and that is solved. I believe I may have found one possible problem, my installation started having problems accessing data... My site is https. At the local.config.php, if I enter my SITE_URL as https://..., the Airports and Schedules in admin area do not load (but all other admin pages do...). If I go back and change the SITE_URL to http, I get all airports and schedules correctly. I'm still using default phpvms 5.5 skin. Sounds like you need to double check that all "http" entries are changed to "https". There is a post in the forums that discusses changing to https - but I was unable to locate it. EDIT: Have a look at this thread..... Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 18, 2020 Report Share Posted May 18, 2020 Will do that. Thank you very much for your help. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 18, 2020 Administrators Report Share Posted May 18, 2020 Let us know how it all works out. 👍 Quote Link to comment Share on other sites More sharing options...
Skytraveler Posted May 20, 2020 Report Share Posted May 20, 2020 It's now working!!! I followed your advice and slowly added all my addons. I had some code of my own added to the PIREPData.class.php, so I didn't copy this file to the new installation, I carefully looked for my customized lines of code in it, and pasted them to the existing PIREPData.class.php on the new installation. I'm not able to identify where the problem was, maybe it was on this file, maybe a bad redirection of some file from my previous http installation to my new https... Maybe both! 🙄 Anyway, your suggestion not only solved my problem, but also now my phpvms is running smoother and pages are loading faster. Thanks for your support and for being available ☺️ Best regards. Joao Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 20, 2020 Administrators Report Share Posted May 20, 2020 You're welcome! Thanks for coming back and letting us know it worked out well for you. Yes, a fresh install and careful adding of skin/addons does wonders for the smoothness and speed. 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.