Landingstats beta (DEPRECATED)

We have 1582 pireps fled.

You filed 1582 pireps since you installed the module?

no, total before. I had 3 in pending when I installed th module. I accepted one and nothing changed.

did you add those lines to your mysql database?

no, total before. I had 3 in pending when I installed th module. I accepted one and nothing changed.

you have to file one for it to start - the listener is looking for ā€œNew PIREP Filedā€ just file a pirep manually and then delete it from pending. That should populate the db, it ma y take a few seconds to go through that many pireps the first time but should not be an issue

That didn’t work. I will wait for a new pirep with a landing rate. Maybe because manually pireps don’t have the landing rates.

exactly  8)

That didn’t work. I will wait for a new pirep with a landing rate. Maybe because manually pireps don’t have the landing rates.

the module knows the difference between a manual and acars pirep… Check your db in the stat_calculated colom and tell me what is in it, and make sure both the stat_calculated and landing_rate coloum are there

Don’t have Landing Rate, here is what I have

pirepid pilotid code flightnum depicao arricao aircraft flighttime distance submitdate accepted log load fuelused fuelunitcost fuelprice price flighttype pilotpay expenses expenselist source stat_calculated landing_stat

are there any values in the database for the last two?

look me up on msn - i am on

the first 2, id 1 and 2 have landing rates. the rest show 0 in the field. The Stat Calculated show 0 or 1.

A 0 in the stat_calculated field means that the module has not looked at that pirep. it should not be skipping over any. The landing rate field should have a landing rate if there is a log availabloe in that row or a 0 if there is no log. I would try deleteing those two columns and rerun the sql file to clear the fields and have 0 in everything, then manually file a pirep and see if it runs through all of them. Maybe something was running at the same time…

I cleared the 2 fields, and re inserted the sql. I also submitted a manual pirep. I get the same error

http://www.flyaka.com/index.php/

what does the db fileds look like now? just like the first time?

the db shows landing rates in pireps flown on acars. Not showing on the main page.

try reuploading all the files again, other than the sql… it is not filling the variable for some reason, maybe a corrupted file

got it working now

Another thing that I noticed, In admin it always shows a 0 rating

I can’t get this to work. I have the same error as before and reported by others and have filed 4 pireps since then.

To try and correct issue, I have uploaded fresh files as well as checked the sql tables. The alterations were made to the database as they should, but it says 0 in both entries when checking the database.

And as far as the admin panel goes, the edit worked, but since I am getting nothing in my databse, it shows 0.

I can’t get this to work. I have the same error as before and reported by others and have filed 4 pireps since then.

To try and correct issue, I have uploaded fresh files as well as checked the sql tables. The alterations were made to the database as they should, but it says 0 in both entries when checking the database.

And as far as the admin panel goes, the edit worked, but since I am getting nothing in my databse, it shows 0.

Sounds like the module is not seeing the event of a pirep filed in order to run the calculations and insert the data into the sql table.

What version are you using?

Have you made any mods to the PIREPS.php file in the main install?

I can’t get this to work. I have the same error as before and reported by others and have filed 4 pireps since then.

To try and correct issue, I have uploaded fresh files as well as checked the sql tables. The alterations were made to the database as they should, but it says 0 in both entries when checking the database.

And as far as the admin panel goes, the edit worked, but since I am getting nothing in my databse, it shows 0.

This happened to me too, to fix I simply changed the 0’s in the database to 1 and -100 then recalculated the distances in the admin panel, it works ok for me now on all pireps.

Try that and see how you go,