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

Filtering reports gives ISE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2021-04-05
    • Component/s: Reports
    • Labels:
      None

      Description

      Internal server error on https://musicbrainz.org/report/CDTOCNotApplied?filter=1
      Referrer: [https://musicbrainz.org/report/CDTOCNotApplied

      Here is the error copied directly.|https://musicbrainz.org/report/CDTOCNotApplied]

       

      Internal Server Error

      Oops, something went wrong!

      Error:

      DBD::Pg::st execute failed: called with 3 bind variables when 2 are needed [for Statement " WITH x AS (SELECT DISTINCT report.* FROM report.cd_toc_not_applied report 100 ORDER BY row_number OFFSET ?) SELECT x.*, c.count AS total_row_count FROM x, (SELECT count(*) from x) c LIMIT ?" with ParamValues: 1=undef, 2=undef] at lib/MusicBrainz/Server/Connector.pm line 50 Sql::select_list_of_hashes(?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Data/Role/QueryToList.pm line 80 MusicBrainz::Server::Data::Role::QueryToList::query_to_list_limited(?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Report.pm line 41 MusicBrainz::Server::Report::load(?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Report/FilterForEditor.pm line 9 MusicBrainz::Server::Report::FilterForEditor::load_filtered(?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Report.pm line 45 MusicBrainz::Server::Controller::Report::ANON(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 239 MusicBrainz::Server::Controller::_load_paged(?, ?, ?) called at lib/MusicBrainz/Server/Controller/Report.pm line 58 Catalyst::dispatch called at lib/MusicBrainz/Server.pm line 390 MusicBrainz::Server::ANON_ at lib/MusicBrainz/Server.pm line 357 MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 391 Class::MOP::Method::Wrapped::_ANON called at lib/MusicBrainz/Server.pm line 405 Class::MOP::Method::Wrapped::ANON_ called at lib/MusicBrainz/Server.pm line 490

       

      Time: 2021-03-27T00:10:41.034Z

      Host: e6ee0ba41ba2

      Interface language: en

      URL: https://musicbrainz.org/report/CDTOCNotApplied?filter=1

      Request data:

      { "body_parameters": {}, "query_parameters": { "filter": "1" }

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                2021-04-05