Beatmap imports using the local cache lookup do not get a submitted / ranked date populated

[Loreos7]

Type

Game behaviour

Bug description

(Title). Works the same with Date Ranked sorting criteria.

Beatmap: https://osu.ppy.sh/beatmapsets/25861#osu/92939

Screenshots or videos

2023-01-25.16-02-23.mp4

Version

123

Logs

[Theighlin]

I can see said beatmap even with the date submitted sorting

But i'm more curious on why at the end of the video the game seems to show every beatmap you have as updateable?

Also, you should've posted logs, as requested in the issue template

[Loreos7]

@Theighlin This is due to #19551
Logs are
network.log
runtime.log
performance.log
updater.log
database.log

[Loreos7]

The issue was resolved by deleting online.db file.

[bdach]

The issue was resolved by deleting online.db file.

I'm... not sure that is an acceptable fix. Do you recall how the map might have been imported?

These symptoms may indicate that there's a gap somewhere in the metadata population flow that we may need to address.

[Loreos7]

@bdach You're right.
I can reproduce this issue again. I downloaded the beatmapset through the web, imported to osu!stable client, then imported it through Setup wizard in lazer.

2023-01-26.03-09-38.mp4

[peppy]

osu/osu.Game/Beatmaps/BeatmapUpdaterMetadataLookup.cs

Line 233 in 27c4971

// TODO: DateSubmitted and DateRanked are not provided by local cache.

To make this work, the local lookup database needs osu_beatmapsets in addition to osu_beatmaps.

[StarBleu1]

Not sure whether this counts as this issue or other one
Sorting by Date ranked, Date submitted and Date added doesnt seem to work at all for maps imported from stable.

Video for reference: https://streamable.com/0w1r6w
Gamever: 2024.817.0-lazer
1724241695.performance.log
1724241695.database.log
1724241695.updater.log
1724241695.runtime.log
1724241695.network.log

[bdach]

It'll be invariably caused by this issue, yes.

[huyenden]

Not sure whether this counts as this issue or other one Sorting by Date ranked, Date submitted and Date added doesnt seem to work at all for maps imported from stable.

For 2 years now I still think this is the biggest bug because the most useful lazer function which is date ranked doesn't work properly because of importing maps from Stable.

One of the ways I used to fix the error is https://github.com/molneya/osu_db_helpers. To update date added in stable to date ranked. Then enter map in lazer.

This way will bypass the error that causes lazer to still record date ranked as date added. But still can not avoid the original error.

Hope @bdach considers.