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

Internal Server Error in edit search (Artist is in my subscriptions / Status Open)

XMLWordPrintable

      Internal Server Error

      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
      'SELECT edit.* FROM edit JOIN edit_artist edit_artist1 ON edit_artist1.edit = edit.id JOIN editor_subscribe_artist editor_subscribe_artist2 ON editor_subscribe_artist2.artist = edit_artist1.artist WHERE ((status = any) and (editor_subscribe_artist2.editor = ?))
      ORDER BY open_time desc
      LIMIT 500 OFFSET ?'
      (ARRAY(0xcdfbce8) 314771 0)
      DBD::Pg::st execute failed: ERROR: column reference "status" is ambiguous
      LINE 1: ...ibe_artist2.artist = edit_artist1.artist WHERE ((status = a...
      ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.

      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 84
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: column reference "status"...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xcdfbca0)', 'Try::Tiny::Catch=REF(0xce2bd38)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 86
      Sql::select('Sql=HASH(0x9939d18)', 'SELECT edit.* FROM edit JOIN edit_artist edit_artist1 ON edit...', 'ARRAY(0xcdfbce8)', 314771, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Utils.pm line 231
      MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0x9939d18)', 0, 25, 'CODE(0xce0def0)', 'SELECT edit.* FROM edit JOIN edit_artist edit_artist1 ON edit...', 'ARRAY(0xcdfbce8)', 314771, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 71
      MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0x7ff0670)', 'MusicBrainz::Server::EditSearch::Query=HASH(0xce2c3c8)', 25, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Edit.pm line 172
      MusicBrainz::Server::Controller::Edit::_ANON_(25, 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 153
      MusicBrainz::Server::Controller::_load_paged('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)', 'CODE(0xcdfb778)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Edit.pm line 173
      MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x94cb868)', 'MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)') 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(0xb4afab8)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cb868)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xb4afab8)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cb868)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x94cb868)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x94cc240)', 'MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)') 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(0xb4afab8)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cc240)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xb4afab8)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94cc240)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x94cc240)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'forward', 'MusicBrainz::Server=HASH(0xb4afab8)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'MusicBrainz::Server=HASH(0xb4afab8)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward('MusicBrainz::Server=HASH(0xb4afab8)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x94c23e0)', 'MusicBrainz::Server::Controller::Edit=HASH(0x91dee78)', 'MusicBrainz::Server=HASH(0xb4afab8)') 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(0xb4afab8)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94c23e0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xb4afab8)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x94c23e0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x94c23e0)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'forward', 'MusicBrainz::Server=HASH(0xb4afab8)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1ad4940)', 'MusicBrainz::Server=HASH(0xb4afab8)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward('MusicBrainz::Server=HASH(0xb4afab8)', '/edit/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x1ad4940)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
      Class::MOP::Class:::around('CODE(0x21333a0)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xb4afab8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 270
      Class::MOP::Class:::around('CODE(0x9754040)', 'MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xb4afab8)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xb4afab8)') 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(0x2e8e990)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x2e8e990)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
      Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x2e594f0)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x9c0d48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
      Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x9c0d48)') called at ./script/musicbrainz_fastcgi.pl line 28"

      Stack trace:

      line 231 MusicBrainz::Server::Data::Utils
      line 71 MusicBrainz::Server::Data::Edit
      line 172 MusicBrainz::Server::Controller::Edit
      line 153 MusicBrainz::Server::Controller
      line 173 MusicBrainz::Server::Controller::Edit
      line 270 MusicBrainz::Server

      Request data:

      $VAR1 = {
      'query_parameters' =>

      { 'conditions.0.args' => '1', 'conditions.1.name' => '', 'conditions.1.field' => 'artist', 'conditions.0.operator' => '=', 'conditions.1.args.0' => '', 'conditions.0.field' => 'status', 'order' => 'desc', 'conditions.1.user_id' => '314771', 'combinator' => 'and', 'field' => 'Please choose a condition', 'conditions.1.operator' => 'subscribed', 'auto_edit_filter' => '', 'negation' => '0' }

      ,
      'body_parameters' => {}
      };

            acid2 Oliver Charles
            hrglgrmpf Johannes W
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2011-08-22