[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amarok-bugs-dist
Subject:    [amarok] [Bug 363515] New: Can not play saved playlist after Amarok restart because MySQL playlist_t
From:       via KDE Bugzilla <bugzilla_noreply () kde ! org>
Date:       2016-05-25 16:00:44
Message-ID: bug-363515-71684 () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=363515

            Bug ID: 363515
           Summary: Can not play saved playlist after Amarok restart
                    because MySQL playlist_tracks table row are missing
                    track url values
           Product: amarok
           Version: 2.8.0
          Platform: Fedora RPMs
               URL: http://shrani.si/f/2P/aa/U6FOcag/screenshot-from-2016-
                    05-.png
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Playlist
          Assignee: amarok-bugs-dist@kde.org
          Reporter: techouse@gmail.com

When using a local MySQL server as the database for Amarok a saved playlist can
not be played after Amarok is restarted because the playlist_tracks table rows
do not get populated with track url values. The playlist will play untill
Amarok is restarted, but will refuse to play after Amarok is restarted.

Here is a screenshot of the playlist_tracks table with missing url values:
http://shrani.si/f/o/wJ/2hmke2H1/nourls.png

To fix this issue one can update the MySQL table in question using a query like
this:

    UPDATE playlist_tracks AS pt
    INNER JOIN playlists AS p ON p.id = pt.playlist_id
    INNER JOIN tracks AS t ON pt.title = t.title
    INNER JOIN albums AS a ON t.album = a.id AND pt.album = a.name
    INNER JOIN artists AS ar ON t.artist = ar.id
    INNER JOIN urls AS u ON t.url = u.id
    SET pt.url = substring(u.rpath, 2)
    WHERE pt.url = ''



Reproducible: Always

Steps to Reproduce:
1. save a playlist
2. restart Amarok
3. play the saved playlist

Actual Results:  
Amarok can not play the playlist because it can not find the tracks associated
with the playlist.

Screenshot: http://shrani.si/f/2P/aa/U6FOcag/screenshot-from-2016-05-.png

Expected Results:  
Amarok should be able to play the playlist.

Running on Fedora 23, Gnome 3.18.2

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Amarok-bugs-dist mailing list
Amarok-bugs-dist@kde.org
https://mail.kde.org/mailman/listinfo/amarok-bugs-dist

[prev in list] [next in list] [prev in thread] [next in thread]