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