-
Bug
-
Resolution: Duplicate
-
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
Request data:
$VAR1 = { 'query_parameters' =>
Unknown macro: { 'filter.type_id' => '', 'filter.name' => 'magic', 'filter.artist_credit_id' => '' }, 'body_parameters' => {} };
- duplicates
-
MBS-10882 ISE when filtering RGs
- Closed