-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
After search for e.g. edits where "My Vote" is "No":
http://musicbrainz.org/search/edits?order=desc&auto_edit_filter=&negation=0&combinator=and&conditions.0.field=vote&conditions.0.operator=%3D&conditions.0.voter_id=314771&conditions.0.args=0&field=Please+choose+a+condition
The selection box (Yes/No/Abstain/No vote) is unselected. This is only a minor bug, but when searching again with this setting, this error happens:
Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
'SELECT edit.* FROM edit WHERE ()
ORDER BY open_time desc
LIMIT 500 OFFSET ?'
(0)
DBD::Pg::st execute failed: ERROR: syntax error at or near ")"
LINE 1: SELECT edit.* FROM edit WHERE ()
^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.
at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 84
Sql::_ANON_('DBD::Pg::st execute failed: ERROR: syntax error at or near "...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
Try::Tiny::try('CODE(0xc2c4480)', 'Try::Tiny::Catch=REF(0xc2c47c8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 86
Sql::select('Sql=HASH(0x992cde8)', 'SELECT edit.* FROM edit WHERE ()
ORDER BY open_tim...', 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Utils.pm line 231
MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0x992cde8)', 0, 25, 'CODE(0xc2c3ee0)', 'SELECT edit.* FROM edit WHERE ()
ORDER BY open_tim...', 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 71
MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0x7ff0670)', 'MusicBrainz::Server::EditSearch::Query=HASH(0xc2f1788)', 25, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Edit.pm line 172
MusicBrainz::Server::Controller::Edit::_ANON_(25, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 153
MusicBrainz::Server::Controller::_load_paged('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)', 'CODE(0xc2c4510)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Edit.pm line 173
MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0x94cb868)', 'MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
eval
Catalyst::execute('MusicBrainz::Server=HASH(0xad87bb0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cb868)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xad87bb0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cb868)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0x94cb868)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0x94cc240)', 'MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
eval {...}
called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xad87bb0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cc240)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xad87bb0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cc240)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0x94cc240)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'forward', 'MusicBrainz::Server=HASH(0xad87bb0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'MusicBrainz::Server=HASH(0xad87bb0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
Catalyst::forward('MusicBrainz::Server=HASH(0xad87bb0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0x94c23e0)', 'MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
eval
Catalyst::execute('MusicBrainz::Server=HASH(0xad87bb0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94c23e0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xad87bb0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94c23e0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0x94c23e0)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'forward', 'MusicBrainz::Server=HASH(0xad87bb0)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'MusicBrainz::Server=HASH(0xad87bb0)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
Catalyst::forward('MusicBrainz::Server=HASH(0xad87bb0)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x1ad4940)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
Catalyst::dispatch('MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
Class::MOP::Class:::around('CODE(0x21333a0)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xad87bb0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 270
Class::MOP::Class:::around('CODE(0x9754040)', 'MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xad87bb0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952
eval {...}
called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943
Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x2e8e990)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119
Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x2e8e990)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x2e594f0)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x9c0d48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x9c0d48)') called at ./script/musicbrainz_fastcgi.pl line 28"
Stack trace:
line 231 MusicBrainz::Server::Data::Utils
line 71 MusicBrainz::Server::Data::Edit
line 172 MusicBrainz::Server::Controller::Edit
line 153 MusicBrainz::Server::Controller
line 173 MusicBrainz::Server::Controller::Edit
line 270 MusicBrainz::Server
Request data:
$VAR1 = {
'query_parameters' =>
,
'body_parameters' => {}
};