Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
Thanks erland > Do you add the albums by doing a standard LMS rescan or do you add them > some other way ? I add tracks the "normal" way, however I do use the SugarCube plugin which links in with MusicIP. Before adding tracks, I always scan them with MusicIP first before adding to LMS. > Are you running on some unusual hardware/os that might have interpret > characters different than anything else out there ? Standard Windows 7 x64 laptop, nothing unusual about it. > Do you have some other software involved that might write information to > the "tracks" table of LMS ? Maybe MusicIP does, no idea? > Did you upgrade anything (plugin, LMS, something else) when the problem > started to occur ? Don't think so, unless something updated itself without me knowing. Over the weekend I "played" with things, and deleted all the problem entries in Trackstat's xml backup and restored this as well as doing a clear library and rescan in LMS. I managed to clear all the problems, however adding new music resulted in the same issues as before and I was back to square one. Like you say it's probably something else other than Trackstat causing this. I'm at a bit of a loss as to where to go from here. I'll play with things and see if I can get any success. I guess MusicIP is probably a good place to start. Maybe a full LMS reinstallation is in order? Any further suggestions are very welcome. softstag's Profile: http://forums.slimdevices.com/member.php?userid=62131 View this thread: http://forums.slimdevices.com/showthread.php?t=100480 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
softstag wrote:
> I'll send you a PM with details of where you can download the db files
> from.
>
> I did try over the weekend to backup, clear and restore the trackstat
> data, but didn't have success in getting rid of the errors.
>
Something is strange with your LMS installation, when it calculates the
MD5 checksum for the url in the tracks table it seems to set it it
incorrectly in tracks table. It's not even consistent with the standard
track_persistent table so something really strange is going on. The fact
that "tracks" and "track_persistent" tables aren't in sync is very
likely going to cause the strange kind of issues you are seeing. I also
doubt the problems are related to TrackStat plugin, it feels more like a
general problem with the LMS setup when the LMS standard database tables
aren't in sync. It kind of feels like something is overwriting the
tracks.urlmd5 column with an incorrect value at some time.
Can you (or anyone else seeing this) think of anything in your setup
that could cause issues like this ?
Do you add the albums by doing a standard LMS rescan or do you add them
some other way ?
Are you running on some unusual hardware/os that might have interpret
characters different than anything else out there ?
Do you have some other software involved that might write information to
the "tracks" table of LMS ?
Did you upgrade anything (plugin, LMS, something else) when the problem
started to occur ?
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
You may also want to try my Android apps 'Squeeze Display'
(https://play.google.com/store/apps/details?id=info.isaksson.squeezedisplay)
and 'RSS Photo Show'
(https://play.google.com/store/apps/details?id=info.isaksson.rssphotoshow)
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=100480
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] fixed my website/repo
I'd like to thank those of you who contacted me about the recent trouble with the tux.org website I've hosted my plugins on. We recently upgraded the web server software and I failed to make required configuration changes. Everything should be OK again now. Best wishes to you all for the winter holiday season, Peter http://www.tux.org/~peterw/ Note: The best way to reach me is email or PM, as I don't spend time on the forums. *Free plugins:* AllQuiet Auto Dim/AutoDisplay BlankSaver ContextMenu DenonSerial FuzzyTime KidsPlay KitchenTimer PlayLog PowerCenter/BottleRocket SaverSwitcher SettingsManager SleepFade StatusFirst SyncOptions VolumeLock peterw's Profile: http://forums.slimdevices.com/member.php?userid=2107 View this thread: http://forums.slimdevices.com/showthread.php?t=100559 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: ShairTunes Plugin
Has anyone got this plugin to work on a MacOS SqueezeBox Server? Nikhil's Profile: http://forums.slimdevices.com/member.php?userid=993 View this thread: http://forums.slimdevices.com/showthread.php?t=100379 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Plugins for rating and "smart" playlists using SQL
excalibur wrote:
>
> Is there an easier way to shoot the SQL to the DB other than going via
> your plugin in SBSs web-GUI? (something that can be scripted)?
>
You could probably use the CSV link from Database Query plugin directly
from a script to retrieve the result if you like to.
Except for this, it might be possible to run a script directly towards
the database if the script have a SQLite databas access function, but I
would personally not recommend to access it from outside LMS, especially
if you need data both from tracks and track_statistics tables since they
are stored in different .db files. It's usually a lot easier to do it
from a plugin which runs inside LMS and just offer a URL or CLI/JSON
command that expose the data.
I'm not sure if the PostScan plugin might be useful in this context:
http://forums.slimdevices.com/showthread.php?79778-Announce-PostScan-plugin-BETA
It can run a SQL script after each rescan as I've understood it. Since
you need the url to file conversion it might not work for you but maybe
it can be a good starting point for a new plugin that does what you
want.
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland).
If you like to encourage future presence on this forum and/or third
party plugin/applet development, 'consider purchasing some plugins'
(http://license.isaksson.info))
You may also want to try my Android apps 'Squeeze Display'
(https://play.google.com/store/apps/details?id=info.isaksson.squeezedisplay)
and 'RSS Photo Show'
(https://play.google.com/store/apps/details?id=info.isaksson.rssphotoshow)
*Interested in the future of music streaming ? 'ickStream - A world of
music at your fingertips'
(http://forums.slimdevices.com/showthread.php?98467-Pre-Announcement-ickStream&p=743516)*.
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=20533
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Android controllers available without using android store?
Pungh0Li0 wrote: > I've sent you a PM with the link. Many thanks! "To try to judge the real from the false will always be hard. In this fast-growing art of 'high fidelity' the quackery will bear a solid gilt edge that will fool many people" - Paul W Klipsch, 1953 Julf's Profile: http://forums.slimdevices.com/member.php?userid=42050 View this thread: http://forums.slimdevices.com/showthread.php?t=100535 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Plugins for rating and "smart" playlists using SQL
erland wrote: > The functionality is not available in the plugin and it's unlikely that > I'll add something that modifies or delete music files. > > If you are not using the music folder browse method and you are not > doing this because you want to save storage space, I would personally > recommend that you rather delete the tracks from the LMS database than > deleting them physically from the disk. I think you should be able to do > this by adding the necessary SQL statement in > SQL/SQLite/schema_optimize.sql of your LMS installation. If I remember > correctly the schema_optimize.sql script is executed at the end of every > rescan. > > It might be good enough to just delete them from the "tracks" table > using a SQL like this in schema_optimize.sql: > > Code: > > > DELETE FROM tracks > JOIN track_statistics ON > tracks.url=track_statistics.url > WHERE > track_statistics.rating>0 AND > track_statistics.rating<40; > > > > > If this doesn't work, you might have to remove the entries from > "genre_track","playlist_track" and "contributor_track" tables before > you remove them from "tracks" table. You don't have to remove them > from the "track_statistics" and "tracks_persistent" tables if you > don't want to, the information in "track_statistics" and > "track_persistent" will just be ignored if they don't exist in > "tracks" table. > > > Correct, the LMS database will be updated next time you do a full > rescan, I don't think a scan for new/changed files will remove deleted > files correctly. > > > You will find the description of the TrackStat tables on the wiki: > http://wiki.slimdevices.com/index.php/TrackStat_plugin#Database_structure > > The SQL to use to get the files would probably be something like > this: > > Code: > > > SELECT DISTINCT tracks.url FROM tracks > JOIN track_statistics ON > tracks.url=track_statistics.url > WHERE > track_statistics.rating>0 AND > track_statistics.rating<40; > > > > > Something that's going to complicate things is that this will return > url and they will even be URL encoded urls. > > So it will return something like > > Code: > > file:///mnt/flacmusic/Christina%20Aguilera%20-%20Back%20To%20Basics%20Disc%202/I%20Got%20Trouble.flac > > > And to get the file, you need to first url decode it to get: > > Code: > > file:///mnt/flacmusic/Christina Aguilera - Back To Basics Disc 2/I Got Trouble.flac > > > And then convert it from a URL to a file to get: > > Code: > > /mnt/flacmusic/Christina Aguilera - Back To Basics Disc 2/I Got Trouble.flac > > > > If you are doing something in perl, there is a conversion function > Code: > > Slim::Utils::Misc::pathFromFileURL > > in LMS source code which will convert the URL encoded url to a file, > you will find it in the Misc.pm file: > https://github.com/Logitech/slimserver/blob/public/7.8/Slim/Utils/Misc.pm Thank you for the info the other week Erland. I had help from a Nix friend and we solved the task with automatic deletion from low Trackstat rated tracks. It is a 2 step proces. 1. I use your plugin Database Query to shoot the query you gave me above. I click the link to get info in the browser. It then displays all tracks that are lower rated than 40% 2. I copy & paste this info into a specific location, where my specificly named file is located, and paste info into this file. 3. I run a script that displays number of tracks in file - convert all lines from URL to path on server - and finally delete all the tracks in the txt file. So I think this works in a good way. Thank you for background info to enable us to do this. Is there an easier way to shoot the SQL to the DB other than going via your plugin in SBSs web-GUI? (something that can be scripted)? excalibur's Profile: http://forums.slimdevices.com/member.php?userid=33971 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
