Reply To: Song Database Not Updated

#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. 🙂