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

Internal server error displaying relationship type edit

    XMLWordPrintable

    Details

      Description

      https://musicbrainz.org/search/edits?conditions.0.args=95&page=9&conditions.0.operator=%3D&conditions.0.field=type&order=asc&combinator=and&negation=0&field=Please+choose+a+condition&auto_edit_filter=

      Error:

      Caught exception in MusicBrainz::Server::Controller::Edit->search "DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "performer"
      LINE 4: ...phrase, is_deprecated FROM link_type WHERE id IN ('performer...
      ^ at lib/Sql.pm line 443, line 7.
      at lib/Sql.pm line 456
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: invalid input syntax for ...') called at /usr/share/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0x12a18c00)', 'Try::Tiny::Catch=REF(0x3f19d58)', 'Try::Tiny::Finally=REF(0x12894f68)') called at lib/Sql.pm line 460
      Sql::_select_list('Sql=HASH(0xe1d1860)', 'SELECT id, parent AS parent_id, gid, name, link_phrase,\x

      Unknown macro: {a}

      ...', 'ARRAY(0x128977a0)', 'hashref') called at lib/Sql.pm line 488
      Sql::select_list_of_hashes('Sql=HASH(0xe1d1860)', 'SELECT id, parent AS parent_id, gid, name, link_phrase,\x

      ...', 'performer', 'performance ', 35, 33, 7, 13, 14, ...) called at lib/MusicBrainz/Server/Data/Entity.pm line 45
      MusicBrainz::Server::Data::Entity::_get_by_keys_append_sql('MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 'id', '', 'performer', 'performance ', 35, 33, 7, 13, ...) called at lib/MusicBrainz/Server/Data/Entity.pm line 31
      MusicBrainz::Server::Data::Entity::_get_by_keys('MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 'id', 'performer', 'performance ', 35, 33, 7, 13, 14, ...) called at lib/MusicBrainz/Server/Data/Entity.pm line 77
      MusicBrainz::Server::Data::Entity::get_by_ids('MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 'performer', 'performance ', 35, 33, 7, 13, 14, 5, ...) called at lib/MusicBrainz/Server/Data/LinkType.pm line 65
      MusicBrainz::Server::Data::LinkType::get_by_ids('MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 'performer', 'performance ', 35, 33, 7, 13, 14, 5, ...) called at lib/MusicBrainz/Server/Data/Role/EntityCacheBase.pm line 22
      Class::MOP::Class:::around('CODE(0x81dd4e0)', 'MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 27, 28, 29, 30, 31, 32, 33, ...) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 27, 28, 29, 30, 31, 32, 33, 34, ...) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Data::LinkType::get_by_ids('MusicBrainz::Server::Data::LinkType=HASH(0xcbd1f30)', 27, 28, 29, 30, 31, 32, 33, 34, ...) called at lib/MusicBrainz/Server/Data/Edit.pm line 525
      MusicBrainz::Server::Data::Edit::load_all('MusicBrainz::Server::Data::Edit=HASH(0xc2a10e0)', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', 'MusicBrainz::Server::Edit::Relationship::EditLinkType=HASH(0x...', ...) called at lib/MusicBrainz/Server/Controller/Edit.pm line 203
      MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0xd575638)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd8d48d8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd575638)', 'MusicBrainz::Server=HASH(0xf663228)') 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(0xf663228)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8d48d8)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xf663228)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8d48d8)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd8d48d8)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xd575638)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd8cd8b8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd575638)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xf663228)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8cd8b8)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xf663228)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8cd8b8)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd8cd8b8)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x46a48e8)', 'forward', 'MusicBrainz::Server=HASH(0xf663228)', '_ACTION') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x46a48e8)', 'MusicBrainz::Server=HASH(0xf663228)', '_ACTION') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward('MusicBrainz::Server=HASH(0xf663228)', '_ACTION') called at /usr/share/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xd575638)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd8cd468)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd575638)', 'MusicBrainz::Server=HASH(0xf663228)') 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(0xf663228)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8cd468)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xf663228)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8cd468)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd8cd468)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x46a48e8)', 'forward', 'MusicBrainz::Server=HASH(0xf663228)', '/edit/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x46a48e8)', 'MusicBrainz::Server=HASH(0xf663228)', '/edit/_DISPATCH') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward('MusicBrainz::Server=HASH(0xf663228)', '/edit/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x46a48e8)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/share/perl5/Catalyst.pm line 1637
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xf663228)') called at lib/MusicBrainz/Server.pm line 332
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 306
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xf663228)', 'CODE(0xf62e930)') called at lib/MusicBrainz/Server.pm line 333
      Class::MOP::Class:::around('CODE(0x3aafe90)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xf663228)') called at lib/MusicBrainz/Server.pm line 347
      Class::MOP::Class:::around('CODE(0x46a47c8)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xf663228)') called at lib/MusicBrainz/Server.pm line 392
      Class::MOP::Class:::around('CODE(0xdb44ce0)', 'MusicBrainz::Server=HASH(0xf663228)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xf663228)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xf663228)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xf663228)') 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(0xf94db58)', 'Try::Tiny::Catch=REF(0xf955048)') called at /usr/share/perl5/Catalyst.pm line 1993
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xf6cd248)', 'response_cb', 'CODE(0xf6cb048)') called at /usr/share/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xf6cd248)', 'response_cb', 'CODE(0xf6cb048)') called at /usr/share/perl5/Catalyst/Engine.pm line 682
      Catalyst::Engine::_ANON_('CODE(0xf6cb048)') called at /usr/share/perl5/Starman/Server.pm line 225
      Starman::Server::process_request('Starman::Server=HASH(0x1cb34e0)') called at /usr/share/perl5/Net/Server.pm line 142
      Net::Server::run_client_connection('Starman::Server=HASH(0x1cb34e0)') 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(0x1cb34e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 229
      Net::Server::PreFork::run_n_children('Starman::Server=HASH(0x1cb34e0)', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 456
      Net::Server::PreFork::coordinate_children('Starman::Server=HASH(0x1cb34e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 357
      Net::Server::PreFork::run_parent('Starman::Server=HASH(0x1cb34e0)') called at /usr/share/perl5/Starman/Server.pm line 104
      Starman::Server::run_parent('Starman::Server=HASH(0x1cb34e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 147
      Net::Server::PreFork::loop('Starman::Server=HASH(0x1cb34e0)') called at /usr/share/perl5/Net/Server.pm line 117
      Net::Server::run('Starman::Server=HASH(0x1cb34e0)', 'port', 'ARRAY(0xdb4bc60)', 'host', 'ARRAY(0xdb4bd38)', 'proto', 'ARRAY(0xdd21a88)', 'serialize', 'flock', ...) called at /usr/share/perl5/Starman/Server.pm line 61
      Starman::Server::run('Starman::Server=HASH(0x1cb34e0)', 'CODE(0x1cba128)', 'HASH(0x1cb3468)') called at /usr/share/perl5/Plack/Handler/Starman.pm line 18
      Plack::Handler::Starman::run('Plack::Handler::Starman=HASH(0x1cb3540)', 'CODE(0x1cba128)') called at /usr/share/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x1c7d778)', 'Plack::Handler::Starman=HASH(0x1cb3540)') called at /usr/share/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x1a77898)') called at /usr/bin/starman line 31"

      Stack trace:
      line 45 MusicBrainz::Server::Data::Entity
      line 31 MusicBrainz::Server::Data::Entity
      line 77 MusicBrainz::Server::Data::Entity
      line 65 MusicBrainz::Server::Data::LinkType
      line 22 MusicBrainz::Server::Data::Role::EntityCacheBase
      line 525 MusicBrainz::Server::Data::Edit
      line 203 MusicBrainz::Server::Controller::Edit
      line 332 MusicBrainz::Server
      line 306 MusicBrainz::Server
      line 333 MusicBrainz::Server
      line 347 MusicBrainz::Server
      line 392 MusicBrainz::Server

      Request data:
      $VAR1 = {
      'query_parameters' =>

      Unknown macro: { 'conditions.0.args' => '95', 'page' => '9', 'conditions.0.operator' => '=', 'conditions.0.field' => 'type', 'order' => 'asc', 'combinator' => 'and', 'auto_edit_filter' => '', 'negation' => '0', 'field' => 'Please choose a condition' }

      ,
      'body_parameters' => {}
      };

      Host: pingu

        Attachments

          Activity

            People

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

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2014-04-14