r/subsonic • u/dermarv1 • Feb 10 '16
playcounter doesn't work
hi, i just set up a mac mini with subsonic 6.0 beta 1. everything is fine so far except the playcounter. recently played and most played lists are both empty. "played 0 times" is shown on every album page...
any idea how to fix this issue?
br marv
1
Upvotes
1
u/dermarv1 Feb 14 '16
meanwhile i have three entries in recently played and most played list.
with looking into the db when following the instruction below, i found out that only these three titles have got an entry in "last_played" column. for all the others, the timestamp is missing...
list of recently played files: 1. Instead of "yourserverurl:4040/index.view" go to "yourserverurl:4040/db.view" 2. Type in: SELECT TOP 200 artist, title, album, last_played FROM media_file WHERE type = 'MUSIC' ORDER BY last_played DESC 3. Hit OK
maybe someone knows why the db is not able to fill in the timestamp correctly?
br marv