-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
-
None
It's probably clear from the error message what I did, but anyway:
- start an edit search where
- one condition is "Editor is $foo"
- the second condition is "my vote is not no vote"
run it.
Internal Server Error
Oops, something went wrong!
Error:
Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
'SELECT DISTINCT edit.* FROM edit WHERE ((EXISTS (
SELECT TRUE FROM vote
WHERE vote.editor = ?
AND vote.superseded = FALSE
AND vote.vote = any
AND vote.edit = edit.id
)) and (edit.editor = ?))
ORDER BY open_time desc
LIMIT 500 OFFSET ?'
(495303 -1 0 1 17630 0)
DBD::Pg::st execute failed: called with 6 bind variables when 4 are needed 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: called with 6 bind variables when...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
Try::Tiny::try('CODE(0xde8fb48)', 'Try::Tiny::Catch=REF(0xde8f140)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 86
Sql::select('Sql=HASH(0xaa34b20)', 'SELECT DISTINCT edit.* FROM edit WHERE ((EXISTS (
S...', 495303, -1, 0, 1, 17630, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Utils.pm line 204
MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0xaa34b20)', 0, 25, 'CODE(0xde5db30)', 'SELECT DISTINCT edit.* FROM edit WHERE ((EXISTS (
S...', 495303, -1, 0, 1, ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 72
MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0x8f636e0)', 'MusicBrainz::Server::EditSearch::Query=HASH(0xde8fcb0)', 25, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Edit.pm line 189
MusicBrainz::Server::Controller::Edit::_ANON_(25, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 157
MusicBrainz::Server::Controller::_load_paged('MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)', 'CODE(0xde3d310)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Edit.pm line 190
MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xa5a3f50)', 'MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
evalUnknown macro: {...}called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xc53ab10)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xa5a3f50)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc53ab10)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xa5a3f50)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xa5a3f50)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xa5a7498)', 'MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
evalcalled at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xc53ab10)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xa5a7498)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc53ab10)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xa5a7498)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xa5a7498)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x2d7fcb8)', 'forward', 'MusicBrainz::Server=HASH(0xc53ab10)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x2d7fcb8)', 'MusicBrainz::Server=HASH(0xc53ab10)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
Catalyst::forward('MusicBrainz::Server=HASH(0xc53ab10)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xa59bbd0)', 'MusicBrainz::Server::Controller::Edit=HASH(0xa2b5278)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
evalUnknown macro: {...}called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xc53ab10)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xa59bbd0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc53ab10)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xa59bbd0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xa59bbd0)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x2d7fcb8)', 'forward', 'MusicBrainz::Server=HASH(0xc53ab10)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x2d7fcb8)', 'MusicBrainz::Server=HASH(0xc53ab10)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
Catalyst::forward('MusicBrainz::Server=HASH(0xc53ab10)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x2d7fcb8)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
Catalyst::dispatch('MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
Class::MOP::Class:::around('CODE(0x33da6c0)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xc53ab10)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 273
Class::MOP::Class:::around('CODE(0xa839e28)', 'MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc53ab10)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952
evalcalled at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943
Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x413e550)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119
Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x413e550)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x410b770)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x1c6dd48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x1c6dd48)') called at ./script/musicbrainz_fastcgi.pl line 37"Stack trace:
line 204 MusicBrainz::Server::Data::Utils
line 72 MusicBrainz::Server::Data::Edit
line 189 MusicBrainz::Server::Controller::Edit
line 157 MusicBrainz::Server::Controller
line 190 MusicBrainz::Server::Controller::Edit
line 273 MusicBrainz::ServerRequest data:
$VAR1 = {
'query_parameters' =>Unknown macro: { 'conditions.0.args' => 'no', 'conditions.1.name' => 'PootieTang', 'conditions.1.field' => 'editor', 'conditions.0.operator' => '!=', 'conditions.0.voter_id' => '495303', 'conditions.1.args.0' => '17630', 'conditions.0.field' => 'vote', 'order' => 'desc', 'combinator' => 'and', 'field' => 'Please choose a condition', 'conditions.1.operator' => '=', 'auto_edit_filter' => '', 'negation' => '0' },
'body_parameters' => {}
};