You are here: Home » Topic » "Songs Served" and play_count not updated correctl

"Songs Served" and play_count not updated correctl

FireFly Media Server (formerly mt-daapd) Firefly Media Server Forums Firefly Media Server Nightlies Feedback "Songs Served" and play_count not updated correctl

  • This topic has 13 replies, 3 voices, and was last updated 14 years ago by t0m.
Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • #393
    t0m
    Participant

    using 1249 with sqlite backend supporta and Soundbridge running build 2.5.170, the Songs Served counter on the server status page is not correct – not counting all played song, although the songs are played completly….

    further, the play_count and time_played are not updated:


    sqlite> SELECT title,artist,play_count,time_played FROM songs where play_count >0;
    sqlite>

    sqlite> SELECT title,artist,play_count,time_played FROM songs where time_played !=0;
    sqlite>

    any one elese noticed this?

    /t0m

    #5287
    rpedde
    Participant

    @t0m wrote:

    using 1249 with sqlite backend supporta and Soundbridge running build 2.5.170, the Songs Served counter on the server status page is not correct – not counting all played song, although the songs are played completly….

    further, the play_count and time_played are not updated:


    sqlite> SELECT title,artist,play_count,time_played FROM songs where play_count >0;
    sqlite>

    sqlite> SELECT title,artist,play_count,time_played FROM songs where time_played !=0;
    sqlite>

    any one elese noticed this?

    /t0m

    transcoded, or non-transcoded?

    #5288
    t0m
    Participant

    regarding the Status page, I’ve got 13095 songs in my db.

    After streaming some mp3 songs to my SB I’ve got:

    Songs Served 13

    the counters in the database are not updated:


    # sqlite songs.db 'SELECT title FROM songs where play_count =0;' |wc -l
    13095
    # sqlite songs.db 'SELECT title FROM songs where time_played =0;' |wc -l
    13095
    #

    # sqlite songs.db 'SELECT title FROM songs where play_count !=0;' |wc -l
    0
    # sqlite songs.db 'SELECT title FROM songs where play_count >0;' |wc -l
    0
    # sqlite songs.db 'SELECT title FROM songs where time_played !=0;' |wc -l
    0
    # sqlite songs.db 'SELECT title FROM songs where time_played >0;' |wc -l
    0
    #

    I haven’t checked transcoded content, yet.

    /t0m

    #5289
    t0m
    Participant

    I’ve compiled mt-daapd with


    ./configure --enable-sqlite3 --enable-sqlite --enable-debug --enable-mdns --enable-oggvorbis --enable-flac

    I switched to sqlite3 and streamed about 12 mp3s completely using the daap-java applet.

    play_count and time_played for all files still 0.


    # sqlite3 /usr/local/var/cache/mt-daapd/songs3.db
    SQLite version 3.3.5
    Enter ".help" for instructions
    sqlite> SELECT count(*) FROM songs where time_played != 0;
    0
    sqlite> SELECT count(*) FROM songs where time_played = 0;
    13095
    sqlite> SELECT count(*) FROM songs where play_count != 0;
    0
    sqlite> SELECT count(*) FROM songs where play_count = 0;
    13095
    sqlite>
    #5290
    t0m
    Participant

    starting mt-daapd with -D database -d 9 gives:


    13:56:22: Starting with debuglevel 9
    13:56:22: Starting rendezvous daemon
    13:56:22: Starting signal handler
    13:56:23: Opening database
    13:56:23: Executing: select value from config where term='version'
    13:56:23: Results: 0
    13:56:23: Initializing database
    13:56:23: Executing: select count(*) FROM songs
    13:56:23: Executing: select value from config where term='rescan'
    13:56:23: Executing: vacuum
    13:56:32: Rows: 2
    13:56:32: Starting web server from /usr/local/share/mt-daapd/admin-root on port 3689
    13:56:32: Registering rendezvous names
    13:56:32: Executing: select count(*) FROM songs
    13:56:32: Scanned 13095 songs in 10 seconds
    13:56:53: Executing: select count(*) FROM songs
    13:56:53: Executing: select count(*) FROM playlists
    13:56:53: No query/filter
    13:56:53: Executing: select * from songs
    13:56:53: Enumerating size
    13:56:55: Executing: select * from songs
    13:56:55: Got size: 1760614
    13:59:01: Executing: select * from songs where id=686
    13:59:01: Session 2: Streaming file '03 - Interlude1.mp3' to 127.0.0.1 (offset 0)
    13:59:30: Executing: select * from songs where id=692
    13:59:30: Session 3: Streaming file '09 - Interlude2.mp3' to 127.0.0.1 (offset 0)
    14:00:00: Executing: select * from songs where id=695
    14:00:00: Session 4: Streaming file '12 - Interlude3.mp3' to 127.0.0.1 (offset 0)
    14:00:09: Executing: select * from songs where id=684
    14:00:09: Session 5: Streaming file '01 - Intro.mp3' to 127.0.0.1 (offset 0)
    14:01:16: Executing: select * from songs where id=693
    14:01:16: Session 6: Streaming file '10 - Love labous on.mp3' to 127.0.0.1 (offset 0)
    14:05:13: Executing: select * from songs where id=702
    14:05:13: Session 7: Streaming file '19 - Mother Dawn.mp3' to 127.0.0.1 (offset 0)
    14:10:26: Executing: select * from songs where id=690

    no update statements…..

    #5291
    schiers
    Participant

    Hi,

    @t0m wrote:

    I’ve compiled mt-daapd with


    ./configure --enable-sqlite3 --enable-sqlite --enable-debug --enable-mdns --enable-oggvorbis --enable-flac

    I’m not sure, but isn’t it –enable-sqlite OR –enable-sqlite3 ?

    BR,
    Carsten.

    #5292
    t0m
    Participant

    I’m not sure, but isn’t it –enable-sqlite OR –enable-sqlite3 ?
    BR,
    Carsten.

    hmm… ./configure without optiosn gives:


    Must use either --enable-sqlite or --enable-sqlite3

    wil try with –enable-sqlite3 only…

    /t0m

    OK. just configured with –enable-sqlite3 only and compiled mt-daap new..
    No Change – play_count etc. still not updated 🙁

    /t0m

    #5293
    rpedde
    Participant

    @schiers wrote:

    Hi,

    @t0m wrote:

    I’ve compiled mt-daapd with


    ./configure --enable-sqlite3 --enable-sqlite --enable-debug --enable-mdns --enable-oggvorbis --enable-flac

    I’m not sure, but isn’t it –enable-sqlite OR –enable-sqlite3 ?

    BR,
    Carsten.

    it’s “either or both”. You can then choose which backend to use using db_type.

    — Ron

    #5294
    schiers
    Participant

    I see…and I cannot confirm the problem for me.

    BR,
    Carsten.

    #5295
    t0m
    Participant

    I’ve tested some more – seems a problem with folder art.

    with folder art

    2006-06-28 13:51:08: Thread 11: Length of file (remaining) is 2917002
    2006-06-28 13:51:08: Updating Content-Type from application/x-dmap-tagged to audio/mp3
    2006-06-28 13:51:08: Added *Content-Length=2917002*
    […]
    2006-06-28 13:51:08: Image appears to be 11881 bytes
    2006-06-28 13:51:08: Current tag size is 345 bytes
    2006-06-28 13:51:09: Done copying IMG 11895
    [..]
    2006-06-28 13:54:10: Finished streaming file to remote: 2916992 byte

    without folder art:

    2006-06-28 13:58:10: Thread 17: Length of file (remaining) is 831524
    2006-06-28 13:58:10: Updating Content-Type from application/x-dmap-tagged to audio/mp3
    2006-06-28 13:58:10: Added *Content-Length=831524*
    […]
    2006-06-28 13:58:55: Finished streaming file to remote: 831524 bytes
    2006-06-28 13:58:55: Executing: update songs set play_count=play_count + 1, time_played=1151495935 where id=12257

    #5296
    t0m
    Participant

    If there is a “art_filename” file present, the play_count / time_played is NOT update, because of a byte missmatch content-lenght <-> bytes streamed.

    /t0m

    #5297
    rpedde
    Participant

    @t0m wrote:

    If there is a “art_filename” file present, the play_count / time_played is NOT update, because of a byte missmatch content-lenght <-> bytes streamed.

    /t0m

    Nice catch. Should be fixed in r1269.

    #5298
    t0m
    Participant

    @rpedde wrote:

    Nice catch. Should be fixed in r1269.

    well… still problem when album art in the mp3-tag

    #5299
    t0m
    Participant

    I’ve noticed, there is still a diff. of exactly 10bytes:

    in svn-1274

    2006-06-29 18:41:22: Thread 7: Length of file (remaining) is 4390463
    […]
    2006-06-29 18:45:55: Finished streaming file to remote: 4390453 bytes

    in svn-1249

    2006-06-28 13:51:08: Thread 11: Length of file (remaining) is 2917002
    2006-06-28 13:51:08: Added *Content-Length=2917002*
    […]
    2006-06-28 13:54:10: Finished streaming file to remote: 2916992 byte

    /t0m

Viewing 14 posts - 1 through 14 (of 14 total)
  • The forum ‘Nightlies Feedback’ is closed to new topics and replies.