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

Internal server error searching for countries in edits

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2013-05-27
    • None
    • None
    • None

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
      'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist_1 ON edit_artist_1.edit = edit.id JOIN artist artist_2 ON artist_2.id = edit_artist_1.artist WHERE ((artist_2.country = any))
      ORDER BY edit.open_time desc, edit.id desc
      LIMIT 500 OFFSET ?'
      (ARRAY(0x12454180) 0)
      DBD::Pg::st execute failed: ERROR: column artist_2.country does not exist
      ZEILE 1: ..._2 ON artist_2.id = edit_artist_1.artist WHERE ((artist_2.c...
      ^ at lib/Sql.pm line 83, line 3.

      at lib/Sql.pm line 88, line 3.
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: column artist_2.country d...') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0x7095cf0)', 'Try::Tiny::Catch=REF(0x1341fd58)') called at lib/Sql.pm line 90
      Sql::select('Sql=HASH(0x13c310a8)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', 'ARRAY(0x12454180)', 0) called at lib/MusicBrainz/Server/Data/Utils.pm line 230
      MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0x13c310a8)', 0, 25, 'CODE(0x1263bda8)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', 'ARRAY(0x12454180)', 0) called at lib/MusicBrainz/Server/Data/Edit.pm line 75
      MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0xc836598)', 'MusicBrainz::Server::EditSearch::Query=HASH(0x136dc128)', 25, 0) called at lib/MusicBrainz/Server/Controller/Edit.pm line 200
      MusicBrainz::Server::Controller::Edit::_ANON_(25, 0) called at lib/MusicBrainz/Server/Controller.pm line 202
      MusicBrainz::Server::Controller::_load_paged('MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)', 'CODE(0xea80ce0)') called at lib/MusicBrainz/Server/Controller/Edit.pm line 201
      MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xdda3e28)', 'MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0x130c8e08)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdda3e28)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x130c8e08)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdda3e28)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xdda3e28)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xdda0458)', 'MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0x130c8e08)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdda0458)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x130c8e08)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdda0458)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xdda0458)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x517eed0)', 'forward', 'MusicBrainz::Server=HASH(0x130c8e08)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x517eed0)', 'MusicBrainz::Server=HASH(0x130c8e08)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0x130c8e08)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xdd997d8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xda18860)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0x130c8e08)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdd997d8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x130c8e08)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdd997d8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xdd997d8)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x517eed0)', 'forward', 'MusicBrainz::Server=HASH(0x130c8e08)', '/edit/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x517eed0)', 'MusicBrainz::Server=HASH(0x130c8e08)', '/edit/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0x130c8e08)', '/edit/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x517eed0)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch('MusicBrainz::Server=HASH(0x130c8e08)') called at lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 300
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0x130c8e08)', 'CODE(0x130c3828)') called at lib/MusicBrainz/Server.pm line 327
      Class::MOP::Class:::around('CODE(0x4520f20)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0x130c8e08)') called at lib/MusicBrainz/Server.pm line 341
      Class::MOP::Class:::around('CODE(0xe004f78)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0x130c8e08)') called at lib/MusicBrainz/Server.pm line 386
      Class::MOP::Class:::around('CODE(0xe01bd48)', 'MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0x130c8e08)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1968
      Catalyst::_ANON_() called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 76
      eval

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0x133a6008)', 'Try::Tiny::Catch=REF(0x131484a0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x125aeec8)', 'response_cb', 'CODE(0x1229afc8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x125aeec8)', 'response_cb', 'CODE(0x1229afc8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_('CODE(0x1229afc8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Handler/FCGI.pm line 130
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x238beb8)', 'CODE(0xe023250)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run('Plack::Loader=HASH(0x22b3290)', 'Plack::Handler::FCGI=HASH(0x238beb8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Runner.pm line 267
      Plack::Runner::run('Plack::Runner=HASH(0x2135700)') called at /home/beta/musicbrainz-server/admin/../local/bin/plackup line 10"

      Stack-Trace:
      line 230 MusicBrainz::Server::Data::Utils
      line 75 MusicBrainz::Server::Data::Edit
      line 200 MusicBrainz::Server::Controller::Edit
      line 202 MusicBrainz::Server::Controller
      line 201 MusicBrainz::Server::Controller::Edit
      line 326 MusicBrainz::Server
      line 300 MusicBrainz::Server
      line 327 MusicBrainz::Server
      line 341 MusicBrainz::Server
      line 386 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' => {
      'conditions.0.args' => '1',
      'conditions.0.operator' => '=',
      'conditions.0.field' => 'artist_country',
      'order' => 'desc',
      'combinator' => 'and',
      'auto_edit_filter' => '',
      'negation' => '0',
      'field' => "Bitte w\x

      Unknown macro: {e4}

      hle eine Bedingung"
      },
      'body_parameters' => {}
      };

      Host: pino

      Oberflächensprache: de

      URL: https://beta.musicbrainz.org/search/edits?auto_edit_filter=&order=desc&negation=0&combinator=and&conditions.0.field=artist_country&conditions.0.operator=%3D&conditions.0.args=1&field=Bitte+w%C3%A4hle+eine+Bedingung

            ianmcorvidae Ian McEwen
            nikki nikki
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2013-05-27