API tools faq
paste
Advertisement
Guest User

internal server error

a guest
Sep 14th, 2012
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.41 KB | None | 0 0
raw download clone embed print report
  1. Internal Server Error
  2. Oops, something went wrong!
  3.  
  4. Error:
  5.  
  6. Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
  7. 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist_1 ON edit_artist_1.edit = edit.id JOIN artist artist_2 ON artist_2.id = edit_artist_1.artist WHERE (((type = ? AND extract_path_value(data, 'link_type/id') = any(?)) OR(type = ? AND (extract_path_value(data, 'link/link_type/id') = any(?) OR
  8. extract_path_value(data, 'old/link_type/id') = any(?) OR
  9. extract_path_value(data, 'new/link_type/id') = any(?)))) and (artist_2.country = any(?)))
  10. ORDER BY open_time desc
  11. LIMIT 500 OFFSET ?'
  12. (90 ARRAY(0x1061c1b0) 91 ARRAY(0x1061bf58) ARRAY(0x1061bf58) ARRAY(0x1061bf58) ARRAY(0x1061c3f0) 0)
  13. DBD::Pg::st execute failed: ERROR: column reference "type" is ambiguous
  14. LINE 1: ...2 ON artist_2.id = edit_artist_1.artist WHERE (((type = '90...
  15. ^ at lib/Sql.pm line 83.
  16.  
  17. at lib/Sql.pm line 88
  18. Sql::__ANON__('DBD::Pg::st execute failed: ERROR: column reference "type" i...') called at local/lib/perl5/Try/Tiny.pm line 100
  19. Try::Tiny::try('CODE(0x10630088)', 'Try::Tiny::Catch=REF(0x1061c438)') called at lib/Sql.pm line 90
  20. Sql::select('Sql=HASH(0x109d4af8)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', 90, 'ARRAY(0x1061c1b0)', 91, 'ARRAY(0x1061bf58)', 'ARRAY(0x1061bf58)', 'ARRAY(0x1061bf58)', 'ARRAY(0x1061c3f0)', ...) called at lib/MusicBrainz/Server/Data/Utils.pm line 224
  21. MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0x109d4af8)', 0, 25, 'CODE(0x1061c060)', 'SELECT DISTINCT edit.* FROM edit JOIN edit_artist edit_artist...', 90, 'ARRAY(0x1061c1b0)', 91, 'ARRAY(0x1061bf58)', ...) called at lib/MusicBrainz/Server/Data/Edit.pm line 73
  22. MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0xb628258)', 'MusicBrainz::Server::EditSearch::Query=HASH(0x1062fda0)', 25, 0) called at lib/MusicBrainz/Server/Controller/Edit.pm line 191
  23. MusicBrainz::Server::Controller::Edit::__ANON__(25, 0) called at lib/MusicBrainz/Server/Controller.pm line 191
  24. MusicBrainz::Server::Controller::_load_paged('MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)', 'CODE(0xddfa170)') called at lib/MusicBrainz/Server/Controller/Edit.pm line 192
  25. MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst/Action.pm line 65
  26. Catalyst::Action::execute('Catalyst::Action=HASH(0xca59780)', 'MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst.pm line 1667
  27. eval {...} called at local/lib/perl5/Catalyst.pm line 1667
  28. Catalyst::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca59780)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
  29. Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca59780)') called at lib/MusicBrainz/Server.pm line 322
  30. MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca59780)') called at local/lib/perl5/Catalyst/Action.pm line 60
  31. Catalyst::Action::dispatch('Catalyst::Action=HASH(0xca59780)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst/Controller.pm line 125
  32. Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst/Action.pm line 65
  33. Catalyst::Action::execute('Catalyst::Action=HASH(0xca52ba8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst.pm line 1667
  34. eval {...} called at local/lib/perl5/Catalyst.pm line 1667
  35. Catalyst::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca52ba8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
  36. Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca52ba8)') called at lib/MusicBrainz/Server.pm line 322
  37. MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca52ba8)') called at local/lib/perl5/Catalyst/Action.pm line 60
  38. Catalyst::Action::dispatch('Catalyst::Action=HASH(0xca52ba8)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
  39. Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3f2d810)', 'forward', 'MusicBrainz::Server=HASH(0xd3edb48)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
  40. Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3f2d810)', 'MusicBrainz::Server=HASH(0xd3edb48)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
  41. Catalyst::forward('MusicBrainz::Server=HASH(0xd3edb48)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
  42. Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst/Action.pm line 65
  43. Catalyst::Action::execute('Catalyst::Action=HASH(0xca52788)', 'MusicBrainz::Server::Controller::Edit=HASH(0xc723ad0)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst.pm line 1667
  44. eval {...} called at local/lib/perl5/Catalyst.pm line 1667
  45. Catalyst::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca52788)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
  46. Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca52788)') called at lib/MusicBrainz/Server.pm line 322
  47. MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xd3edb48)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xca52788)') called at local/lib/perl5/Catalyst/Action.pm line 60
  48. Catalyst::Action::dispatch('Catalyst::Action=HASH(0xca52788)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
  49. Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3f2d810)', 'forward', 'MusicBrainz::Server=HASH(0xd3edb48)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
  50. Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3f2d810)', 'MusicBrainz::Server=HASH(0xd3edb48)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
  51. Catalyst::forward('MusicBrainz::Server=HASH(0xd3edb48)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
  52. Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x3f2d810)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst.pm line 1613
  53. Catalyst::dispatch('MusicBrainz::Server=HASH(0xd3edb48)') called at lib/MusicBrainz/Server.pm line 286
  54. Class::MOP::Class:::around('CODE(0x3836070)', 'MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
  55. Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
  56. MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xd3edb48)') called at local/lib/perl5/Catalyst.pm line 1963
  57. Catalyst::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
  58. eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
  59. Try::Tiny::try('CODE(0xcd0bf18)', 'Try::Tiny::Catch=REF(0xd76d4e0)') called at local/lib/perl5/Catalyst.pm line 1969
  60. Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd809268)') called at lib/Catalyst/Plugin/AutoRestart.pm line 119
  61. Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd809268)') called at local/lib/perl5/Catalyst/Engine.pm line 856
  62. Catalyst::Engine::__ANON__('CODE(0xcd34ef0)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
  63. Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1ccfa30)', 'CODE(0xcc99950)') called at local/lib/perl5/Plack/Loader.pm line 88
  64. Plack::Loader::run('Plack::Loader=HASH(0x1c98e00)', 'Plack::Handler::FCGI=HASH(0x1ccfa30)') called at local/lib/perl5/Plack/Runner.pm line 263
  65. Plack::Runner::run('Plack::Runner=HASH(0x1a9b808)') called at local/bin/plackup line 10"
  66. Stack trace:
  67. line 224 MusicBrainz::Server::Data::Utils
  68. line 73 MusicBrainz::Server::Data::Edit
  69. line 191 MusicBrainz::Server::Controller::Edit
  70. line 191 MusicBrainz::Server::Controller
  71. line 192 MusicBrainz::Server::Controller::Edit
  72. line 322 MusicBrainz::Server
  73. line 322 MusicBrainz::Server
  74. line 322 MusicBrainz::Server
  75. line 286 MusicBrainz::Server
  76. Request data:
  77.  
  78. $VAR1 = {
  79. 'query_parameters' => {
  80. 'conditions.2.operator' => '=',
  81. 'conditions.3.operator' => '=',
  82. 'conditions.2.field' => 'link_type',
  83. 'conditions.3.field' => 'artist_country',
  84. 'conditions.3.args' => '189',
  85. 'order' => 'desc',
  86. 'combinator' => 'and',
  87. 'conditions.2.args' => '156',
  88. 'field' => 'Please choose a condition',
  89. 'auto_edit_filter' => '',
  90. 'negation' => '0'
  91. },
  92. 'body_parameters' => {}
  93. };
  94.  
  95. URL: http://musicbrainz.org/search/edits?auto_edit_filter=&order=desc&negation=0&combinator=and&conditions.2.field=link_type&conditions.2.operator=%3D&conditions.2.args=156&conditions.3.field=artist_country&conditions.3.operator=%3D&conditions.3.args=189&field=Please+choose+a+condition
  96.  
  97. We're terribly sorry for this problem. Please wait a few minutes and repeat your request — the problem may go away.
  98.  
  99. If the problem persists, please report a bug and include any error message that is shown above.
  100.  
  101. Please be sure to include the stack trace and request data shown above!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!