SDK PIREP Service.php error!

[Lbrianfly]

Hi,

I have a little problem with MySQL or FSFK..
Because, i have today a flight done..
Now i wanna log him, but i have an error..

And this is the responsebility of FSFK, because.. The SDK file gives this issue:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's', '131838', 'ENZV - Sola', 'Gate 1', '11 / 29', '3000', 'EHAM - Schiphol', 'Ga' at line 1

I did'nt have enter a new query or something, the normal SDK is it, only the connect did i have changed.. With an required mysql cfg file and use them with $sql arrays..

Regards,
Brian

(If my english is bad, im sorry!)

[Thomas Molitor]

Maybe a date/time configuration problem. What are your local settings on the Web and SQL server? Can you please add a special debug output for the SQL statement that the script tries to execute and post the result here.

Thanks

Thomas

[Lbrianfly]

@Thomas:

You mean the query?

Then:

INSERT INTO pirep (IDPIREP, CreatedOn, IDPilot, PilotName, AircraftTitle, AircraftType, TailNumber, Airline, FlightNumber, FlightLevel, FlightType, Passenger, Cargo, ZFW, OriginAirport, OriginGate, OriginRunway, OriginTA, DestinationAirport, DestinationGate, DestinationRunway, DestinationTA, AlternateAirport, SID, STAR, DistanceFlight, DistanceRoute, OUTTime, OFFTime, ONTime, INTime, DayFlightTime, NightFlightTime, BlockTime, FlightTime, BlockFuel, FlightFuel, TakeoffIAS, LandingIAS, LandingVS, FlightScore, FlightMapJPG, FlightMapWeatherJPG, FlightMapTaxiOutJPG, FlightMapTaxiInJPG, FlightMapVerticalProfileJPG, FlightMapLandingProfileJPG, FlightPlan, FlightCritique, Comment) VALUES ('050120120458025575', 20120105045802, '1000', 'Brian T', 'Transavia - Daar wordt je vrolijk van', 'BOEING B738', 'PH-HSC', 'Transavia', '5575', 'FL320', 'IFR', '109+3', '9400 KG\''s', '131838', 'ENZV - Sola', 'Gate 1', '11 / 29', '3000', 'EHAM - Schiphol', 'Gate B 10', '36L / 18R', '3000', '', 'KARL3F', '', '504', '424', '04.01.2012 12:31', '04.01.2012 12:42', '04.01.2012 14:08', '04.01.2012 14:24', '01:26', '00:00', '01:53', '01:26', '12303', '10316', '175', '146', '-233,00', '60,00%', '', '', '', '', '$@$FlightMapVerticalProfileJPG$@$', '$@$FlightMapLandingProfileJPG$@$', '1|ENZV|Airport|12.42|45099|176|786|290|290/22|5 2|KARLI|Intersection|13.02|40974|274|29644|183|345/82|-46 3|NAMIK|Intersection|13.06|40479|230|31914|190|4/86|-47 4|BUSOM|Intersection|13.09|40073|270|32003|186|11/82|-49 5|GOLUM|Intersection|13.13|39714|275|31996|203|13/81|-46 6|UPGAS|Intersection|13.14|39526|280|31955|216|83/75|-46 7|TIPAN|Intersection|13.20|38971|249|32000|219|332/64|-46 8|LARDI|Intersection|13.30|38162|247|30139|201|323/57|-45 9|TOPPA|Intersection|13.32|38103|230|28323|180|318/54|-44 10|EHAM|Airport|14.08|34785|144|-6|195|269/24|7', 'Beacon off during starting engines | -5,0% Wrong altimeter setting during Takeoff | -10,0% Strobe lights off during Takeoff | -5,0% Standard altimeter not set after reaching the transition altitude | -10,0% Strobe lights off during touchdown | -5,0% Beacon off while engines are running | -5,0% ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ Total Score for this flight | 60,0% Landing rating | Good Pilot rating | Moderate', '');

Regards,

[Thomas Molitor]

The problem is the following value: '9400 KG\''s'
This makes the SQL statement invalid. What is the actual cargo value in FSFK? Removing the char ' should solve the issue.

Regards

Thomas

[Lbrianfly]

Thanks Thomas!
Its works!.

Regards,