FS Flight Keeper Problems

Daniel Reynard · Jun 11, 2012

Hi there,

I tried now to send two flights vie FSFK but getting an error message:

SQL query failed.INSERT INTO acpireps (pirepSys, IDPIREP, CreatedOn, IDPilot, PilotName, AircraftTitle, AircraftType, TailNumber, FlightNumber, FlightLevel, FlightType, Passenger, Cargo, ZFW, OriginAirport, OriginGate, OriginRunway, DestinationAirport, DestinationGate, DestinationRunway, AlternateAirport, SID, STAR, DistanceFlight, DistanceRoute, OUTTime, OFFTime, ONTime, INTime, DayFlightTime, NightFlightTime, BlockTime, FlightTime, BlockFuel, FlightFuel, StartFuel, FuelRemain, TakeoffIAS, LandingIAS, LandingVS, LAndingPitch, LandingWind, FlightScore, FlightMapJPG, FlightMapWeatherJPG, FlightMapTaxiOutJPG, FlightMapTaxiInJPG, FlightPlan, FlightCritique, Comment, PilotComment, pirepNbr, vatsim, ivao, rCount, cCount) VALUES (2,'11062012101220ACH00883040', 20120611101220, 'ACH0088', 'Daniel Reynard', 'D-AGES', 'BOEING B737', 'PH-SAD', 'ACH4253', 'FL320', 'IFR', '141', '1'781 kg', '112008', 'EDDT', '', '08L', 'EPKK', '', '26', '', '', '', '315', '285', '11.06.2012 09:09', '11.06.2012 09:10', '11.06.2012 10:01', '11.06.2012 10:08', '00:51', '00:00', '00:59', '00:51', '5961', '5424', '14708', '8747', '148', '132', '-212.24', '4.44', '328/6', '95.00%', 'ACH0088-2012_06_11_090900-4253.jpg', 'ACH0088-2012_06_11_090900-4253-Weather.jpg', 'ACH0088-2012_06_11_090900-4253-TaxiOut.jpg', 'ACH0088-2012_06_11_090900-4253-TaxiIn.jpg', '', 'Beacon off during starting engines | -5.0% ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ Total Score for this flight | 95.0% Landing rating | Good Pilot rating | Excellent', '', '', 322, 0, 0, 1, 0);

I did not change anything in FSFK and its version 3.3
I downloaded again the FSFK Files from my profile and they are also selected under the VA Settings.
Anyone who has the same problems or knows what to do?

Cheers
Daniel

Andre Bohni · Jun 11, 2012

Hi Daniel

I see the failure

Write 1781 kg instead of 1'781 kg in the Cargo field.

For the future i hope that Staff :hi: will correct this issue.

with Greetings from Switzerland
André

Peter Schindler · Jun 11, 2012

Andre Bohni said:
For the future i hope that Staff :hi: will correct this issue

So do I !!!

Daniel, can you try to send the report again. Problem should be fixed. Tell me in case something still fails.

@Andre: Thanks for your PM. Highly appreciated :yes:

Daniel Reynard · Jun 11, 2012

Hi,

wow quick answer there. Thank you.
I'll resend the report this evening when back home.

Gruess
Daniel

Oliver Pohl · Jun 11, 2012

SQL query failed.INSERT INTO acpireps (pirepSys, IDPIREP, CreatedOn, IDPilot, PilotName, AircraftTitle, AircraftType, TailNumber, FlightNumber, FlightLevel, FlightType, Passenger, Cargo, ZFW, OriginAirport, OriginGate, OriginRunway, DestinationAirport, DestinationGate, DestinationRunway, AlternateAirport, SID, STAR, DistanceFlight, DistanceRoute, OUTTime, OFFTime, ONTime, INTime, DayFlightTime, NightFlightTime, BlockTime, FlightTime, BlockFuel, FlightFuel, StartFuel, FuelRemain, TakeoffIAS, LandingIAS, LandingVS, LAndingPitch, LandingWind, FlightScore, FlightMapJPG, FlightMapWeatherJPG, FlightMapTaxiOutJPG, FlightMapTaxiInJPG, FlightPlan, FlightCritique, Comment, PilotComment, pirepNbr, vatsim, ivao, rCount, cCount) VALUES (2,\'11062012232703ACH02313388\', 20120611232703, \'ACH0231\', \'Oliver Pohl\', \'Embraer 190 Air-Child\', \'EMBRAER E-190\', \'CC-DFO\', \'ACH5611\', \'FL390\', \'IFR\', \'36\', \'1984\', \'70136\', \'SBGR\', \'Gate D 1\', \'09L\', \'SCEL\', \'\', \'\', \'SAME\', \'\', \'\', \'1557\', \'1479\', \'11.06.2012 13:54\', \'11.06.2012 13:59\', \'11.06.2012 18:19\', \'11.06.2012 18:22\', \'04:11\', \'00:09\', \'04:28\', \'04:20\', \'13470\', \'13037\', \'21147\', \'7677\', \'146\', \'117\', \'-133.03\', \'5.12\', \'167/11\', \'100.00%\', \'ACH0231-2012_06_11_135400-ACH5611.jpg\', \'ACH0231-2012_06_11_135400-ACH5611-Weather.jpg\', \'ACH0231-2012_06_11_135400-ACH5611-TaxiOut.jpg\', \'ACH0231-2012_06_11_135400-ACH5611-TaxiIn.jpg\', \'1|SBGR|Airport|13:59|20809|147|2472|93|91/2|17 2|CGO|VOR|14:11|19664|293|14932|274|277/34|-3 3|PONTE|Intersection|14:21|18711|254|33089|274|287/45|-45 4|DARCI|Intersection|14:31|18193|230|38193|272|277/53|-54 5|MORLU|Intersection|14:34|18015|228|38999|272|274/53|-56 6|SIPOR|Intersection|14:39|17749|243|39000|273|270/55|-56 7|MALEV|Intersection|14:42|17629|243|39000|272|269/55|-56 8|AULIC|Intersection|14:49|17298|243|39000|273|266/57|-55 9|DIDOM|Intersection|15:09|16291|243|39000|271|261/64|-56 10|CRANE|Intersection|15:15|16027|242|39000|271|262/63|-57 11|FOZ|VOR|15:21|15735|241|38997|267|262/62|-56 12|SAMGU|Intersection|15:49|14373|241|39000|259|265/66|-57 13|BOBIK|Intersection|15:58|13970|241|39001|259|266/66|-57 14|SIS|VOR|16:03|13707|241|39000|257|266/68|-57 15|TIKLA|Intersection|16:24|12727|242|38991|253|269/62|-58 16|PORKA|Intersection|16:43|11797|241|39000|253|273/70|-58 17|KUGIN|Intersection|17:08|10649|239|38998|253|280/74|-57 18|BURMI|Intersection|17:18|10185|239|39001|253|284/79|-57 19|JUA|VOR|17:30|9651|238|38998|257|285/91|-57 20|ASIMO|Intersection|17:46|9020|290|27282|264|298/76|-33 21|DILOK|Intersection|17:49|8957|290|22241|240|303/64|-22 22|TBN|VOR|17:58|8723|239|8485|175|339/34|9 23|SCEL|Airport|18:19|7773|114|1566|174|167/11|14\', \'No issues found ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ Total Score for this flight | 100.0% Landing rating | Very good Pilot rating | Excellent\', \'\', \'\', 156, 1, 0, 1, 0);

Same problem... Thanks for help...

Oliver

Peter Schindler · Jun 12, 2012

Oliver Pohl said:
Same problem... Thanks for help...

Actually not the same problem. This was because my modification yesterday was crap! That's what happens when you try to make a quick fix :x
Reverted now, but still (hopefully) fixed the part with cargo values.

To definitely fix that problem once and for all, it looks like I'm going to rewrite the whole Flightkeeper script from scratch...
Anyway, Oliver & Daniel & all who tried to send a FK report yesterday, please resend your reports. It really should work now

Oliver Pohl · Jun 12, 2012

That sounds good- thanks for help :rofl:

Daniel Reynard · Jun 12, 2012

Hi Peter,

I've just resent the report and it worked perfectly. I did not change the cargo value at FSFK so it looks like your fix from today was not too much crap

Thanks for the quick suport

Cheers
Daniel