Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-4781

Entering "bogus" birth date (0-1-1) in user profile causes an exception

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: Schema change, 2012-05-15
    • Fix Version/s: Bug fixes, 2012-08-06
    • Component/s: None
    • Labels:
      None
    • Environment:
      Not relevant

      Description

      Title says all.

      Stack as follow:

      {{{
      Internal Server Error
      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::Account->edit "Failed query:
      'UPDATE editor SET country = ?, website = ?, birth_date = ?, bio = ?, gender = ? WHERE id = ?'
      (73 http://wiki.musicbrainz.org/dmppanda 0-1-1 I dig jazz.
      And discographic research.
      I dig cinema, and literature (a lot).
      Though I'm also fluent with TCP/IP, shell, js, as, c, cpp, python.

      About languages: don't mistake "basic" understanding for "I can help you with them", coz I don't 1 221793)
      DBD::Pg::st execute failed: ERROR: date/time field value out of range: "0-1-1"
      LINE 1: ...tp://wiki.musicbrainz.org/dmppanda', birth_date = '0-1-1', b...
      ^
      HINT: Perhaps you need a different "datestyle" setting. at lib/Sql.pm line 103.

      at lib/Sql.pm line 109
      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(0xd75b4a0)', 'Try::Tiny::Catch=REF(0xd8a5410)') called at lib/Sql.pm line 110
      Sql::do('Sql=HASH(0xc35a5d0)', 'UPDATE editor SET country = ?, website = ?, birth_date = ?, b...', 73, 'http://wiki.musicbrainz.org/dmppanda', '0-1-1', 'I dig jazz.
      And discographic research.
      I dig cinema, and li...', 1, 221793) called at lib/Sql.pm line 167
      Sql::update_row('Sql=HASH(0xc35a5d0)', 'editor', 'HASH(0x55772e8)', 'HASH(0xdbc8c78)') called at lib/MusicBrainz/Server/Data/Editor.pm line 327
      MusicBrainz::Server::Data::Editor::_ANON_() called at lib/Sql.pm line 277
      Sql::_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(0xd76b3f8)', 'Try::Tiny::Catch=REF(0xd6b19c8)') called at lib/Sql.pm line 290
      Sql::_auto_transaction('CODE(0xd8cfd50)', 'Sql=HASH(0xc35a5d0)') called at lib/Sql.pm line 295
      Sql::_run_in_transaction_one('CODE(0xd8cfd50)', 'Sql=HASH(0xc35a5d0)') called at lib/Sql.pm line 309
      Sql::run_in_transaction('CODE(0xd8cfd50)', 'Sql=HASH(0xc35a5d0)') called at lib/MusicBrainz/Server/Data/Editor.pm line 328
      MusicBrainz::Server::Data::Editor::update_profile('MusicBrainz::Server::Data::Editor=HASH(0xad9ea98)', 'MusicBrainz::Server::Entity::Editor=HASH(0xd0438a8)', 'HASH(0x6924bc8)') called at lib/MusicBrainz/Server/Controller/Account.pm line 298
      MusicBrainz::Server::Controller::Account::edit('MusicBrainz::Server::Controller::Account=HASH(0xbd3a698)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc10e010)', 'MusicBrainz::Server::Controller::Account=HASH(0xbd3a698)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc10e010)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc10e010)') called at lib/MusicBrainz/Server.pm line 298
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc10e010)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc10e010)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Account=HASH(0xbd3a698)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc10d620)', 'MusicBrainz::Server::Controller::Account=HASH(0xbd3a698)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc10d620)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc10d620)') called at lib/MusicBrainz/Server.pm line 298
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc10d620)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc10d620)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'forward', 'MusicBrainz::Server=HASH(0xcc042e0)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'MusicBrainz::Server=HASH(0xcc042e0)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0xcc042e0)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Account=HASH(0xbd3a698)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc2254d8)', 'MusicBrainz::Server::Controller::Account=HASH(0xbd3a698)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc2254d8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc2254d8)') called at lib/MusicBrainz/Server.pm line 298
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xcc042e0)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xc2254d8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc2254d8)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'forward', 'MusicBrainz::Server=HASH(0xcc042e0)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'MusicBrainz::Server=HASH(0xcc042e0)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0xcc042e0)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x3b84878)', 'MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst.pm line 1613
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xcc042e0)') called at lib/MusicBrainz/Server.pm line 262
      Class::MOP::Class:::around('CODE(0x3752dc0)', 'MusicBrainz::Server=HASH(0xcc042e0)') 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(0xcc042e0)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xcc042e0)') called at local/lib/perl5/Catalyst.pm line 1963
      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(0xc32ac40)', 'Try::Tiny::Catch=REF(0xcc04508)') called at local/lib/perl5/Catalyst.pm line 1969
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc325160)') called at lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc325160)') called at local/lib/perl5/Catalyst/Engine.pm line 856
      Catalyst::Engine::_ANON_('CODE(0xcbffc00)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1beda30)', 'CODE(0xc279040)') called at local/lib/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x1bb6e00)', 'Plack::Handler::FCGI=HASH(0x1beda30)') called at local/lib/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x19b9808)') called at local/bin/plackup line 10
      at lib/Sql.pm line 290"
      Stack trace:
      line 328 MusicBrainz::Server::Data::Editor
      line 298 MusicBrainz::Server::Controller::Account
      line 298 MusicBrainz::Server
      line 298 MusicBrainz::Server
      line 298 MusicBrainz::Server
      line 262 MusicBrainz::Server
      Request data:

      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' =>

      { 'profile.languages.5.language_id' => '340', 'profile.website' => 'http://wiki.musicbrainz.org/dmppanda', 'profile.languages.3.fluency' => 'basic', 'profile.country_id' => '73', 'profile.languages.1.fluency' => 'advanced', 'profile.languages.6.fluency' => 'basic', 'profile.languages.4.fluency' => 'basic', 'profile.languages.1.language_id' => '120', 'profile.languages.0.fluency' => 'native', 'profile.languages.4.language_id' => '238', 'profile.email' => 'viapanda@gmail.com', 'profile.birth_date.month' => '1', 'profile.languages.0.language_id' => '134', 'profile.languages.3.language_id' => '195', 'profile.languages.5.fluency' => 'basic', 'profile.gender_id' => '1', 'profile.languages.2.language_id' => '145', 'profile.birth_date.day' => '1', 'profile.languages.6.language_id' => '393', 'profile.birth_date.year' => '0', 'profile.biography' => 'I dig jazz. And discographic research. I dig cinema, and literature (a lot). Though I\'m also fluent with TCP/IP, shell, js, as, c, cpp, python. About languages: don\'t mistake "basic" understanding for "I can help you with them", coz I don\'t :)', 'profile.languages.2.fluency' => 'basic' }

      };

      URL: http://musicbrainz.org/account/edit

      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!

      }}}

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              mangled Olivier
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Bug fixes, 2012-08-06