[SOLVED] Bad distance calculation from PIREP's data

phpVMS Legacy Support
1

Hi guys,

I’ve just installed phpVMS 2, added one new airport HUB (in addition of the default KJFK), and 2 scheduled flights (from and to the new airport).
The new airport is LFMT, the 2 new schduled flights are LFMT to EIDW and EIDW to LFMT.

I’ve flown these 2 scheduled flights with Xplane and xacars. All was fine. But when the PIREP was validated, the miles flown remains to 0 as my to flights have respectively 782 and 771nm (so a total of 1553nm). So in the maintenance page, I’ve ran the “Recalculate distances”, and now the 2 PIREP’s has 2627.91 nm for the distance and the total miles flown to 5256nm !

So I’ve noticed that the phpvms_navdata table is empty, but was populated with the navdata.sql file in the install folder and doesn’t change anything !

In addition, all the cache were cleared !

But the total miles flown remains wrong ! So how to fix this issue ?
Thanks a lot,

Alain

2

It does not have to do with the navdata table. Have you added the airports (LFMT, EIDW) into your database? Admin Center -> Airline Operations -> Add & Edit Airports?

3

Hello,

Thanks,

I’ve only added to the airport LFMT, my hub and not EIDW.

By adding EIDW, the calculation is now correct