You are here: Home » Topic » Song Database Not Updated

Song Database Not Updated

This topic contains 6 replies, has 2 voices, and was last updated by  rpedde 10 years, 1 month ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #1544

    rcoundon
    Participant

    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

    #11628

    rpedde
    Participant

    @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. ๐Ÿ™‚

    #11629

    rcoundon
    Participant

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

    #11630

    rpedde
    Participant

    @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

    #11631

    rcoundon
    Participant

    @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

    #11632

    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

    #11633

    rpedde
    Participant

    @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

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.