Frank Plummer Posted June 9, 2011 Report Share Posted June 9, 2011 Good day all, little problem I could do with some help with.. My pilots are reporting incorrect number of flights shown in their profiles. Sure enough in the administration panel of phpVMS, they are shown incorrectly too, but the PIREP records ARE there. For example, a pilot named John has flown well over 30 flights for the VA, and the PIREP records are shown as his in the administration panel, but his "Total PIREPs" are only 8.. The total PIREPs do not change either, no matter how many he flies. Has anyone come across this issue before? Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted June 9, 2011 Moderators Report Share Posted June 9, 2011 what version are you on and could you run the checkdb plz Quote Link to comment Share on other sites More sharing options...
Frank Plummer Posted June 9, 2011 Author Report Share Posted June 9, 2011 what version are you on and could you run the checkdb plz Output of checkdb.php Checking phpvms_acarsdata...OK Checking phpvms_adminlog...OK Checking phpvms_aircraft...OK Checking phpvms_airlines...OK Checking phpvms_airports...OK Checking phpvms_awards...OK Checking phpvms_awardsgranted...OK Checking phpvms_bids...OK Checking phpvms_customfields...OK Checking phpvms_downloads...OK Checking phpvms_expenselog...OK Checking phpvms_expenses...OK Checking phpvms_fieldvalues...OK Checking phpvms_financedata...OK Checking phpvms_fuelprices...OK Checking phpvms_groupmembers...OK Checking phpvms_groups...OK Checking phpvms_navdata...OK Checking phpvms_news...OK Checking phpvms_pages...OK Checking phpvms_pilots...OK Checking phpvms_pirepcomments...OK Checking phpvms_pirepfields...OK Checking phpvms_pireps...OK Checking phpvms_pirepvalues...OK Checking phpvms_ranks...OK Checking phpvms_schedules...OK Checking phpvms_sessions...OK Checking phpvms_settings...OK Checking phpvms_updates...OK Running 2.1.934 Thanks! Quote Link to comment Share on other sites More sharing options...
Strider Posted June 10, 2011 Report Share Posted June 10, 2011 Try using the reset pilot pirep count, that may fix that problem. Quote Link to comment Share on other sites More sharing options...
Frank Plummer Posted June 10, 2011 Author Report Share Posted June 10, 2011 Try using the reset pilot pirep count, that may fix that problem. I was unsure about using that as it isn't clear; does that reset the count to 0, or force the VMS to look at the database again? Quote Link to comment Share on other sites More sharing options...
Frank Plummer Posted June 10, 2011 Author Report Share Posted June 10, 2011 An update with more accurate information, the "Flights" by each pilot are the issue here, not the PIREPs. John only has 8 flights against his name, and 30 PIREPs.. Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted June 10, 2011 Moderators Report Share Posted June 10, 2011 url to the site so i can take a peak Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted June 10, 2011 Administrators Report Share Posted June 10, 2011 An update with more accurate information, the "Flights" by each pilot are the issue here, not the PIREPs. John only has 8 flights against his name, and 30 PIREPs.. Can you find one of the PIREPs which he is supposed to have, and then see what the pilotid is on that record in phpMyAdmin or whatever you use to browse your database? Also, are they ACARS flights? If so, which ACARS program And only one pilot? Or all your pilots? Quote Link to comment Share on other sites More sharing options...
Frank Plummer Posted June 10, 2011 Author Report Share Posted June 10, 2011 Can you find one of the PIREPs which he is supposed to have, and then see what the pilotid is on that record in phpMyAdmin or whatever you use to browse your database? Also, are they ACARS flights? If so, which ACARS program And only one pilot? Or all your pilots? The pilotid value does correspond to the flights done in phpMyAdmin, so the PIREP is associated with the correct pilot, it's just that "Flights" value in their profile that is effected. For example, John (pilotid=2) has flown 16 PIREPs according to the database in phpMyAdmin, but "Flights" in phpVMS only amount to 8. They are ACARs flights, with kACARs, and this effects all my pilots. url to the site so i can take a peak http://www.alphastone.co.uk/severnair/phpvms/ The pilot I have been referring to isn't called "John"; I substituted his name for privacy reasons. If you'd like his name and details on the site please PM me and I will see what I can do. Thankyou both! Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted June 10, 2011 Moderators Report Share Posted June 10, 2011 whats the code u are using to get the flights in the pilot profile main Quote Link to comment Share on other sites More sharing options...
Frank Plummer Posted June 11, 2011 Author Report Share Posted June 11, 2011 whats the code u are using to get the flights in the pilot profile main I'm using the code that comes with the standard phpVMS install, I haven't changed it. This is a screenshot from the VMS, with the pilots name taken out. You can see that the "Total Flights" number does not correspond to his PIREP number, even after resetting the PIREP count in the administration panel. Quote Link to comment Share on other sites More sharing options...
Frank Plummer Posted June 12, 2011 Author Report Share Posted June 12, 2011 Same issue as this poster: http://forum.phpvms.net/topic/4059-pilot-flight-count-problem-solved/page__p__27261__hl__%2Bpirep+%2Bcount__fromsearch__1#entry27261 Problem solved the same way, but can the devs please look into this as automatic PIREP accepting is a nice feature. 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.