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

Stack trace requesting /ws/2/collection when user has no collections

    XMLWordPrintable

    Details

      Description

      Request http://test.musicbrainz.org/ws/2/collection using the credentials of an account with no collections, and it will give a stack trace.

      Caught exception in MusicBrainz::Server::Controller::WS::2::Collection->list_list "Failed query:
      'SELECT id, coalesce(
      (SELECT count(release)
      FROM editor_collection_release
      WHERE collection = col.id), 0)
      FROM (
      VALUES
      ) col (id)'
      ()
      DBD::Pg::st execute failed: ERROR: syntax error at or near ")"
      LINE 7: ) col (id)
      ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.

      I haven't tested if this also happens on the main server (I don't have any alt accounts).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                acid2 Oliver Charles
                Reporter:
                bitmap Michael Wiencek
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Bug fixes, 2011-07-04