Issue Details (XML | Word | Printable)

Key: MBS-3808
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Unassigned
Reporter: Frederic Da Vitoria
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

Internal server error searching for edits

Created: 23/Nov/11 01:08 PM   Updated: 05/Dec/11 04:07 PM   Resolved: 05/Dec/11 04:07 PM
Component/s: Search
Affects Version/s: None
Fix Version/s: Bug fixes, 2011-12-05


 Description  « Hide

when searching for edits on Artist Worship Jamz Red, I get an Internal Server Error

Internal Server Error

Oops, something went wrong!

Error:

Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist1 ON edit_artist1.edit = edit.id WHERE ((edit_artist1.artist = ?))
ORDER BY open_time desc
LIMIT 500 OFFSET ?'
( 0)
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: ""
LINE 1: ...t_artist1.edit = edit.id WHERE ((edit_artist1.artist = ''))
^ 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: invalid input syntax for ...') called at /usr/local/share/perl-astro/perl/5.10.1//Try/Tiny.pm line 100
Try::Tiny::try('CODE(0x75955b8)', 'Try::Tiny::Catch=REF(0xbe2ab90)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 86
Sql::select('Sql=HASH(0x9bb4430)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', '', 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(0x9bb4430)', 0, 25, 'CODE(0xbdedef0)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', '', 0) 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(0x80b9760)', 'MusicBrainz::Server::EditSearch::Query=HASH(0x75953c0)', 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(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)', 'CODE(0xbe2b070)') 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(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0x9712570)', 'MusicBrainz::Server::Controller::Edit=HASH(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
eval {...} called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xa4a4788)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x9712570)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xa4a4788)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x9712570)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9712570)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Controller.pm line 110
Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0x9716a18)', 'MusicBrainz::Server::Controller::Edit=HASH(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
eval {...} called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xa4a4788)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x9716a18)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xa4a4788)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x9716a18)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9716a18)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1e68738)', 'forward', 'MusicBrainz::Server=HASH(0xa4a4788)', '_ACTION') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1e68738)', 'MusicBrainz::Server=HASH(0xa4a4788)', '_ACTION') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 377
Catalyst::forward('MusicBrainz::Server=HASH(0xa4a4788)', '_ACTION') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Controller.pm line 84
Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0x970a530)', 'MusicBrainz::Server::Controller::Edit=HASH(0x94192f8)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
eval {...} called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
Catalyst::execute('MusicBrainz::Server=HASH(0xa4a4788)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x970a530)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xa4a4788)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x970a530)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0x970a530)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1e68738)', 'forward', 'MusicBrainz::Server=HASH(0xa4a4788)', '/edit/_DISPATCH') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1e68738)', 'MusicBrainz::Server=HASH(0xa4a4788)', '/edit/_DISPATCH') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 377
Catalyst::forward('MusicBrainz::Server=HASH(0xa4a4788)', '/edit/_DISPATCH') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x1e68738)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1611
Catalyst::dispatch('MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/Static/Simple.pm line 76
Class::MOP::Class:::around('CODE(0x24cb880)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/lib/perl-astro/perl/5.10.1//Class/MOP/Method/Wrapped.pm line 159
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xa4a4788)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 273
Class::MOP::Class:::around('CODE(0x99b31b0)', 'MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/lib/perl-astro/perl/5.10.1//Class/MOP/Method/Wrapped.pm line 159
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/lib/perl-astro/perl/5.10.1//Class/MOP/Method/Wrapped.pm line 89
MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xa4a4788)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1952
eval {...} called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1943
Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x32492d0)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/AutoRestart.pm line 114
Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x32492d0)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Engine/FastCGI.pm line 149
Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x3216070)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0xd3fd48)') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 2396
Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0xd3fd48)') called at ./script/musicbrainz_fastcgi.pl line 28"

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::Server

Request data:

$VAR1 = {
'query_parameters' => { 'conditions.0.operator' => '=', 'conditions.0.field' => 'artist', 'conditions.0.name' => 'Worship Jamz Red', 'conditions.0.args.0' => '', 'order' => 'desc', 'conditions.0.user_id' => '189467', 'combinator' => 'and', 'field' => 'Please choose a condition', 'auto_edit_filter' => '', 'negation' => '0' },
'body_parameters' => {}
};

URL: http://musicbrainz.org/search/edits?order=desc&auto_edit_filter=&negation=0&combinator=and&conditions.0.field=artist&conditions.0.operator=%3D&conditions.0.name=Worship+Jamz+Red&conditions.0.args.0=&conditions.0.user_id=189467&field=Please+choose+a+condition

We're terribly sorry for this problem. Please wait a few minutes and repeat your request — the problem may go away.

If the problem persists, please report a bug and include any error message that is shown above.

Please be sure to include the stack trace and request data shown above!

Donate | Wiki | Forums | Bug Tracker | Twitter | Schwag

Hosted by Digital West. Sponsored by: Google, OSUOSL and others...



Sort Order: Ascending order - Click to sort in descending order
Oliver Charles added a comment - 05/Dec/11 04:07 PM

Fixed in ef300670a. It seems like you didn't actually select a result (you just entered an artist name).