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

ISE when searching for edits within a specific artist country

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Normal Normal
    • None
    • Schema change, 2013-05-15
    • None
    • None

       
      Error:
      
      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(0x124801b8) 0)
      DBD::Pg::st execute failed: ERROR:  column artist_2.country does not exist
      LINE 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 local/lib/perl5/Try/Tiny.pm line 100
      	Try::Tiny::try('CODE(0x6f42f48)', 'Try::Tiny::Catch=REF(0x1247ff90)') called at lib/Sql.pm line 90
      	Sql::select('Sql=HASH(0x12971d58)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', 'ARRAY(0x124801b8)', 0) called at lib/MusicBrainz/Server/Data/Utils.pm line 230
      	MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0x12971d58)', 0, 25, 'CODE(0x1247fee8)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', 'ARRAY(0x124801b8)', 0) called at lib/MusicBrainz/Server/Data/Edit.pm line 75
      	MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0xc61bfe0)', 'MusicBrainz::Server::EditSearch::Query=HASH(0x12480260)', 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(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)', 'CODE(0xed2f610)') called at lib/MusicBrainz/Server/Controller/Edit.pm line 201
      	MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst/Action.pm line 65
      	Catalyst::Action::execute('Catalyst::Action=HASH(0xdb2fe88)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst.pm line 1672
      	eval {...} called at local/lib/perl5/Catalyst.pm line 1672
      	Catalyst::execute('MusicBrainz::Server=HASH(0xedda330)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdb2fe88)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      	Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xedda330)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdb2fe88)') called at local/lib/perl5/Catalyst/Action.pm line 60
      	Catalyst::Action::dispatch('Catalyst::Action=HASH(0xdb2fe88)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst/Controller.pm line 158
      	Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst/Action.pm line 65
      	Catalyst::Action::execute('Catalyst::Action=HASH(0xda14178)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst.pm line 1672
      	eval {...} called at local/lib/perl5/Catalyst.pm line 1672
      	Catalyst::execute('MusicBrainz::Server=HASH(0xedda330)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xda14178)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      	Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xedda330)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xda14178)') called at local/lib/perl5/Catalyst/Action.pm line 60
      	Catalyst::Action::dispatch('Catalyst::Action=HASH(0xda14178)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      	Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x50f8c40)', 'forward', 'MusicBrainz::Server=HASH(0xedda330)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      	Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x50f8c40)', 'MusicBrainz::Server=HASH(0xedda330)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 362
      	Catalyst::forward('MusicBrainz::Server=HASH(0xedda330)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 132
      	Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst/Action.pm line 65
      	Catalyst::Action::execute('Catalyst::Action=HASH(0xdb246d8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd7b0640)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst.pm line 1672
      	eval {...} called at local/lib/perl5/Catalyst.pm line 1672
      	Catalyst::execute('MusicBrainz::Server=HASH(0xedda330)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdb246d8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      	Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xedda330)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xdb246d8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      	Catalyst::Action::dispatch('Catalyst::Action=HASH(0xdb246d8)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      	Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x50f8c40)', 'forward', 'MusicBrainz::Server=HASH(0xedda330)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      	Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x50f8c40)', 'MusicBrainz::Server=HASH(0xedda330)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 362
      	Catalyst::forward('MusicBrainz::Server=HASH(0xedda330)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      	Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x50f8c40)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst.pm line 1618
      	Catalyst::dispatch('MusicBrainz::Server=HASH(0xedda330)') 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(0xedda330)', 'CODE(0xe4b2b00)') called at lib/MusicBrainz/Server.pm line 327
      	Class::MOP::Class:::around('CODE(0x44da168)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xedda330)') called at lib/MusicBrainz/Server.pm line 341
      	Class::MOP::Class:::around('CODE(0xdd905d0)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xedda330)') called at lib/MusicBrainz/Server.pm line 386
      	Class::MOP::Class:::around('CODE(0xdda91f8)', 'MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      	MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xedda330)') called at local/lib/perl5/Catalyst.pm line 1968
      	Catalyst::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0xec87f88)', 'Try::Tiny::Catch=REF(0xeff5318)') called at local/lib/perl5/Catalyst.pm line 1974
      	Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xec9e398)', 'response_cb', 'CODE(0xe35abc0)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      	Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xec9e398)', 'response_cb', 'CODE(0xe35abc0)') called at local/lib/perl5/Catalyst/Engine.pm line 688
      	Catalyst::Engine::__ANON__('CODE(0xe35abc0)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 130
      	Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x2412a28)', 'CODE(0xddaea18)') called at local/lib/perl5/Plack/Loader.pm line 84
      	Plack::Loader::run('Plack::Loader=HASH(0x2339de8)', 'Plack::Handler::FCGI=HASH(0x2412a28)') called at local/lib/perl5/Plack/Runner.pm line 267
      	Plack::Runner::run('Plack::Runner=HASH(0x21c2850)') called at 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
      
      Request data:
      
      $VAR1 = {
                'query_parameters' => {
                                        'conditions.0.args' => '105',
                                        'conditions.0.operator' => '=',
                                        'conditions.0.field' => 'artist_country',
                                        'order' => 'desc',
                                        'combinator' => 'and',
                                        'auto_edit_filter' => '',
                                        'negation' => '0',
                                        'field' => 'Please choose a condition'
                                      },
                'body_parameters' => {}
              };
                  
      
      Host: asterix
      
      URL: http://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=105&field=Please+choose+a+condition
      

            Unassigned Unassigned
            salo.rock salo.rock
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package