Subsonic Forum

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 were both empty for several days. meanwhile there are three entries in both lists.

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 (list is full of songs), 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 subsonic is not able to fill in the timestamp into the db correctly?

br marv



<-------------------------Subsonic Help Request---------------------->
Problem Description: recently played and most played lists have got only three entries. "played 0 times" is shown on every album page...
Troubleshooting Steps: i have no idea how to fix this issue...
Playback Application and version: standard web interface and isub on iphone
Subsonic Version: 6.0.beta1 (build 4676) – 4. Februar 2016
Server Version: jetty-6.1.x, java 1.8.0_25, Mac OS X (156,8 MB / 277,0 MB)
Hardware Platform: mac mini
Java Memory Limit: 512 mb
Problem Filename: --
Output from ffmpeg -i: --
Last ten log file lines:

Code: Select all

[14.02.16 15:51:20 MEZ]   DEBUG   StreamController   GET /stream?player=9&id=20550&auth=877738435, Range: bytes=0-
[14.02.16 15:51:20 MEZ]   INFO   StreamController   Content-Length: 5652986
[14.02.16 15:51:20 MEZ]   INFO   StreamController   Content-Range: 0-5652985/5652986
[14.02.16 15:51:50 MEZ]   DEBUG   StreamController   GET /stream?player=9&id=20551&auth=2135769269, Range: bytes=0-
[14.02.16 15:51:50 MEZ]   INFO   StreamController   Content-Length: 121487
[14.02.16 15:51:50 MEZ]   INFO   StreamController   Content-Range: 0-121486/121487
[14.02.16 15:51:50 MEZ]   INFO   StreamController   Wrote 121487 bytes of 121487 requested
[14.02.16 15:51:55 MEZ]   DEBUG   StreamController   GET /stream?player=9&id=20552&auth=1471897837, Range: bytes=0-
[14.02.16 15:51:55 MEZ]   INFO   StreamController   Content-Length: 5812213
[14.02.16 15:51:55 MEZ]   INFO   StreamController   Content-Range: 0-5812212/5812213

<-------------------------Subsonic Help Request---------------------->

Ok, so it isn't just me. Oddly it did work for me for the first few days. It has only stopped updating since Sunday or Monday.

Seems to me some players report to the recently played while others don't. If I play in jukebox mode, things appear in the last played-menu. If I play on my phone nothing happens.

what i found out is that it only shows up when the files were getting transcoded before/while playing.
if the file is played as usual, without transcoding, it won't appear in the recently played and most played section