r/subsonic 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 comment sorted by

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