Bug 3503 - "Now Playing" playlists always inserted, never updated/deleted
: "Now Playing" playlists always inserted, never updated/deleted
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: PC Other
: P2 critical (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-06-07 10:44 UTC by snarlydwarf
Modified: 2008-09-15 14:39 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description snarlydwarf 2006-06-07 10:44:35 UTC
The code to update the current "Now Playing" playlists is generating INSERTS into mysql, not UPDATE, which will add an item to the tracks table every time a song is played.

                     73 Query       INSERT INTO tracks (content_type, remote, tag, title, titlesearch, titlesort, url) VALUES ('cpl', '0', '1', 'Now Playing - Livingroom', 'NOW PLAYING LIVINGROOM', 'NOW PLAYING LIVINGROOM', 'clientplaylist://00:04:20:05:ce:48')


mysql> select count(*) from tracks where content_type =  'cpl';
+----------+
| count(*) |
+----------+
|      316 |
+----------+
1 row in set (0.01 sec)


This should probably be an update.  (Hrrm.. not sure why it isn't  ... I thought the url field was Unique...)
Comment 1 Dan Sully 2006-06-12 23:55:27 UTC
Fixed in change 7936.

You'll need to wipe & rescan, or otherwise clear out the playlist_track table.