Jump to content
APX0475

Complete Airports List

Recommended Posts

OK, Free hosting can limit limit you, so that's the problem, Free Hostings are not good. Paid ones, you won't have that kind of problems.

Hello, we has hosting at www.dreamhost.com, isn't free

We can't maintain a complete list of airport.

43000 reg in memory?? humm is too much.

phpVMS is wonderfull any way :)

Thanks !!

Share this post


Link to post
Share on other sites

Hey,

I took a look at your hosting, you can have it in your hosting, but not sure.

But the other side, if you are a "world-wide" airlines with every airport, and this is for you. But I would usually add the airports I do really need.

Share this post


Link to post
Share on other sites

Hey,

You go to phpMyAdmin and then go to your phpvms database and on the top, click on import and then elect the zip file that you downloaded and let it run it will take a while

But one thing, it could be restricted by your hosting but it s a wroth a try.

Share this post


Link to post
Share on other sites
Guest

Any of you sql wizards know if there is a way to make it skip entries that exist already instead of stopping? At most all I can get in is 58 airports. Before trying to run this I had only like 30 in my DB.

I suppose I could drop all my airports and start from scratch since it is a dev site anyhow. I hate to do that though due to schedules I already have that I do fly with for testing purposes.

Try INSERT IGNORE

Share this post


Link to post
Share on other sites

Trying to make preferred routes my flight schedules...

Help Please....

Peferred Routes Database

Your best bet would be to log into your site and export the schedules template under "Airline Operations". Then you will see what columns are required from your list. In regards to your preferred routes list you could import that into Excel to help you copy and paste some of the data between that and your schedules template.

Good Luck

Share this post


Link to post
Share on other sites

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said: dot.gif

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

Share this post


Link to post
Share on other sites

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said: dot.gif

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said: dot.gif

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

I'm with the same problem.... Someone know what to do?

Share this post


Link to post
Share on other sites
Why doesn't it just overwrite it? I can't for the life of me get it to work

There is nothing to overwrite......

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

The table does not exist (phpvms_airports) or you have a different prefix than phpvms_

If you deleted the table prior to trying to insert the new data then you will have to replace the table prior to the data insert. If your table already has data just empty the table (Truncate)

If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file.

  • Like 1

Share this post


Link to post
Share on other sites

There is nothing to overwrite......

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

The table does not exist (phpvms_airports) or you have a different prefix than phpvms_

If you deleted the table prior to trying to insert the new data then you will have to replace the table prior to the data insert. If your table already has data just empty the table (Truncate)

If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file.

"If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file."

What i was made. I opened the file and changed all the "phpvms_airports" to my table name, in this case, to "phpvms_globairports" and worked fine.

THanks for it sim, really nice!!

Thanks again!

Hudson

PS: Sorry my english errors

Share this post


Link to post
Share on other sites

I was reading through and it looked like the problem I had someone else had, but it hadn't been resolved yet. I can't view the airport list on the admin site. nothing shows up. How do I fix this, i tried clearing the cached data as well as optimize the tables but they still won't show. What do I need to do?

CJ

Share this post


Link to post
Share on other sites

Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try.

Thanks i download this but can you tell me where do i have to add this file? Sorry i am new. Thanks

Share this post


Link to post
Share on other sites

hello everyone i install the the DB locks ok but i use smartacars and the smartacars wont conect to my server because the airports. i delete this DB and install my old DB end works again. the diference its 41533 airports to 150 airports lol.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...