[Solved]Export to VA SQL problem

[One_Shot]

Greetings all,
I know this has been asked, but I didn't see an answer. I'm having an issue all of the sudden while trying to export
my flights to my VA. Everything
was working fine until I tried to send my last 2 PIREPs. I flew 4 flights today (2 were very short, 2 were about 2
hours each), but the last two
longer flights came up with this when trying to export:

Attempt To connect to website...Connection etablished - OK.

Welcome to Simulated Continental!

Simulated Continental/Jack McPeek selected
7 total flight, 2 flights marked as not exported. Ready to export...

-Exporting of 2 Flights started:
-Error, unable to export flight number 6 ->SQL Error - You have an error in your SQL syntax
-Error, unable to export flight number 7 ->SQL Error - You have an error in your SQL syntax

2 flights could not be exported.

All flights recently were in the same aircraft; all flown on VATSIM; all using FSX/FSPX; I'm using Windows XP 32bit.
Something else I noticed on the

[WEA-CAS]

Heii
I had the same problem.. but we have fix that problem.

flight wea036 LEMD-->UKFF flight time 4H 1727nm
UKKF hedder Simferopol...i ukraine. (Simferopol' )

( ' ) That was the problem.


Well i have done some more research on this... and i think the problem is the SQL Database.
The problem is that i can't change the MySQL charset and MySQL connection collation on weaf.eu SQL.
The problem is that the weaf.eu server are running a old SQL version for some reason don't allow the use of ' this charset
weaf.eu SQL server is version 4.0.21 and todays new version is around v.5.0.XX.
We still have some flights that has been uploaded in year 2006 that has the ' charset. And we have problem to view them now

The name was: KORD - Chicago O'Hare Internatio - Usa Chicago O'Hare Internatio Usa

As you may notice, we got a SQL error.

To make SQL servers to allow this type of ' charset we need to change the MySQL charset and MySQL connection collation to use:

MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

I have been searching at FsPassengers forum for same problem, nobody else has this charset problem with this ( ' ).
We have two opinion:
1. Ask the web hotel to upgrade the SQL to the newest version.
2. One of us have to take the hard way and change both files IcaoDbFspX.cfg and Icao_db.cfg. And remove all ( ' ) from the list.

We think we found the problem about WEA-CAS exporting problem. Som airports has this sign ( ' ) in its name. What we did was:
Opened his IcaoDbFspX.cfg in a texteditor(Notepad) (path=X:\Programfiler\Microsoft Games\Flight Simulator X\Fspassenger\Config).
Searched for dest/arr airport we thought was the problem. Then we removed the sign ( ' ) from the airport and saved the file. The he
launche FSX and tried to export the flight again and VOILA.......it worked like a charm. So for those who might get this problem can either
ask for help ot just do as we did

P.S. Do a BACKUP of your database folder...just incase

Hope that can help you..

[One_Shot]

Well, if that's the problem, it might make sense. The two flights I flew were to O'hare, which is what you described above. Is there a way to
"uncheck" those 2 flights so on further flights they don't try to send? I guess I'll have to send these manually and not fly FSP into O'Hare at least
until the SQL is updated.

[Bondorf]

Thanks WEA-CAS...
We've been having problems with a few of our flights. Too bad I didn't see this post before deleting the flights.
For us it was an apostrophe problem too. I tried changing the database character code to UTF-8 like you mentioned but still no go.
So I went into the ICAO database file in FSPX and removed the apostrophe and the period too just in case. Then did my export and it
worked fine.

Thanks for the tip...

[Joeflyer]

I've had the same issue,too, and removed any apostrophe in the airport name. I hope more people see this post in order to avoid posting
more questions about it

[crowebird]

you need to escape sql strings
via php you can do addslashes, or I believe in mysql sql if you add another ' it will allow the single quote,
just going off the top of my head here though, so '' instead of just ', you can do this via str_replace("'", "''", $var);
or $var = addslashes($var);

hopefully that helps