Uploaded image for project: 'MusicBrainz Search Server'
  1. MusicBrainz Search Server
  2. SEARCH-613

Internal Server Error while using "Filter release groups" button

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Normal Normal
    • None
    • None
    • None
    • None

      I got "Internal Server Error" after putting a word into "Name" field and pressing "Filter release groups" button on "Overview" page of the artist.

      Error message:

      Error:

      42804 DBD::Pg::st execute failed: ERROR: argument of AND must be type boolean, not type integer LINE 27: ...le', mb_lower('magic')) OR rg.name = 'magic') AND 1 AND acn.... ^ [for Statement " WITH x AS (SELECT DISTINCT rg.id, rg.gid, rg.type AS primary_type_id, rg.name, rg.artist_credit AS artist_credit_id, rg.comment, rg.edits_pending, rg.last_updated, rgm.first_release_date_year, rgm.first_release_date_month, rgm.first_release_date_day, rgm.first_release_date_year, rgm.first_release_date_month, rgm.first_release_date_day, rgm.release_count, rgm.rating_count, rgm.rating, rg.name COLLATE musicbrainz AS name_collate, array( SELECT name FROM release_group_secondary_type rgst JOIN release_group_secondary_type_join rgstj ON rgstj.secondary_type = rgst.id WHERE rgstj.release_group = rg.id ORDER BY name ASC ) secondary_types FROM release_group rg JOIN release_group_meta rgm ON rgm.id = rg.id JOIN artist_credit_name acn ON acn.artist_credit = rg.artist_credit WHERE (mb_simple_tsvector(rg.name) @@ plainto_tsquery('mb_simple', mb_lower(?)) OR rg.name = ?) AND 1 AND acn.artist = ? AND (EXISTS (SELECT 1 FROM release where release.release_group = rg.id AND release.status = '1') OR NOT EXISTS (SELECT 1 FROM release where release.release_group = rg.id AND release.status IS NOT NULL)) ORDER BY rg.type, secondary_types, rgm.first_release_date_year, rgm.first_release_date_month, rgm.first_release_date_day, rg.name COLLATE musicbrainz OFFSET ?) SELECT x.*, c.count AS total_row_count FROM x, (SELECT count(*) from x) c LIMIT ?" with ParamValues: 1='magic', 2='magic', 3='192', 4='0', 5='100']

      Stack trace:

      • line

      Time: 2020-05-20 22:26:29 UTC

      Host: 813578d6a85e

      Interface language: en

      URL: https://musicbrainz.org/artist/0383dadf-2a4e-4d10-a46a-e9e041da8eb3?filter.type_id=&filter.artist_credit_id=&filter.name=magic

      Request data:

      $VAR1 = { 'query_parameters' =>

      Unknown macro: { 'filter.type_id' => '', 'filter.name' => 'magic', 'filter.artist_credit_id' => '' }

      , 'body_parameters' => {} };

            Unassigned Unassigned
            restlessdummy Stacy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package