Juan Carlos Esteve Posted March 26, 2011 Report Share Posted March 26, 2011 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 !! Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted March 26, 2011 Moderators Report Share Posted March 26, 2011 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. Quote Link to comment Share on other sites More sharing options...
michael Kraan Posted March 29, 2011 Report Share Posted March 29, 2011 Heeyy,, This is really useful thanks! but do have a problem: how do you install it on the site? Michael Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted March 29, 2011 Moderators Report Share Posted March 29, 2011 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 2, 2011 Report Share Posted November 2, 2011 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted November 2, 2011 Report Share Posted November 2, 2011 Trying to make preferred routes my flight schedules... Help Please.... Peferred Routes Database Quote Link to comment Share on other sites More sharing options...
TennShadow Posted November 2, 2011 Report Share Posted November 2, 2011 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted November 3, 2011 Report Share Posted November 3, 2011 Will I now have 19000 preferred routes as my flight schedule... Just need to clean it up a little... [importable Preferred Routes] Thx for your help... Quote Link to comment Share on other sites More sharing options...
Nighthawk Posted December 21, 2011 Report Share Posted December 21, 2011 To Work with a sql database i use navicat. Its free and easy. Quote Link to comment Share on other sites More sharing options...
rpalmer800 Posted March 25, 2012 Report Share Posted March 25, 2012 @ SimPilot, That is a HUGE help, Thank you so very much. Quote Link to comment Share on other sites More sharing options...
animalking Posted May 18, 2012 Report Share Posted May 18, 2012 Thank you so much for this great file, you're amazing Quote Link to comment Share on other sites More sharing options...
smeely Posted July 3, 2012 Report Share Posted July 3, 2012 Would I be able to get the FSX database file? Quote Link to comment Share on other sites More sharing options...
Rnaetsar Posted January 27, 2014 Report Share Posted January 27, 2014 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: #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 Quote Link to comment Share on other sites More sharing options...
dohavik Posted March 16, 2014 Report Share Posted March 16, 2014 Thanks simpilot for the file with the airports data Quote Link to comment Share on other sites More sharing options...
cmtehudson Posted November 23, 2014 Report Share Posted November 23, 2014 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: #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: #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? Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted November 23, 2014 Administrators Report Share Posted November 23, 2014 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. 1 Quote Link to comment Share on other sites More sharing options...
cmtehudson Posted November 23, 2014 Report Share Posted November 23, 2014 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 Quote Link to comment Share on other sites More sharing options...
Simnut Posted March 7, 2015 Report Share Posted March 7, 2015 Massive help! Thank you very much Quote Link to comment Share on other sites More sharing options...
cvonhaytersirls Posted August 5, 2015 Report Share Posted August 5, 2015 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 Quote Link to comment Share on other sites More sharing options...
Zakariya Posted November 25, 2015 Report Share Posted November 25, 2015 hi, i am just wondering if there is a updated data base like this one. When i try to import the file it gives me errors like "Invalid syntax" etc Quote Link to comment Share on other sites More sharing options...
mattsmith Posted January 1, 2016 Report Share Posted January 1, 2016 I need help with this. I have added all the airports to my php myadmin and they are showing fine. When i go to my VA the airports aren't showing. Quote Link to comment Share on other sites More sharing options...
OmerAslan Posted March 9, 2016 Report Share Posted March 9, 2016 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 Quote Link to comment Share on other sites More sharing options...
pedroportugal Posted July 2, 2016 Report Share Posted July 2, 2016 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. Quote Link to comment Share on other sites More sharing options...
nicolaananda Posted July 21, 2016 Report Share Posted July 21, 2016 Anyupdate for new icao code & airac? Quote Link to comment Share on other sites More sharing options...
ThomasSNAv Posted November 14, 2016 Report Share Posted November 14, 2016 http://prntscr.com/d72qpm _____________________ I have tried to import the airports, and this error is showing up, can anyone help? Quote Link to comment Share on other sites More sharing options...
ShrikarG Posted November 14, 2016 Report Share Posted November 14, 2016 http://prntscr.com/d72qpm _____________________ I have tried to import the airports, and this error is showing up, can anyone help? First empty all the contents in phpvms_airports table. Then Import all the airports. Quote Link to comment Share on other sites More sharing options...
eliezerazevedo Posted September 4, 2017 Report Share Posted September 4, 2017 Database with 52163 Airports. Fetus file to be used in PHPVMS https://github.com/eliezerazevedo/Airports-PHPVMS Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.