[mb-bugs] [jira] Commented: (MBS-3218) Internal Server Error when in edit search "Artist/Label is in my subscriptions"

[hrglgrmpf (JIRA)]

    [ http://tickets.musicbrainz.org/browse/MBS-3218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16060#action_16060 ] 

hrglgrmpf commented on MBS-3218:
--------------------------------

Hmm, I tried to find a reproducible path, but couldn't (the error always appeared after 3-5 steps of pretty randomly changing filter options). But in test.musicbrainz.org it seems fixed, thanks! I will reopen if it appears again!

> Internal Server Error when in edit search "Artist/Label is in my subscriptions"
> -------------------------------------------------------------------------------
>
>                 Key: MBS-3218
>                 URL: http://tickets.musicbrainz.org/browse/MBS-3218
>             Project: MusicBrainz Server
>          Issue Type: Bug
>          Components: Edit system, Search
>            Reporter: hrglgrmpf
>            Assignee: Oliver Charles
>             Fix For: Bug fixes, 2011-08-15
>
>
> Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
> 	'SELECT edit.* FROM edit  WHERE  ()
>          ORDER BY open_time DESC
>          LIMIT 500 OFFSET ?'
> 	(0)
> DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"
> LINE 1: SELECT edit.* FROM edit  WHERE  ()
>                                          ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.
> 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 258 MusicBrainz::Server
> Request data:
> $VAR1 = {
>           'query_parameters' => {
>                                   'conditions.9.operator' => 'subscribed',
>                                   'conditions.9.name' => '',
>                                   'conditions.9.args.0' => '',
>                                   'conditions.9.user_id' => '314771',
>                                   'conditions.9.conditions.8.conditions.7.conditions.6.conditions.5.conditions.4.conditions.3.conditions.2.conditions.1.conditions.0.field' => 'artist',
>                                   'combinator' => 'and',
>                                   'field' => 'Please choose a condition',
>                                   'auto_edit_filter' => '',
>                                   'negation' => '0'
>                                 },
>           'body_parameters' => {}
>         };

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tickets.musicbrainz.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira