Uploaded image for project: 'ListenBrainz'
  1. ListenBrainz
  2. LB-808

SQL script to remove playlist creators as collaborators to own playlists

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Normal Normal
    • None
    • None

      https://github.com/metabrainz/listenbrainz-server/pull/1247 fixes an issue: playlist owners (creators) can also be listed as collaborators on their own playlists, which 1. makes little sense and 2. Makes the playlist appear twice in the user's playlist and collaborative playlists.

      The goal of this task is to create an SQL cleanup script to find all playlists whose owner is also amongst the collaborators, and remove them from collaborators.

      An example of such a playlist can be found here: https://listenbrainz.org/playlist/4245ccd3-4f0d-4276-95d6-2e09d87b5546

            kartik1712 amCap1712
            mr_monkey Monkey
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package