[Bug] (alpha) 500 internal server error (pydantic ValidationError) about romm HOT 3 CLOSED

Triggering a new scan of the affected platforms fixes the bad data and resolves the error.

select json_type(json_extract(files, "$[0]")) as type, count(*)
from roms
group by type

Eventually, after re-scanning all platforms, null came down to zero too:

from romm.

Some detail on the cause: the files column on the roms table used to be a list[str], but now it's a list[RomFile]. However, in my database, ~47 rom records still have strings instead of objects:

select json_type(json_extract(files, "$[0]")) as type, count(*)
from roms
group by type

I'm not sure why 47 records failed to convert to object, or how to force them to convert (short of manually updating the db records)

from romm.

Thanks for investigating this! I was about to add that triggering any scan will fix the files array, and that the latest alpha release should trigger a scan on startup (through a migration). In any case we'll add a note in the release notes to manually run a scan if it doesn't trigger automatically on upgrade.

BTW if you're interested in testing future pre-releases, there's a closed Alpha Testers group on our Discord. We'd love to have you join it! https://discord.gg/PDGPX6tZ

from romm.