-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
I entered 80-1-1 as a date of birth in my profile and got
Error:
Caught exception in MusicBrainz::Server::Controller::Account->edit "Failed query:
'UPDATE editor SET country = ?, website = ?, birth_date = ?, bio = ?, gender = ? WHERE id = ?'
( http://musicbrainz.org/user/nikki 80-1-1 505754)
DBD::Pg::st execute failed: ERROR: date/time field value out of range: "80-1-1"
LINE 1: ...'http://musicbrainz.org/user/nikki', birth_date = '80-1-1', ...
^
HINT: Perhaps you need a different "datestyle" setting. at lib/Sql.pm line 107, line 3.at lib/Sql.pm line 113, line 3.
Sql::_ANON_('DBD::Pg::st execute failed: ERROR: date/time field value out...') called at local/lib/perl5/Try/Tiny.pm line 100
Try::Tiny::try('CODE(0xd4194f8)', 'Try::Tiny::Catch=REF(0xd4460d0)') called at lib/Sql.pm line 114
Sql::do('Sql=HASH(0xc7afa98)', 'UPDATE editor SET country = ?, website = ?, birth_date = ?, b...', undef, 'http://musicbrainz.org/user/nikki', '80-1-1', undef, undef, 505754) called at lib/Sql.pm line 171
Sql::update_row('Sql=HASH(0xc7afa98)', 'editor', 'HASH(0x48729b0)', 'HASH(0xd4957a0)') called at lib/MusicBrainz/Server/Data/Editor.pm line 292
MusicBrainz::Server::Data::Editor::_ANON_() called at lib/Sql.pm line 281
Sql::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 76
evalUnknown macro: {...}called at local/lib/perl5/Try/Tiny.pm line 67
Try::Tiny::try('CODE(0xd543190)', 'Try::Tiny::Catch=REF(0xd549380)') called at lib/Sql.pm line 294
Sql::_auto_transaction('CODE(0xd543160)', 'Sql=HASH(0xc7afa98)') called at lib/Sql.pm line 299
Sql::_run_in_transaction_one('CODE(0xd543160)', 'Sql=HASH(0xc7afa98)') called at lib/Sql.pm line 313
Sql::run_in_transaction('CODE(0xd543160)', 'Sql=HASH(0xc7afa98)') called at lib/MusicBrainz/Server/Data/Editor.pm line 293
MusicBrainz::Server::Data::Editor::update_profile('MusicBrainz::Server::Data::Editor=HASH(0xa988e18)', 'MusicBrainz::Server::Entity::Editor=HASH(0xccf0ac8)', 'HASH(0x5f4c2f8)') called at lib/MusicBrainz/Server/Controller/Account.pm line 299
MusicBrainz::Server::Controller::Account::edit('MusicBrainz::Server::Controller::Account=HASH(0xbb45900)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xc091270)', 'MusicBrainz::Server::Controller::Account=HASH(0xbb45900)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst.pm line 1672
evalcalled at local/lib/perl5/Catalyst.pm line 1672
Catalyst::execute('MusicBrainz::Server=HASH(0xc5ea940)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc091270)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc5ea940)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc091270)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc091270)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst/Controller.pm line 158
Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Account=HASH(0xbb45900)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xc08f870)', 'MusicBrainz::Server::Controller::Account=HASH(0xbb45900)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst.pm line 1672
evalUnknown macro: {...}called at local/lib/perl5/Catalyst.pm line 1672
Catalyst::execute('MusicBrainz::Server=HASH(0xc5ea940)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc08f870)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc5ea940)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc08f870)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc08f870)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3764dc8)', 'forward', 'MusicBrainz::Server=HASH(0xc5ea940)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3764dc8)', 'MusicBrainz::Server=HASH(0xc5ea940)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 362
Catalyst::forward('MusicBrainz::Server=HASH(0xc5ea940)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 132
Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Account=HASH(0xbb45900)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xc08f528)', 'MusicBrainz::Server::Controller::Account=HASH(0xbb45900)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst.pm line 1672
evalcalled at local/lib/perl5/Catalyst.pm line 1672
Catalyst::execute('MusicBrainz::Server=HASH(0xc5ea940)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc08f528)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc5ea940)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc08f528)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc08f528)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3764dc8)', 'forward', 'MusicBrainz::Server=HASH(0xc5ea940)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3764dc8)', 'MusicBrainz::Server=HASH(0xc5ea940)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 362
Catalyst::forward('MusicBrainz::Server=HASH(0xc5ea940)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x3764dc8)', 'MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst.pm line 1618
Catalyst::dispatch('MusicBrainz::Server=HASH(0xc5ea940)') 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(0xc5ea940)', 'CODE(0xc79d1d8)') called at lib/MusicBrainz/Server.pm line 327
Class::MOP::Class:::around('CODE(0x2b5dc70)', 'MusicBrainz::Server=HASH(0xc5ea940)') 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(0xc5ea940)') called at lib/MusicBrainz/Server.pm line 341
Class::MOP::Class:::around('CODE(0xc0c9b80)', 'MusicBrainz::Server=HASH(0xc5ea940)') 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(0xc5ea940)') called at lib/MusicBrainz/Server.pm line 386
Class::MOP::Class:::around('CODE(0xc0dd600)', 'MusicBrainz::Server=HASH(0xc5ea940)') 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(0xc5ea940)') 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(0xc5ea940)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc5ea940)') called at local/lib/perl5/Catalyst.pm line 1968
Catalyst::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 76
evalUnknown macro: {...}called at local/lib/perl5/Try/Tiny.pm line 67
Try::Tiny::try('CODE(0xc79cce0)', 'Try::Tiny::Catch=REF(0xc164fc8)') called at local/lib/perl5/Catalyst.pm line 1974
Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc5ee880)', 'response_cb', 'CODE(0xc521e58)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc5ee880)', 'response_cb', 'CODE(0xc521e58)') called at local/lib/perl5/Catalyst/Engine.pm line 688
Catalyst::Engine::_ANON_('CODE(0xc521e58)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 130
Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0xa989d0)', 'CODE(0xc104090)') called at local/lib/perl5/Plack/Loader.pm line 84
Plack::Loader::run('Plack::Loader=HASH(0x9bfc90)', 'Plack::Handler::FCGI=HASH(0xa989d0)') called at local/lib/perl5/Plack/Runner.pm line 267
Plack::Runner::run('Plack::Runner=HASH(0x848808)') called at local/bin/plackup line 10
at lib/Sql.pm line 294."
Stack trace:
line 293 MusicBrainz::Server::Data::Editor
line 299 MusicBrainz::Server::Controller::Account
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' => {},
'body_parameters' =>Unknown macro: { 'profile.birth_date.day' => '1', 'profile.website' => 'http}};
Host: astro