We have an issue we can not solve and need assistance please. We have a flight which is displaying on our Live Flight Board from a pilot that was removed/deleted.
This is messing up how the Live Flight Map/Live acars Map is displaying. I have deleted the flight from phpvms_acarsdata which fixes the issue for a few minutes, then the flight just reappears after a few minutes which then messes up the maps again.
Could anyone please assist us in resolving this issue.
Hello there, if the flight comes back up after removing it from acarsdata table, that means the guy is still connected to your website through the acars software and that means their account is still active on your system
When the flight reappears in the phpvms_acarsdata it looks like this no name is displayed or Lat/Long. what can we do to resolve this issue? how to we completely remove his account from the system?
Like I said the acars software is still on and makes the table refresh, check the pilots table for the pilotid, if it’s there, delete their record manually
His pilot id is not in the pilots table anymore, he was already deleted from the pilots table. If the flight is still live how would it be listed in the pireps table until filed?
Is their a way to recover his deleted account. Then reactivate it so he is listed in the active roster, then look him up in the phpvms admin / Pilots & Groups / View All Pilots… to get his IP then block it?
His pilot id is not in the pilots table anymore, he was already deleted from the pilots table. If the flight is still live how would it be listed in the pireps table until filed?
Thank you for your assistance Parkho
You’re welcome, the acars table only updates when the software is connected to the website and is sending flight data, so he might have some other access accounts to your website like the main email and password (just a guess).
Is their a way to recover his deleted account. Then reactivate it so he is listed in the active roster, then look him up in the phpvms admin / Pilots & Groups / View All Pilots… to get his IP then block it?
It is not possible to recover the deleted account unless he registers with the same email address. There is one more possibility, Check the bids table, he might still have a bidded flight after account termination. I know acars softwares check for flight bids table to fetch some data
