"Songs Served" and play_count not updated correctl

  • Post date

FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Nightlies Feedback › "Songs Served" and play_count not updated correctl

Viewing 10 posts - 1 through 10 (of 14 total)
1 2
  • Author
    Posts
  • 26/06/2006 at 7:19 PM #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

    27/06/2006 at 5:16 AM #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?

    27/06/2006 at 5:50 AM #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

    27/06/2006 at 11:58 AM #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>
    27/06/2006 at 12:22 PM #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…..

    27/06/2006 at 8:18 PM #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.

    27/06/2006 at 8:31 PM #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

    28/06/2006 at 3:34 AM #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

    28/06/2006 at 5:59 AM #5294
    schiers
    Participant

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

    BR,
    Carsten.

    28/06/2006 at 1:13 PM #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

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