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

Error when editing URL into one that already exists

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug fixes, 2011-11-21
    • Component/s: Edit system
    • Labels:
      None

      Description

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

      { 'edit-url.as_auto_editor' => '1', 'edit-url.description' => '', 'edit-url.url' => 'http://example.com/', 'edit-url.edit_note' => '' }

      ;

      Exception:$VAR1 = 'Failed query:
      \'INSERT INTO url_gid_redirect (gid, new_id) VALUES \'
      ()
      DBD::Pg::st execute failed: ERROR: syntax error at end of input
      LINE 1: INSERT INTO url_gid_redirect (gid, new_id) VALUES
      ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 103.

      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 109
      Sql::_ANON_(\'DBD::Pg::st execute failed: ERROR: syntax error at end of in...\') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try(\'CODE(0xd4b89d0)\', \'Try::Tiny::Catch=REF(0xd4bdb18)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 110
      Sql::do(\'Sql=HASH(0x9da5540)\', \'INSERT INTO url_gid_redirect (gid, new_id) VALUES \') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/CoreEntity.pm line 115
      MusicBrainz::Server::Data::CoreEntity::add_gid_redirects(\'MusicBrainz::Server::Data::URL=HASH(0xa047248)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/CoreEntity.pm line 141
      MusicBrainz::Server::Data::CoreEntity::_delete_and_redirect_gids(\'MusicBrainz::Server::Data::URL=HASH(0xa047248)\', \'url\', 866107, 9333) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/URL.pm line 77
      MusicBrainz::Server::Data::URL::_merge_impl(\'MusicBrainz::Server::Data::URL=HASH(0xa047248)\', 866107, 9333) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Role/Merge.pm line 30
      Class::MOP::Class:::around(\'CODE(0x6637750)\', \'MusicBrainz::Server::Data::URL=HASH(0xa047248)\', 866107, 9333) called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server::Data::URL=HASH(0xa047248)\', 866107, 9333) called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::Data::URL::merge(\'MusicBrainz::Server::Data::URL=HASH(0xa047248)\', 866107, 9333) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/URL.pm line 87
      MusicBrainz::Server::Data::URL::update(\'MusicBrainz::Server::Data::URL=HASH(0xa047248)\', 9333, \'HASH(0xd489270)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Edit/URL/Edit.pm line 85
      Class::MOP::Class:::around(\'CODE(0xbfd9bc0)\', \'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::Edit::URL::Edit::accept(\'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 507
      MusicBrainz::Server::Data::Edit::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 71
      eval

      {...} called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xd46ddf8)\', \'Try::Tiny::Catch=REF(0xd489ea0)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 533
      MusicBrainz::Server::Data::Edit::_do_accept(\'MusicBrainz::Server::Data::Edit=HASH(0x82c5988)\', \'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 572
      MusicBrainz::Server::Data::Edit::_ANON_(\'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 599
      MusicBrainz::Server::Data::Edit::_close(\'MusicBrainz::Server::Data::Edit=HASH(0x82c5988)\', \'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\', \'CODE(0xd484d68)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 572
      MusicBrainz::Server::Data::Edit::accept(\'MusicBrainz::Server::Data::Edit=HASH(0x82c5988)\', \'MusicBrainz::Server::Edit::URL::Edit=HASH(0xd489c00)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 421
      MusicBrainz::Server::Data::Edit::_ANON_() called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 264
      Sql::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
      eval {...}

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xd484918)\', \'Try::Tiny::Catch=REF(0xd459ea8)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277
      Sql::_auto_transaction(\'CODE(0xd371848)\', \'Sql=HASH(0x9da5540)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 282
      Sql::_run_in_transaction_one(\'CODE(0xd371848)\', \'Sql=HASH(0x9da5540)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 296
      Sql::run_in_transaction(\'CODE(0xd371848)\', \'Sql=HASH(0x9da5540)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 426
      MusicBrainz::Server::Data::Edit::create(\'MusicBrainz::Server::Data::Edit=HASH(0x82c5988)\', \'editor_id\', 53705, \'privileges\', 41, \'url\', \'http://example.com/\', \'edit_type\', 101, ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 83
      MusicBrainz::Server::Controller::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
      eval

      {...} called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xbd62b20)\', \'Try::Tiny::Catch=REF(0xbd62a90)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 99
      MusicBrainz::Server::Controller::_insert_edit(\'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Form::URL=HASH(0xb5e1b68)\', \'edit_type\', 101, \'url\', \'http://example.com/\', \'description\', undef, ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 132
      MusicBrainz::Server::Controller::edit_action(\'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\', \'form\', \'URL\', \'type\', 101, \'item\', \'MusicBrainz::Server::Entity::URL=HASH(0xbd68950)\', \'edit_args\', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Role/Edit.pm line 37
      Moose::Meta::Role::_ANON_::SERIAL::3::edit(\'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0x9837eb0)\', \'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      eval {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Controller::URL\', \'Catalyst::Action=HASH(0x9837eb0)\') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Controller::URL\', \'Catalyst::Action=HASH(0x9837eb0)\') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0x9837eb0)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/ActionChain.pm line 39
      Catalyst::ActionChain::dispatch(\'Catalyst::ActionChain=HASH(0xbd10180)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
      Catalyst::Controller::_ACTION(\'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0x98381c8)\', \'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      eval

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Controller::URL\', \'Catalyst::Action=HASH(0x98381c8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Controller::URL\', \'Catalyst::Action=HASH(0x98381c8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0x98381c8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x20ee820)\', \'forward\', \'MusicBrainz::Server=HASH(0xbe509e8)\', \'_ACTION\') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x20ee820)\', \'MusicBrainz::Server=HASH(0xbe509e8)\', \'_ACTION\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'_ACTION\') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
      Catalyst::Controller::_DISPATCH(\'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0x98307d0)\', \'MusicBrainz::Server::Controller::URL=HASH(0x96097b8)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      eval {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Controller::URL\', \'Catalyst::Action=HASH(0x98307d0)\') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'MusicBrainz::Server::Controller::URL\', \'Catalyst::Action=HASH(0x98307d0)\') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0x98307d0)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x20ee820)\', \'forward\', \'MusicBrainz::Server=HASH(0xbe509e8)\', \'/url/_DISPATCH\') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x20ee820)\', \'MusicBrainz::Server=HASH(0xbe509e8)\', \'/url/_DISPATCH\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xbe509e8)\', \'/url/_DISPATCH\') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(\'Catalyst::Dispatcher=HASH(0x20ee820)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
      Catalyst::dispatch(\'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
      Class::MOP::Class:::around(\'CODE(0x274b5e0)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xbe509e8)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 273
      Class::MOP::Class:::around(\'CODE(0x9b99460)\', \'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::dispatch(\'MusicBrainz::Server=HASH(0xbe509e8)\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952
      eval

      {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943
      Catalyst::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0x34b06e0)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0x34b06e0)\') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
      Catalyst::Engine::FastCGI::run(\'Catalyst::Engine::FastCGI=HASH(0x347b6a0)\', \'MusicBrainz::Server\', \'127.0.0.1:55901\', \'HASH(0xfd8d48)\') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
      Catalyst::run(\'MusicBrainz::Server\', \'127.0.0.1:55901\', \'HASH(0xfd8d48)\') called at ./script/musicbrainz_fastcgi.pl line 28
      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277
      ';
      at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 99"

      Stack trace:
      line 95 MusicBrainz::Server::Controller
      line 99 MusicBrainz::Server::Controller
      line 132 MusicBrainz::Server::Controller
      line 37 MusicBrainz::Server::Controller::Role::Edit
      line 273 MusicBrainz::Server

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

      { 'edit-url.as_auto_editor' => '1', 'edit-url.description' => '', 'edit-url.url' => 'http://example.com/', 'edit-url.edit_note' => '' }

      };

      URL: http://musicbrainz.org/url/c8ea75c1-6e70-45bd-b86b-04ed06fe03b7/edit

        Attachments

          Activity

            People

            • Assignee:
              acid2 Oliver Charles
              Reporter:
              nikki nikki
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Bug fixes, 2011-11-21