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

ISE when filtering RGs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2020-06-15
    • Component/s: Data display
    • Labels:
      None

      Description

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

      ...and the (svg??) arrows in the menu disappears.

        Attachments

          Activity

            People

            Assignee:
            reosarevok Nicolás Tamargo
            Reporter:
            otringal otringal
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                2020-06-15