Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-12067

Beta: ISE getting relationship data for timeline leads to blank space

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • Beta
    • None
    • Statistics
    • None

      https://beta.musicbrainz.org/statistics/timeline/count.ar.links.l_area_area is empty, because it fails to load the data:

      https://beta.musicbrainz.org/statistics/timeline/type-data

      DBD::Pg::st execute failed: ERROR:  missing FROM-clause entry for table "link_type"
      LINE 1:     SELECT link_type.id,
                         ^ [for Statement "    SELECT link_type.id,
                 link_type.name,
                 link_type.parent,
                 count(l_table.id)
            FROM l_area_area l_table
      RIGHT JOIN link ON l_table.link = link.id
      RIGHT JOIN (SELECT *
                    FROM link_type
                   WHERE entity_type0 = ?
                     AND entity_type1 = ?) link_type_filtered
              ON link.link_type = link_type_filtered.id
        GROUP BY link_type_filtered.name,
                 link_type_filtered.id,
                 link_type_filtered.parent
      " with ParamValues: 1='area', 2='area'] at lib/MusicBrainz/Server/Connector.pm line 50
      Sql::select_list_of_hashes(?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/Relationship.pm line 529
      MusicBrainz::Server::Data::Relationship::get_types_for_timeline(?) called at lib/MusicBrainz/Server/Controller/Statistics.pm line 87
      Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 390
      MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 357
      MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 391
      Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 405
      Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 490
      
      

            reosarevok Nicolás Tamargo
            chaban chaban
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Beta