FSPassengers Sql Error - Unable to export flight

[ReaperAussie]

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

[SamTDS]

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

There will be an update to fsp in about 15 days

[ReaperAussie]

Great News !!

Thank You

[DanSteph]

Hi,

What PHP script do you use exactly ? (download location?)

Kind regards

Dan

[ReaperAussie]

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?ac...ript15.zip

fspassenger 179_PHP_VirtualAirlineScript15.zip

http://www.fspassengers.com/?action=down...oad=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.



Post Edited ( 11-10-15 18:21 )

[SamTDS]

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?ac...ript15.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.

Get phpmyadmin and that will help you a lot with SQL stuff

[ReaperAussie]

any way I can get someone to do a new version of the tables to suit php5.5 ?
that would help a lot, as I fear I may be jumping out of the frying pan in to the fire...........

All I need is an updated version of the tables, the rest is fine..........

[DanSteph]

Sorry for the delay, I'm in the middle of P3D dev and FsPX's new patch.

I plan to rewrite the script anyway at last after the release of P3D version.

[ReaperAussie]

Ok Thank you Dan That Would be Great.

I know you must be very busy.

Thanks.

[ReaperAussie]

Would there be an approximate time frame for the New Server files ?



Post Edited ( 11-22-15 05:19 )

[DanSteph]

Follow the dev here:
http://www.fspassengers.com/forum/showth...p?tid=4423

Sorry for the delay, but I'm really too busy with the new versions yet.

[ReaperAussie]

Thanks Dan.

Yes I appreciate you are busy