The full query to get the changed tracks is:
Code:
--------------------
SELECT DISTINCT (scanned_files.url)
FROM scanned_files
JOIN
tracks ON (scanned_files.url = tracks.url AND
(scanned_files.timestamp != tracks.timestamp OR
scanned_files.filesize != tracks.filesize) AND
tracks.content_type != 'dir')
WHERE scanned_files.url LIKE 'file:///path/to/your/music%';
--------------------
Where the last condition would be the URLified music folder. You can
probably even leave it out. Next time you have a first scan after
changes, which missed some items, could you please run the above to see
what you get?
Michael
"It doesn't work - what shall I do?" - "Please check your server.log
and/or scanner.log file!"
(LMS: Settings/Information)
------------------------------------------------------------------------
mherger's Profile: http://forums.slimdevices.com/member.php?userid=50
View this thread: http://forums.slimdevices.com/showthread.php?t=115919
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
