"Recently added flights" aren't recent

[reedy]

The homepage (when logged out), has a title of "Recently added flights", which would be a nice feature if it actually worked.

In reality, it seems to be a snapshot of some random (test data?) flights.

Simplest fix is to maybe just remove/disable this title, for now at least?

[chrisrosset]

The data is returned from map.php which uses user ID = 1 if you're not logged in. So this is whatever is defined in the database for that user.

This, just like another issue you reported (#1136), appears to be a case of a missing cron job. This data is supposed to be updated by update-demo.sql.

[reedy]

This, just like another issue you reported (#1136), appears to be a case of a missing cron job. This data is supposed to be updated by update-demo.sql.

I didn't check all the airports, but it does look like that's not been run in a long time...

[chrisrosset]

Probably since the server upgrade last year.

…

On Sat, Jul 8, 2023, 05:25 Sam Reed ***@***.***> wrote: This, just like another issue you reported (#1136 <#1136>), appears to be a case of a missing cron job. This data is supposed to be updated by update-demo.sql <https://github.com/jpatokal/openflights/blob/ecf635a4bc460a5ce3a911c34305672188ad6d80/sql/update-demo.sql> . I didn't check all the airports, but it does look like that's not been run in a long time... — Reply to this email directly, view it on GitHub <#1225 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAINLPVFRU3R6L6DXQTOCW3XPERRRANCNFSM6AAAAAA2B2TKAY> . You are receiving this because you commented.Message ID: ***@***.***>

[reedy]

The data is returned from map.php which uses user ID = 1 if you're not logged in. So this is whatever is defined in the database for that user.

That, is, I guess another bug...

I think user ID 1 should be reserved, or some account created as part of the install.

On my dev wiki, my account is ID 1 (of course), so it's the recent flights too...

Probably relevant to your docker setup too in #1206 :)

[chrisrosset]

On my dev wiki, my account is ID 1 (of course), so it's the recent flights too...

Yeah, this is exactly how I found out too. I was making changes to the map and noticed that it didn't change when logging in/out. It freaked me out - I thought I broke it. :)

[reedy]

[chrisrosset]

I just found #646 (comment) which includes a 2016 screenshot with that 2030-01-01 WAW-WAW flight we all know and love.