NWA1999 Posted June 2, 2021 Report Share Posted June 2, 2021 (edited) Hello About 2 years ago we upgraded to PHP 7 from PHP 3 (i know that I waited a long time to ask) .However we are still running phpVMS 2.1.936. Ever since upgrading we have been running into weird database issues. Basically if you try to delete a route a few (few because I don't know how many sometimes 2, 3,7) days later the routes will come back. Same thing when trying to edit routes. Edit the route say you want to make KLM 1234 go EHAM-EGLL instead of EHAM-LOWW. I edit it all is good, a few days later KLM 1234 is back to EHAM-LOWW. Just this past weekend i also noticed this same issue when trying to delete PIREPs I can't for the life of me figure out where I begin looking for the issue (not an expert coder however I do know a bit and learning) Any ideas as to where this issue might be or would this be more of a general SQL/PHP issue suited for stackoverflow? Thanks Robbie Edited June 2, 2021 by NWA1999 Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted June 3, 2021 Administrators Report Share Posted June 3, 2021 That phpVMS version is no longer supported and will not work correctly with PHP 7. What version of MySQL or MariaDB? Time to seriously consider moving the phpVMS v7. Your version is so old, it isn't even worth the hassle to update to phpVMS 5.5.2 or 5.5.2.72 Quote Link to comment Share on other sites More sharing options...
NWA1999 Posted June 3, 2021 Author Report Share Posted June 3, 2021 Hello Sorry the version number in the admin panel is also wrong. We are running phpVMS v5, and to answer your question its MySQL v5.7.34 Thanks Robbie Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted June 3, 2021 Administrators Report Share Posted June 3, 2021 MySQL versions above 5.7.4 have been known to cause issues with adding/deleting airports, aircraft and schedules. At this time, there is no fix for this. To delete schedules - If you don't know what you are doing, do NOT attempt this. 1 - make a backup or copy of your database. 2 - delete the schedules from your live database schedules table. 3 - check to be sure they are deleted and that everything else works. 4 - if it does, you are done. If not, use the info in the backup/copied database to restore the live database table. Quote Link to comment Share on other sites More sharing options...
NWA1999 Posted June 3, 2021 Author Report Share Posted June 3, 2021 I thought I tried that before and it did the same thing but I have tried it again and I will report back Thanks Robbie 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.