Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
erland wrote: > Just out of interest, is MusicIP and LMS both running on the same > computer ? Yes, very simple setup. 1 laptop, 1 squeezebox touch. Thanks again! 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 have no idea why things were working before, I can't think anything
> changed.
>
Just out of interest, is MusicIP and LMS both running on the same
computer ?
softstag wrote:
>
> At least now though everything is working as it should (and scans are
> quicker due to that MusicIP setting change).
>
Great, I'm happy we found a solution.
If I eventually get some spare time I might take a closer look see if I
can reproduce the problem in my own environment, but at the moment I
don't want to spend anymore time on it since we have found as
satisfactory workaround.
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
Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
Hi erland Well, that seems to have fixed the issue. It was MusicIP after all. Changing the MusicIP setting to "Only read mixable status from MusicIP" and carrying out the process you mentioned has put everything right again. I've added a couple of albums and done rescans and Trackstat statistics are all working as expected and surviving the LMS restart. Also, the database is no longer showing the issues. I have no idea why things were working before, I can't think anything changed. At least now though everything is working as it should (and scans are quicker due to that MusicIP setting change). I really appreciate your help on this erland, you are a star! 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 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.
>
How is MusicIP plugin configured in LMS Settings ?
Is it set to "Only read mixable status from MusicIP" or "Import all song
data from MusicIP" ?
If it's set to "Import all song data from MusicIP", could you try to
change it to "Only read mixable status from MusicIP" as described below
and see if that makes a difference ?
To verify that it makes a difference I suggest that you:
1.
Before the change, in Database Query plugin, create a new data query of
type "Free form query" with the SQL statement:
Code:
select url,urlmd5 from tracks where urlmd5!=md5(url) and audio=1
When you run this query you should get a couple of matches.
2.
Change the MusicIP setting to "Only read mixable status from MusicIP"
and perform a full rescan in LMS
3.
After the change, in Database Query plugin, run the query you created in
step 1 and verify that it doesn't return any rows.
If point 1 returns result and point 3 doesn't, it means that this was
the problem.
In this case, you now need to go through the TrackStat clear + restore
procedure I described earlier in the thread to cleanup the TrackStat
data:
http://wiki.slimdevices.com/index.php/TrackStat_plugin#Upgrade.2FReinstall
If the above didn't help, I would also suggest that you temporarily
uninstall the SugarCube plugin and repeat the full rescan and run the
above query in Database query plugin afterwards to verify if it made any
difference. I suspect SugarCube doesn't write to the database and isn't
the cause, but it's hard to say for sure since the SugarCube source code
is encrypted.
This should all make it possible for us to rule out MusicIP and
SugarCube plugin so we know if they are the cause or not.
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
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
Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
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. 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:
>
> Is there a way to rebuild the database and retain the ratings?
>
Would it be possible for you to shutdown LMS and send me a copy of
library.db and persist.db files so I can take a look at them ?
They are located in LMS Cache folder and it's important that you
shutdown LMS before copying them.
Make sure to zip them else they are going to be gigantic.
Before you try to restore the database, make sure to take a backup of
library.db and persist.db so you can go back if something goes wrong.
To restore the database and keep ratings, you should be able to follow
the upgrade instruction on TrackStat documentation page, basically you
first backup then clear TrackStat data and then restore the backup
file:
http://wiki.slimdevices.com/index.php/TrackStat_plugin#Upgrade.2FReinstall
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
Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
The vast majority of my music isn't tagged with musicbrainz tags. These albums are the same. This is what a typical one has in it's tags: Code: ALBUM: Searching For Sugar Man - Original Motion Picture Soundtrack ALBUM ARTIST: Rodriguez ALBUMARTIST: Rodriguez ARTIST: Rodriguez DATE: 2012 GENRE: Soundtrack ORGANIZATION: 88725418502 / CD REPLAYGAIN_ALBUM_GAIN: -9.78 dB REPLAYGAIN_ALBUM_PEAK: 0.976470947 REPLAYGAIN_TRACK_GAIN: -9.87 dB REPLAYGAIN_TRACK_PEAK: 0.969879150 TITLE: Sugar Man TOTALDISCS: 1 TOTALTRACKS: 14 TRACKNUMBER: 1 VENDOR: reference libFLAC 1.2.1 20070917 I checked in other programs and all tags are showing here. All my FLAC files are single tracks, not a single track per album. Some of these albums are in mp3 format, not all are FLAC. Looking at the Database query info, all the issues are surrounding these same albums. It is duplicating the trackstat info in the database, presumably every time it rescans. Is there a way to rebuild the database and retain the ratings? 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:
>
> Looks like problems with the Trackstat database?? Incidentally, the 187
> "Songs with invalid urlmd5 entries" appear to be the ones I'm having
> problems with.
>
Could you check how the musicbrainz related tags looks like for the
files ?
I think you can use the "View Tags" link in the song info page in LMS
web interface or you can use the tagging software of your choice.
Also, are you using FLAC cuesheets where a single FLAC file represent a
complete album or are you using individual files for each track ?
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
Re: [SlimDevices: Plugins] Trackstat Not Showing Rating For Newly Added Albums
Can you look in the server.log if there any errors either directly after
you change rating of a newly added album or after LMS has been restarted
?
You can post it or mail it to me if you don't know what to look for.
Just to make sure, you aren't changing the rating while LMS is still
scanning, are you ?
I'm asking because TrackStat can't change ratings while LMS is
rescanning, so it will queue up these requests and write them to the
database after scanning is finished. You can see if LMS is scanning by
looking in "Media Scan Details" section in LMS Settings/Information
Another thing that could be good information when troubleshooting is to
install the Database Query plugin and run it's "Squeezebox Server
Inconsistency/Problems" and "TrackStat Inconsistency/Problems", just be
aware that these reports can take quite a bit of time to generate in a
large library or on slow hardware, so if you have a large library or is
running LMS on slow hardware (NAS or similar) it's probably not a good
idea to do this before we have taken a closer look at the server.log.
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] Trackstat Not Showing Rating For Newly Added Albums
Hi I've been using Trackstat for over a year to rate my music. Up until recently this has worked flawlessly and I've no issues. Recently I've noticed some strange behaviour. For albums I've added recently, the track rating does not survive a LMS reboot. Oddly, if I add or change a rating for a track on an album that has been there a while then it changes and is still there after a reboot. I created a backup of the Trackstat to see if I could see anything. Sure enough the data is being saved to the database - those tracks I rated have the appropriate rating in the database, but in LMS they are showing as unrated. An example from the database is as follows: Code: file%3A%2F%2F%2FC%3A%2FMusic%2FMano%2520McLaughlin%2F2013%2520-%2520Peach%2520Got%2520Bones%2520%5BFLAC%5D%2F07%2520Colour%2520Me%2520In.flac 1385661830 80 I also noticed that the and fields are not showing for these tracks, even though I know I have played them several times. I can't see that I have done anything to cause this issue to happen, and I can't see why it is doing what it is doing. Any help would be appreciated on this. For information I'm using: Logitech Media Server Version: 7.7.3 - 1375965195 @ Mon Aug 12 11:14:33 CUT 2013 TrackStat v3.1.3869 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
