Quote:ReaperAussie wrote:
Having Problems with FSpassengers not uploading certain flights to my log server.
It uploads SOME flight but not all and shows this below.

* FSPassengers Sql Error - Unable to export flight number 24 - SQL Error - You have an error in your sql syntax *

I would love to see a proper sql server dump, one that does not get these errors.
Want to see the Tables : and how they are set.
flights
user_profile

I have set them the best I can with my limited knowledge of sql.
the problem is that the fspassenger website files were made for php 5.2 I believe and that was years a go, as php versions are now 5.5, etc, which is
what I am using.

Can anyone give me an updated version of the Tables to suit php 5.5 please ?
flights
user_profile


Any Help appreciated.
Can also contact me Here : vk3fwdt@iinet.net.au

Quote:ReaperAussie wrote:
It is one of your programs Dan - downloaded from the download section ( server files )
They really need to be updated to new php / sql, mine is currently php5.5

http://www.fspassengers.com/index.php?action=download&files=179_PHP_VirtualAirlineScript15.zip

fspassenger 179_PHP_VirtualAirlineScript15.zip

http://www.fspassengers.com/?
action=download&cat=All&sort=Date&page=&search=DanSteph&searchtype=Author&download=submit

I would love to just be able to import the table files to the sql server- as the admin for the program will not create the server tables needed.
I have had to add them manually, though unsure if they are truly correct, as I am not very experienced in sql database making.