i’m sorry that i have multiple threads open however i tought it was a good idea to not mix them up as i have multiple problems
btw anyone who has a schedule file a little kickstart so it’s a bit easier to add routes?
i attached the file i’m trying to upload to Mysql
i’m trying to import a few hundred thousend airports
this is the error i get
Feil
SQL-spørring:
– – Dataark for tabell phpvms_airports – INSERT INTO phpvms_airports (id, icao, name, country, lat, lng, hub, fuelprice, chartlink) VALUES (678, ‘0II2’, ‘Creighton Airport’, ‘US’, 41.4573, -86.1244, 0, 0, ‘’), (679, ‘0II3’, ‘Miller Strip’, ‘US’, 40.6278, -86.0378, 0, 0, ‘’), (680, ‘0II5’, ‘Marshall Field’, ‘US’, 40.6595, -86.8572, 0, 0, ‘’), (681, ‘0II6’, ‘Kropf Airport’, ‘US’, 41.6431, -85.8297, 0, 0, ‘’), (682, ‘0II7’, ‘Frost Field’, ‘US’, 39.7956, -85.7861, 0, 0, ‘’), (683, ‘0II9’, ‘Winters Airport’, ‘US’, 39.5342, -86.5772, 0, 0, ‘’), (684, ‘0IL0’, ‘Hamilton Memorial Hospital Heliport’, ‘US’, 38.0867, -88.5389, 0, 0, ‘’), (685, ‘0IL1’, ‘Loyola University Medical Center Heliport’, ‘US’, 41.8609, -87.8364, 0, 0, ‘’), (686, ‘0IL3’, ‘Flying B Ranch Airport’, ‘US’, 40.157, -87.6745, 0, 0, ‘’), (687, ‘0IL4’, ‘Good Samaritan Hospital Heliport’, ‘US’, 41.8189, -88.0078, 0, 0, ‘’), (688, ‘0IL6’, ‘Kishwaukee Comm Health Heliport’, ‘US’, 41.9631, -[…]
MySQL sa:
#1062 - Duplicate entry '678' for key 'PRIMARY'
[phpvms_airports.sql.zip](< base_url >/applications/core/interface/file/attachment.php?id=4286)