-
Bug
-
Resolution: Fixed
-
Normal
-
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
evalUnknown 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
evalcalled 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
evalUnknown 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
evalcalled 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
evalUnknown 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
evalcalled 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
evalUnknown 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::ServerRequest 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