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

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

XMLWordPrintable

      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).

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

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2011-07-04