Song Database Not Updated

[rcoundon]

I’m in the process of trying to write a scrobbler for Firefly.
I am accessing the songs3.db database using Python and noticed that I couldn’t get any rows back from the database that had been played.

I turned up the debug levels on the server and noticed that each time a song has been played the update statement to increase the play_count fails to update any rows because the id used is always 0.

i.e.
2007-07-09 22:03:06 (618a31a0): Executing: update songs set play_count=play_count + 1, time_played=1184014986 where id=0
2007-07-09 22:03:06 (618a31a0): Rows: 0

I am using the svn-1586 cut of Firefly on a Windows machine. Is this a known issue or have I misconfigured my server somehow?

Any help greatly appreciated.

Ross

[rpedde]

@rcoundon wrote:

I’m in the process of trying to write a scrobbler for Firefly.
I am accessing the songs3.db database using Python and noticed that I couldn’t get any rows back from the database that had been played.

I turned up the debug levels on the server and noticed that each time a song has been played the update statement to increase the play_count fails to update any rows because the id used is always 0.

i.e.
2007-07-09 22:03:06 (618a31a0): Executing: update songs set play_count=play_count + 1, time_played=1184014986 where id=0
2007-07-09 22:03:06 (618a31a0): Rows: 0

I am using the svn-1586 cut of Firefly on a Windows machine. Is this a known issue or have I misconfigured my server somehow?

Any help greatly appreciated.

Ross

Nope, looks like a bug to me. 🙂

[rcoundon]

@rpedde wrote:

@rcoundon wrote:

I’m in the process of trying to write a scrobbler for Firefly.
I am accessing the songs3.db database using Python and noticed that I couldn’t get any rows back from the database that had been played.

I turned up the debug levels on the server and noticed that each time a song has been played the update statement to increase the play_count fails to update any rows because the id used is always 0.

i.e.
2007-07-09 22:03:06 (618a31a0): Executing: update songs set play_count=play_count + 1, time_played=1184014986 where id=0
2007-07-09 22:03:06 (618a31a0): Rows: 0

I am using the svn-1586 cut of Firefly on a Windows machine. Is this a known issue or have I misconfigured my server somehow?

Any help greatly appreciated.

Ross

Nope, looks like a bug to me. 🙂

It also seems that there is no attempt to update the time_played field either.
Any plans for the production of the next nightly?

[rpedde]

@rcoundon wrote:

It also seems that there is no attempt to update the time_played field either.
Any plans for the production of the next nightly?

I bit off a pretty big chunk of refactoring and code cleanup. I had hoped I would have something broken but releasable this week. I may make that, but if so, it will be late this week, I think.

— Ron

[rcoundon]

@rpedde wrote:

I bit off a pretty big chunk of refactoring and code cleanup. I had hoped I would have something broken but releasable this week. I may make that, but if so, it will be late this week, I think.

— Ron

Cheers Ron, will look forward to getting my hands on it.

Ross

[nicul]

Hello,

I’ve watched the same behavior, searched this forum and found several issues concerning the play_count not being incremented for transcoded files. The problem still exists and I’ve been testing it with svn-1586, svn-1671 and svn-1668. The nightlies work for me. They serve the songs as they should, but are not incrementing the play_count counter for transcoded files. My music collection mainly contains ogg-flies and they need to be transcoded in order to be played with my soundbridge M1001.

I’ve tested several combinations and hope they will help to fix that bug. I tested with the following settings in mt-daapd.conf in general:
extensions = .mp3,.m4a,.m4p,.ogg

… and specifically
Transcode for ogg-files:
ssc_codectypes = ogg,flac,alac
Soundbridge plays the songs transcoding them, but firefly does not update the ‘songs played’ status on the webinterface and the database.

No transcode for ogg-files:
ssc_codectypes = flac,alac
I tested this setup with amarok as playing client. The songs are not transcoded, but played as ogg and the status on the webinterface as well as the database were updated.

I’ve tested on Debian 4.0 and Gentoo 2007.0 and I’m using wireless with WPA encryption. I use sqlite3.

Can anybody reproduce this issue with his own setup and confirm it? I suggest reopening ticket #191 (http://trac.fireflymediaserver.org/ticket/191). Let me know, if more information is needed describing this issue.

Is there a workaround or even a fix so far?

Issues in this forum:
– http://forums.fireflymediaserver.org/viewtopic.php?t=5765
– http://forums.fireflymediaserver.org/viewtopic.php?t=5349&start=15&postdays=0&postorder=asc
– http://forums.fireflymediaserver.org/viewtopic.php?t=5536

[rpedde]

@nicul wrote:

Hello,

I’ve watched the same behavior, searched this forum and found several issues concerning the play_count not being incremented for transcoded files. The problem still exists and I’ve been testing it with svn-1586, svn-1671 and svn-1668. The nightlies work for me. They serve the songs as they should, but are not incrementing the play_count counter for transcoded files. My music collection mainly contains ogg-flies and they need to be transcoded in order to be played with my soundbridge M1001.

I’ve tested several combinations and hope they will help to fix that bug. I tested with the following settings in mt-daapd.conf in general:
extensions = .mp3,.m4a,.m4p,.ogg

… and specifically
Transcode for ogg-files:
ssc_codectypes = ogg,flac,alac
Soundbridge plays the songs transcoding them, but firefly does not update the ‘songs played’ status on the webinterface and the database.

No transcode for ogg-files:
ssc_codectypes = flac,alac
I tested this setup with amarok as playing client. The songs are not transcoded, but played as ogg and the status on the webinterface as well as the database were updated.

I’ve tested on Debian 4.0 and Gentoo 2007.0 and I’m using wireless with WPA encryption. I use sqlite3.

Can anybody reproduce this issue with his own setup and confirm it? I suggest reopening ticket #191 (http://trac.fireflymediaserver.org/ticket/191). Let me know, if more information is needed describing this issue.

Is there a workaround or even a fix so far?

Issues in this forum:
– http://forums.fireflymediaserver.org/viewtopic.php?t=5765
– http://forums.fireflymediaserver.org/viewtopic.php?t=5349&start=15&postdays=0&postorder=asc
– http://forums.fireflymediaserver.org/viewtopic.php?t=5536

I’ve repro’ed it myself.

I think I might have lost that code when I redid the streaming stuff to support the hifidelio.

Keep nagging me about it. Between you and Iris, it will probably get done soon.

— Ron

[Author]

Posts