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

Internal server error when adding search hint for places

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2013-10-28
    • None
    • None
    • None

      I opened https://musicbrainz.org/place/82403c7e-9eb1-4aac-8928-c953066e4cf9/add-alias, selected "search hint" as the type, submitted the form and got the following error.
      Copying the name to the sortname before selecting "search hint" does not help.

      Error:

      Caught exception in MusicBrainz::Server::Controller::Place->add_alias "The edit could not be created.
      POST: $VAR1 =

      Unknown macro: { 'edit-alias.edit_note' => '', 'edit-alias.as_auto_editor' => '1', 'edit-alias.type_id' => '2', 'edit-alias.name' => 'Museumsplatz' }

      ;

      Exception:$VAR1 = 'DBD::Pg::st execute failed: ERROR: null value in column "sort_name" violates not-null constraint at lib/Sql.pm line 440, line 3.
      at lib/Sql.pm line 455
      Sql::_ANON_(\'DBD::Pg::st execute failed: ERROR: null value in column "sor...\') called at /usr/share/perl5/Try/Tiny.pm line 100
      Try::Tiny::try(\'CODE(0x14238c70)\', \'Try::Tiny::Catch=REF(0x14243d98)\') called at lib/Sql.pm line 456
      Sql::_select_list(\'Sql=HASH(0xf8f6690)\', \'INSERT INTO place_alias (ended,primary_for_locale,name,place,...\', \'ARRAY(0x11526a60)\', \'arrayref\', \'CODE(0x5c367a0)\') called at lib/Sql.pm line 475
      Sql::select_list_of_lists(\'Sql=HASH(0xf8f6690)\', \'INSERT INTO place_alias (ended,primary_for_locale,name,place,...\', undef, 0, \'Museumsplatz\', 797, 2, undef, undef, ...) called at lib/Sql.pm line 408
      Sql::select_single_column_array(\'Sql=HASH(0xf8f6690)\', \'INSERT INTO place_alias (ended,primary_for_locale,name,place,...\', undef, 0, \'Museumsplatz\', 797, 2, undef, undef, ...) called at lib/Sql.pm line 423
      Sql::select_single_value(\'Sql=HASH(0xf8f6690)\', \'INSERT INTO place_alias (ended,primary_for_locale,name,place,...\', undef, 0, \'Museumsplatz\', 797, 2, undef, undef, ...) called at lib/Sql.pm line 150
      Sql::insert_row(\'Sql=HASH(0xf8f6690)\', \'place_alias\', \'HASH(0x1422b488)\', \'id\') called at lib/MusicBrainz/Server/Data/Alias.pm line 164
      MusicBrainz::Server::Data::Alias::insert(\'Moose::Meta::Class::_ANON_::SERIAL::321=HASH(0xff4c538)\', \'HASH(0x1421b720)\') called at lib/MusicBrainz/Server/Edit/Alias/Add.pm line 69
      MusicBrainz::Server::Edit::Alias::Add::insert(\'MusicBrainz::Server::Edit::Place::AddAlias=HASH(0x14141548)\') called at lib/MusicBrainz/Server/Data/Edit.pm line 436
      MusicBrainz::Server::Data::Edit::create(\'MusicBrainz::Server::Data::Edit=HASH(0xc67a478)\', \'editor_id\', 53705, \'privileges\', 441, \'entity\', \'MusicBrainz::Server::Entity::Place=HASH(0xf8a3068)\', \'primary_for_locale\', 0, ...) called at lib/MusicBrainz/Server/Controller.pm line 89
      MusicBrainz::Server::Controller::_ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x11526310)\', \'Try::Tiny::Catch=REF(0xebc3048)\') called at lib/MusicBrainz/Server/Controller.pm line 105
      MusicBrainz::Server::Controller::_insert_edit(\'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Form::Alias=HASH(0xf8fe090)\', \'edit_type\', 66, \'name\', \'Museumsplatz\', \'locale\', undef, ...) called at lib/MusicBrainz/Server/Controller.pm line 144
      MusicBrainz::Server::Controller::_ANON_() called at lib/Sql.pm line 307
      Sql::_ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76
      eval

      called at /usr/share/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x115262b0)\', \'Try::Tiny::Catch=REF(0x11526730)\') called at lib/Sql.pm line 320
      Sql::_auto_transaction(\'CODE(0xff7a2d8)\', \'Sql=HASH(0xf8f6690)\') called at lib/Sql.pm line 325
      Sql::_run_in_transaction_one(\'CODE(0xff7a2d8)\', \'Sql=HASH(0xf8f6690)\') called at lib/Sql.pm line 339
      Sql::run_in_transaction(\'CODE(0xff7a2d8)\', \'Sql=HASH(0xf8f6690)\') called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(\'MusicBrainz::Server::Model::MB=HASH(0xbf4a0c0)\', \'CODE(0xff7a2d8)\') called at lib/MusicBrainz/Server/Controller.pm line 155
      MusicBrainz::Server::Controller::edit_action(\'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\', \'form\', \'Alias\', \'form_args\', \'HASH(0x72d1a18)\', \'type\', 66, \'edit_args\', ...) called at lib/MusicBrainz/Server/Controller/Role/Alias.pm line 89
      MusicBrainz::Server::Controller::Role::Alias::add_alias(\'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xdd8db40)\', \'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Controller::Place\', \'Catalyst::Action=HASH(0xdd8db40)\') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Controller::Place\', \'Catalyst::Action=HASH(0xdd8db40)\') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xdd8db40)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch(\'Catalyst::ActionChain=HASH(0xfe1a990)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION(\'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xdd82980)\', \'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Controller::Place\', \'Catalyst::Action=HASH(0xdd82980)\') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Controller::Place\', \'Catalyst::Action=HASH(0xdd82980)\') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xdd82980)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x4b922d8)\', \'forward\', \'MusicBrainz::Server=HASH(0xec85890)\', \'_ACTION\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x4b922d8)\', \'MusicBrainz::Server=HASH(0xec85890)\', \'_ACTION\') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xec85890)\', \'_ACTION\') called at /usr/share/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH(\'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xdd82c50)\', \'MusicBrainz::Server::Controller::Place=HASH(0xd930598)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Controller::Place\', \'Catalyst::Action=HASH(0xdd82c50)\') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xec85890)\', \'MusicBrainz::Server::Controller::Place\', \'Catalyst::Action=HASH(0xdd82c50)\') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xdd82c50)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x4b922d8)\', \'forward\', \'MusicBrainz::Server=HASH(0xec85890)\', \'/place/_DISPATCH\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x4b922d8)\', \'MusicBrainz::Server=HASH(0xec85890)\', \'/place/_DISPATCH\') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xec85890)\', \'/place/_DISPATCH\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(\'Catalyst::Dispatcher=HASH(0x4b922d8)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst.pm line 1637
      Catalyst::dispatch(\'MusicBrainz::Server=HASH(0xec85890)\') called at lib/MusicBrainz/Server.pm line 330
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 304
      MusicBrainz::Server::with_translations(\'MusicBrainz::Server=HASH(0xec85890)\', \'CODE(0xedda9b0)\') called at lib/MusicBrainz/Server.pm line 331
      Class::MOP::Class:::around(\'CODE(0x3f9ee90)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xec85890)\') called at lib/MusicBrainz/Server.pm line 345
      Class::MOP::Class:::around(\'CODE(0x4b921b8)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xec85890)\') called at lib/MusicBrainz/Server.pm line 390
      Class::MOP::Class:::around(\'CODE(0xdeff7d8)\', \'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch(\'MusicBrainz::Server=HASH(0xec85890)\') called at /usr/share/perl5/Catalyst.pm line 1987
      Catalyst::_ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76
      eval

      called at /usr/share/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xf9ba400)\', \'Try::Tiny::Catch=REF(0xf723d98)\') called at /usr/share/perl5/Catalyst.pm line 1993
      Catalyst::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0xff52880)\', \'response_cb\', \'CODE(0xf7244b8)\') called at /usr/share/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0xff52880)\', \'response_cb\', \'CODE(0xf7244b8)\') called at /usr/share/perl5/Catalyst/Engine.pm line 682
      Catalyst::Engine::_ANON_(\'CODE(0xf7244b8)\') called at /usr/share/perl5/Starman/Server.pm line 225
      Starman::Server::process_request(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Net/Server.pm line 142
      Net::Server::run_client_connection(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 273
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Net/Server/PreFork.pm line 273
      Net::Server::PreFork::run_child(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 229
      Net::Server::PreFork::run_n_children(\'Starman::Server=HASH(0x21a24e0)\', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 456
      Net::Server::PreFork::coordinate_children(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 357
      Net::Server::PreFork::run_parent(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Starman/Server.pm line 104
      Starman::Server::run_parent(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 147
      Net::Server::PreFork::loop(\'Starman::Server=HASH(0x21a24e0)\') called at /usr/share/perl5/Net/Server.pm line 117
      Net::Server::run(\'Starman::Server=HASH(0x21a24e0)\', \'port\', \'ARRAY(0xdf03770)\', \'host\', \'ARRAY(0xdf03848)\', \'proto\', \'ARRAY(0xe0e0060)\', \'serialize\', \'flock\', ...) called at /usr/share/perl5/Starman/Server.pm line 61
      Starman::Server::run(\'Starman::Server=HASH(0x21a24e0)\', \'CODE(0xdf37fb8)\', \'HASH(0x21a2468)\') called at /usr/share/perl5/Plack/Handler/Starman.pm line 18
      Plack::Handler::Starman::run(\'Plack::Handler::Starman=HASH(0x21a2540)\', \'CODE(0xdf37fb8)\') called at /usr/share/perl5/Plack/Loader.pm line 88
      Plack::Loader::run(\'Plack::Loader=HASH(0x216c778)\', \'Plack::Handler::Starman=HASH(0x21a2540)\') called at /usr/share/perl5/Plack/Runner.pm line 263
      Plack::Runner::run(\'Plack::Runner=HASH(0x1f66898)\') called at /usr/bin/starman line 31
      ';
      at lib/MusicBrainz/Server/Controller.pm line 105
      at lib/Sql.pm line 320"

      Stack trace:
      line 19 MusicBrainz::Server::Model::MB
      line 155 MusicBrainz::Server::Controller
      line 89 MusicBrainz::Server::Controller::Role::Alias
      line 330 MusicBrainz::Server
      line 304 MusicBrainz::Server
      line 331 MusicBrainz::Server
      line 345 MusicBrainz::Server
      line 390 MusicBrainz::Server

      Request data:
      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' =>

      Unknown macro: { 'edit-alias.as_auto_editor' => '1', 'edit-alias.edit_note' => '', 'edit-alias.type_id' => '2', 'edit-alias.name' => 'Museumsplatz' }

      };

      Host: astro

      URL: https://musicbrainz.org/place/82403c7e-9eb1-4aac-8928-c953066e4cf9/add-alias

            acid2 Oliver Charles
            nikki nikki
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2013-10-28