"Songs Served" and play_count not updated correctl

[t0m]

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

[rpedde]

@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?

[t0m]

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

[t0m]

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>

[t0m]

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…..

[schiers]

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.

[t0m]

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

[rpedde]

@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

[schiers]

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

BR,
Carsten.

[t0m]

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