Next deployment (after 2024-02-01) to openflights.org

[reedy]

Next major deployment after #1391, some items copied forward. 74539bd is deployed as of 2024-08-20.

• attempting to edit an airport yields an internal server error #1314 / 5e0fae7 - Check and update $GITHUB_ACCESS_TOKEN if it's expired (it might not be, just the previous code update was rubbish in c03f720).
  • May want to check the submission works afterwards too.
  • It might be necessary/useful to do Submit airport edit suggestions under a different account #1171 too; add/create an openflights-bot user (or similar), and create a token on that account.
  • Maybe leave a comment in the config.php when the token is due to expire; as the newer token style only last a year.

TODOs:

• Add en_GB locale to locale table
  • Write script/sql file to update locale table #1404 - Make updating locale table easier; don't just want to run sql/load-data.sql. Split locale stuff into a new/separate/extra file so it can be run separately?
• Do we need to do any locale related regeneration server side? (Need more documentation here...)
• Update some of the data files in repo from openflights.org #1414
  • Update route table. Data updated 2023-03-22.
    • Add schedule table schema to import-vrs.py refers to schedules table which isn't in create.sql #1408.
    • Run tools/update-arm.sh.
    • Run sql/import-arm.sql.
    • Export updates routes to data/routes.dat.
• HSTS headers #1435

---

Other fixes (missing files/crons):

• Site statistics is giving a 404 (top10.dat) #1136 - Run sql/top10.sql and add/fix cron job.
• "Recently added flights" aren't recent #1225 - Run sql/update-demo.sql and add/fix cron job.

---

Errors from logs that could do with investigating (or at least, logs posting on tasks):

• attempting to edit an airport yields an internal server error #1314
• TripIt import blank page/fatal #1178
• Errors in Analysis Results #1483 (possible SQL errors?)