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

Crash when changing conditions in edit search

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • Bug fixes, 2011-08-15
    • Bug fixes, 2011-07-04
    • Search
    • None

      To reproduce:

      1. Open http://musicbrainz.org/search/edits
      2. Select "Type" "is" "Add medium"
      3. Click "Search"
      4. Change the condition without removing it (so don't click the red X), I use "Artist" "is" "Cycles".

      This results in "Internal Server Error" on production.

      On test.musicbrainz.org I get the following exception:

      Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
      'SELECT edit.* FROM edit WHERE () LIMIT 500 OFFSET ?'
      (0)
      DBD::Pg::st execute failed: ERROR: syntax error at or near ")"
      LINE 1: SELECT edit.* FROM edit WHERE () LIMIT 500 OFFSET '0'
      ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.

            acid2 Oliver Charles
            warp Kuno Woudt
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2011-08-15