Rnaetsar Posted January 27, 2014 Report Share Posted January 27, 2014 Hi guys. I've been running into various problems this week as I learn about PHPVMS etc. I'm very new to it and, well, It's not something I understand a great deal about; Coding and everything that isn't as easy as wordpress daunt me! Thankfully, I've managed to sort out a few issues but my biggest one yet, and one that could potentially mess up my VA at a later date, is the airport database! I've been inserting routes recently and I get this error: Imported WDW415 (LBWN to EGBB) ICAO EBBR not added... retriving information: Could not retrieve information for EBBR, add it manually Imported WDW416 (EGBB to EBBR) ICAO EBBR not added... retriving information: Could not retrieve information for EBBR, add it manuall Basically, this means that I can't select these airports from the drop down menus, yet they're in the schedules list. I found this thread http://forum.phpvms....st/page__st__40 which seemed like a fix for my issue, meaning I wouldn't need to enter brand new airport data for every single airport, which, would take me forever. Unfortunately, when I load into phpmyadmin and try to add the file, I'm met with these errors: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK' at line 1 This one I get when I'm in the Airport Table Any help would be greatly appreciated, Please also be noted I'm as thick as a plank of wood when it comes to this sort of thing, so simple terms would be fantastic. Thanks in advance Quote Link to comment Share on other sites More sharing options...
Rnaetsar Posted January 27, 2014 Author Report Share Posted January 27, 2014 Just thought I'd give an update... I've been thrashing at this for the whole evening. Anyway, I've managed to add 36,000 odd airports to the database, which defeats my earlier problem. Now, the main issue... Again... Imported WDW508 (EGBB to LBWN) ICAO LBWN not added... retriving information: Could not retrieve information for LBWN, add it manually Imported WDW509 (LBWN to EGBB) ICAO EBBR not added... retriving information: Could not retrieve information for EBBR, add it manually Imported WDW510 (EGBB to EBBR) ICAO EBBR not added... retriving information: Could not retrieve information for EBBR, add it manually Imported WDW511 (EBBR to EGBB) ICAO EGAA not added... retriving information: Could not retrieve information for EGAA, add it manually Imported WDW512 (EGBB to EGAA) ICAO EGAA not added... retriving information: Could not retrieve information for EGAA, add it manually When I import my routes, again, this is what I get. I checked for EGAA in the "Add/edit airports" menu... And it was there! EGAA Belfast International Airport GB Live 54.6575 -6.21583 Edit But, it says that it couldn't receive the information. I go to the Pilot Centre and then schedules, and the majority of the airports are still not listed in drop down menus. I go onto the Airports page, find EGAA and click Edit.. All the fields are blank, despite the fact the information is there Can anyone help? Quote Link to comment Share on other sites More sharing options...
Rnaetsar Posted January 27, 2014 Author Report Share Posted January 27, 2014 Problem solved! After the above post, I remembered to clear the Cache! , Just takes a long time to load on the page Quote Link to comment Share on other sites More sharing options...
alblua Posted February 1, 2014 Report Share Posted February 1, 2014 Problem solved! After the above post, I remembered to clear the Cache! , Just takes a long time to load on the page Great to know you found your solution; maybe mark as solved so someone might know this is a thread already solved and contains a possible answer? 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.