mora.jp links are not validated and are cleaned improperly

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 2026-01-19
    • Affects Version/s: None
    • Component/s: URL cleanup
    • None

      Issues:

      1. There is no validation implementation for Mora link type against MusicBrainz entity type.
      2. Only release (package) links are properly cleaned up.
      3. Recording (track) links are cleaned up as release links making them invalid for recordings.

      Impact as of 2026-01-02 for Mora links:

      Total links: ~73 000
      Total unnormalized artist and release links: ~500
      Total incorrect artist links: ~50
      Total incorrect recording links: ~150 (if my SQL is correct, all of them)

      -- Get all Mora links associated with recordings
      SELECT url.gid AS ugid, recording.gid AS rgid, recording.name, url FROM l_recording_url JOIN recording ON recording.id = entity0 JOIN url ON url.id = entity1 WHERE url LIKE 'https://mora.jp%' 

       

      Valid artist link: https://mora.jp/artist/2024469/

      Artist links that should be normalized/invalid but are not:

      https://mora.jp/artist/2024469 - invalid link, returns resource not found

      https://mora.jp/artist/2024469/all - unnormalized artist link, for artist releases subpage

      https://mora.jp/artist/2024469/list - unnormalized artist link, for artist song listing subpage

      https://mora.jp/artist/2091906/h - includes extra non-existent path segment

      https://mora.jp/artist/1220246/all#discArea - includes query hash

      https://mora.jp/artist/1804177/?sortColumn=1 - includes irrelevant query parameters

      https://mora.jp/package/43000074/TCJPR0000522654_hires - not an artist link

       

      Valid recording (track) link: https://mora.jp/package/43000011/4580789718663_HD/?trackMaterialNo=39831693

      Track links that should be normalized/invalid but are not: 

      https://mora.jp/package/43000011/4538182866573/?trackMaterialNo=15503332 - normalized into https://mora.jp/package/43000011/4538182866573/ which is a release, not a recording link

       

            Assignee:
            SuperSaltyGamer
            Reporter:
            SuperSaltyGamer
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2026-01-19