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

compassionate search error

XMLWordPrintable

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

      Internal server error on https://musicbrainz.org/artist/169c0d1b-fcb8-4a43-9097-829aa7b39205?filter.type_id=&filter.artist_credit_id=&filter.name=free+jazz
      Referrer: https://musicbrainz.org/artist/169c0d1b-fcb8-4a43-9097-829aa7b39205

       

      Internal Server Error

      Oops, something went wrong!

      Error:

       

      42804 DBD::Pg::st execute failed: ERROR: argument of AND must be type boolean, not type integer LINE 27: ...lower('free jazz')) OR rg.name = 'free jazz') 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='free jazz', 2='free jazz', 3='38551', 4='0', 5='100']

       

       

      Stack trace:

      • line

       

      Time: 2020-06-01 07:40:31 UTC

      Host: d95010daaafe

      Interface language: en

      URL: https://musicbrainz.org/artist/169c0d1b-fcb8-4a43-9097-829aa7b39205?filter.type_id=&filter.artist_credit_id=&filter.name=free+jazz

      Request data:

      $VAR1 = { 'query_parameters' =>

      { 'filter.artist_credit_id' => '', 'filter.name' => 'free jazz', 'filter.type_id' => '' }

      , 'body_parameters' => {} };

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

              Created:
              Updated:
              Resolved:

                Version Package