-
Bug
-
Resolution: Duplicate
-
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
- duplicates
-
MBS-6306 Internal server error searching for countries in edits
- Closed