|
Yes, it is a test server, so I was using it for testing Thanks, I did a sloppy job pushing this update out. Should be working now Concerning this, I think it is missing the opposite "is not in my subscription". Now a little bit off topic but I have very much difficulty to let's say select editor=jesus2099 AND subscribed artist for instance : 1. I click the select, then click the Editor options 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 ((editor_subscribe_artist2.editor = ?) and (editor = ?))
ORDER BY open_time DESC
LIMIT 500 OFFSET ?'
(285909 285909 0)
DBD::Pg::st execute failed: ERROR: column reference "editor" is ambiguous
LINE 1: ...(editor_subscribe_artist2.editor = '285909') and (editor = '...
^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.
etc.
The opposite is a separate ticket, and I'd like to keep it that way as it's quite a tricky problem. I'll look at your other problems now, thanks for testing The exception you caused should now be fixed. The others I think are unrelated problems Sorry I might be total moron. Show me edits that match all of the following conditions: Editor is jesus2099 Artist in my subscriptions Created after 2011-07-01 And that eventually "Found 0 edits Have you checked you have any subscriptions? test.musicbrainz.org does not currently have private data loaded, so you'll need to subscribe to something first. It's a bit awkward I know, hopefully the next time we reload data we can load the private data too! Thanks dude, it works great indeed, I can say I'm a moron, no subscriptions ! It sounds like it's all related to the autocomplete JS for editor search, so I think that's a different issue. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This is now in review at http://codereview.musicbrainz.org/r/1437
and available for testing on http://test.musicbrainz.org/search/edits
. Look for the "in subscriptions" option when you choose "artist" or "label" as a search field.