Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
d6jg wrote: > > I quite like digging about in library.db using an SQL browser. You can > work out quite a bit even without the schema Yes. I was trying to find out why Custom Browse is so slow (It's because it only uses one table (in persist.db) for all custom tags. So instead of maybe one hundred thousand entries, it has over one million (in my case)). QLMS 8.0.0@2.20 x64 (digimaster) with perl 5.30.1 / QNAP 469L QTS 4.3.4 dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
dolodobendan wrote:
> From what I understand it's because every track has an assigned
> contributor ID (in the "album" table) and each contributor ID has an
> assigned artist (in the "contributor" table). My guess is that the
> ARTISTSORT equivalent in the contributor table ("namesearch") is always
> set, either automatically by LMS or customized when we set ARTISTSORT
> for a track. I further guess that LMS doesn't overwrite such
> customization with its own "ARTISTSORT" derivative but only if there's a
> second, "man-made" contradicting(?) one that is scanned later. Therefore
> one ARTISTSORT tag changes the sorting behavior for all tracks of that
> contributor ID and by doing that also for that artist.
>
> I could be totally wrong, though.
I think there is a fair chance you are correct.
I quite like digging about in library.db using an SQL browser. You can
work out quite a bit even without the schema
VB2.4[/B] STORAGE *QNAP TS419P (NFS)
[B]Living Room* - Joggler & SB3 -> Onkyo TS606 -> Celestion F20s
*Office* - Pi3+Sreen -> Sony TAFE320 -> Celestion F10s / Pi2+DAC & SB3
-> Onkyo CRN755 -> Wharfedale Modus Cubes
*Dining Room* -> SB Boom
*Kitchen* -> UE Radio (upgraded to SB Radio)
*Bedroom (Bedside)* - Pi2+DAC ->ToppingTP21 ->AKG Headphones
*Bedroom (TV)* - SB Touch ->Sherwood AVR ->Mordaunt Short M10s
Everything controlled by iPeng
d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051
View this thread: http://forums.slimdevices.com/showthread.php?t=112489
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
garym wrote: > Just remove the artistsort tag from the files that have it Yes, I did it already. Now there is no more problem. I don't use the Artistsort Tag normally. It was only in these orphaned files. Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > Oh, I didn't know. Thank you for the information. Very strange, but I > think I will have to live with it. Just remove the artistsort tag from the files that have it, and rescan your library and the sorting effect will not happen. *Home:* VBA 4TB (2.5) -or- rPi4B/pCP6.0/4TB>LMS 7.9.3>Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.4) -or- rPi4B/pCP6.0/4TB>LMS 7.9.1>Touch>Benchmark DAC I, Boom, Radio w/Battery (ethernet, Radio WIFI) *Office:* Win10(64)>LMS 7.9.3>Squeezelite *The Wild: *rPi3B+/pCP4.0, hifiberry Dac+Pro, 4TB USB (LMS & Squeezelite) *Controllers:* iPhone11 & iPadAir2 (iPeng), CONTROLLER, or SqueezePlay 7.8 on Win10(64) *Files:* ripping: dbpa > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote:
> Oh, I didn't know. Thank you for the information. Very strange, but I
> think I will have to live with it.
>From what I understand it's because every track has an assigned
contributor ID (in the "album" table) and each contributor ID has an
assigned artist (in the "contributor" table). My guess is that the
ARTISTSORT equivalent in the contributor table ("namesearch") is always
set, either automatically by LMS or customized when we set ARTISTSORT
for a track. I further guess that LMS doesn't overwrite such
customization with its own "ARTISTSORT" derivative but only if there's a
second, "man-made" contradicting(?) one that is scanned later. Therefore
one ARTISTSORT tag changes the sorting behavior for all tracks of that
contributor ID and by doing that also for that artist.
I could be totally wrong, though.
QLMS 8.0.0@2.20 x64 (digimaster) with perl 5.30.1 / QNAP 469L QTS 4.3.4
dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663
View this thread: http://forums.slimdevices.com/showthread.php?t=112489
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
garym wrote: > The way LMS works Oh, I didn't know. Thank you for the information. Very strange, but I think I will have to live with it. Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > Hello! > > I found the problem. But it seems to me a wrong behaviour of LMS when > sorting. > > The files for LMS are a 1:1 copy of my Music (before iTunes)-library > from my Mac. There was an orphaned album from Westernhagen that had > "ARTISTSORTORDER" set to "Müller-Westernhagen, Marius" for all tracks > which is clearly in "M". This album exists on the filesystem, but not in > Music (iTunes), so I didn't saw it on the Mac. > > This is the reason why these tracks are shown in "M". I can understand > this. > > But now comes the problem: Why are all other tracks of this artist also > shown in "M". I would expect that only the tracks where > "ARTISTSORTORDER" is set are shown there and not the others. > > Can someone explain me the reason for this? The way LMS works, if a single file for an ARTIST also has an ARTISTSORT tag, then *all* files for that ARTIST will be sorted using the ARTISTSORT tag information. *Home:* VBA 4TB (2.5) -or- rPi4B/pCP6.0/4TB>LMS 7.9.3>Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.4) -or- rPi4B/pCP6.0/4TB>LMS 7.9.1>Touch>Benchmark DAC I, Boom, Radio w/Battery (ethernet, Radio WIFI) *Office:* Win10(64)>LMS 7.9.3>Squeezelite *The Wild: *rPi3B+/pCP4.0, hifiberry Dac+Pro, 4TB USB (LMS & Squeezelite) *Controllers:* iPhone11 & iPadAir2 (iPeng), CONTROLLER, or SqueezePlay 7.8 on Win10(64) *Files:* ripping: dbpa > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
This may not help, so I'm sorry if it's a distraction. Ages ago I had a similar problem and no amount of altering the tags got rid of the problem. The root cause turned out to be my including in 'Comments" reviews of albums which exceeded the character limit for the field, causing corruption elsewhere in the tagging. At that time, MP3tag didn't have error checking to constrain tags to valid sizes. I no longer copy and paste comments, so have not investigated further in MP3tag. Digital: Raspberry Pi 3B; piCorePlayer 6 + LMS 8; HifiBerry DAC+DSP > Yamaha RX-V2700 > Jamo speakers Analogue: HifiBerry DAC+DSP > Speakercraft MZC-66 > whole house Library: External USB drive Android: Squeezer app Viragored's Profile: http://forums.slimdevices.com/member.php?userid=32954 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
karlek wrote: > I can see a single example. You should select all files and then inspect > the advanced tags. If one single file has a sort tag it should be listed > then. > But I dont know the Mac Version yet. Yes, this. Viewing and editing tags in bulk is a core feature of the program, and there must be a way to do it in the Mac version, unless Florian hasn't written it yet. ftlight's Profile: http://forums.slimdevices.com/member.php?userid=5294 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > This is what can be seen on the screenshots on the page before. This is > the Advanced Tag (Erweiterte Tags) window. On a Mac you can get it with > Command-T.Does the same artist appear on any other album? As far as I know the only way to change the sort order is an ARTISTSORT tag. Sent from my Pixel 3a using Tapatalk slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
d6jg wrote: > In Windows the Advanced Tag display is Alt+T look for something similar > in the Mac version This is what can be seen on the screenshots on the page before. This is the Advanced Tag (Erweiterte Tags) window. On a Mac you can get it with Command-T. Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
In Windows the Advanced Tag display is Alt+T look for something similar in the Mac version I agree it will be an ARTISTSORT tag somewhere VB2.4[/B] STORAGE *QNAP TS419P (NFS) [B]Living Room* - Joggler & SB3 -> Onkyo TS606 -> Celestion F20s *Office* - Pi3+Sreen -> Sony TAFE320 -> Celestion F10s / Pi2+DAC & SB3 -> Onkyo CRN755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - Pi2+DAC ->ToppingTP21 ->AKG Headphones *Bedroom (TV)* - SB Touch ->Sherwood AVR ->Mordaunt Short M10s Everything controlled by iPeng d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > You can see all the tags above in my screenshots. There is no Artistsort > or whatever in the files. I can see a single example. You should select all files and then inspect the advanced tags. If one single file has a sort tag it should be listed then. But I dont know the Mac Version yet. karlek's Profile: http://forums.slimdevices.com/member.php?userid=64321 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
ftlight wrote: > What do you have in the "Tag" column in the track listing in MP3tag? I think you speak of the Windows version? The new Mac version is an alpha version with not all the features the Windows version has. It is a complete rewrite I think. Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
karlek wrote: > Its not ARTIST but ARTIST SORT where youll have to look for. You can see all the tags above in my screenshots. There is no Artistsort or whatever in the files. Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
karlek wrote: > Its not ARTIST but ARTIST SORT where youll have to look for. And ARTISTSORT. QLMS 8.0.0@2.20 x64 (digimaster) with perl 5.30.1 / QNAP 469L QTS 4.3.4 dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > I checked them all and no single file has another artist than > "Westernhagen". Its not ARTIST but ARTIST SORT. karlek's Profile: http://forums.slimdevices.com/member.php?userid=64321 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
myke2k7 wrote: > Hi > > same issue here. > I have an other Artist Western Hagen, but album is Westernhagen. > If I check them all, one of them has an artist sort tag. > I think the artist sort tag changes the name. > I´ve tried twice but output of mp3tag is still the same. > > LMS 8.0 problem? confused... > > br > mikeWhat is in the Artist Sort tag? Are you saying you removed the Artist Sort tag and it made no difference? If so do a clear and rescan. Sent from my Pixel 3a using Tapatalk slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
What do you have in the "Tag" column in the track listing in MP3tag? If you have more than one tag type listed, for example both ID3v1 and ID3v2, this can cause the problems you describe. To fix this, go into menu option: tools > options > tags > mpeg and set the checkboxes to match the settings shown below. The next step seems a bit extreme, so make sure you have a backup of the source files before executing this! Select all tracks. Click on the red X (Remove tag) and them immediately click on the Undo arrow just to the right of the X. This will remove all tags, then re-write only ID3v2.1, with no loss of data. +---+ |Filename: Screen Shot367.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=30857| +---+ ftlight's Profile: http://forums.slimdevices.com/member.php?userid=5294 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
Hi same issue here. I have an other Artist Western Hagen, but album is Westernhagen. If I check them all, one of them has an artist sort tag. I think the artist sort tag changes the name. I´ve tried twice but output of mp3tag is still the same. LMS 8.0 problem? confused... br mike myke2k7's Profile: http://forums.slimdevices.com/member.php?userid=69889 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
slartibartfast wrote: > If you have more than one album by Westernhagen maybe one of them has an > artist sort tag. I think it only takes one file with an artist sort tag > to cause all albums to be sorted that way. I checked them all and no single file has another artist than "Westernhagen". Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > Here is the output of mp3tag (new alpha version for macOS): > 30855 > > So you see no difference! > > > > I know, but why? There is nothing in the files which has this > information.If you have more than one album by Westernhagen maybe one of them > has an artist sort tag. I think it only takes one file with an artist sort tag to cause all albums to be sorted that way. Sent from my Pixel 3a using Tapatalk slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
slartibartfast wrote: > How are you checking the tags? Here is the output of mp3tag (new alpha version for macOS): 30855 So you see no difference! slartibartfast wrote: > It looks like it is being sorted under "Muller-Westernhagen". I know, but why? There is nothing in the files which has this information. +---+ |Filename: Bildschirmfoto 2020-06-28 um 00.18.34.png| |Download: http://forums.slimdevices.com/attachment.php?attachmentid=30855| +---+ Pi4 4GB piCorePlayer with LMS and Squeezelite for USB; Pi3B+ (7" Display, Hifiberry DAC+ Pro) piCoreplayer with Squeezlite/Jivelite for Hifiberry and Bluetooth headphone; two Airport Express carsten_h's Profile: http://forums.slimdevices.com/member.php?userid=69113 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] LMS 8.0: Very strange sorting order?
carsten_h wrote: > Hello! > > It seems I have a very strange problem. I have albums from "Marius > Müller-Westernhagen" and "Westernhagen" (He changed the name for newer > albums). > When I go into the menu via "Artists", I find the following order: > > Madness > Manfred Man > Marillion > Marius Müller-Westernhagen. <--- > Mark Knopfler > ... > Mike + The Mechanics > Milla > Westernhagen. <--- > Mungo Jerry > Nazareth > ... > > Unter "W" I can not find Westernhagen. I have nothing in the sorting > Tags in the MP3 files for this artist. > This is an example of a file with all the tags inside: > 30854 > > So why in the world is an artist with "W" inserted at "M"? This is the > only artist I can find that is wrong.How are you checking the tags? It looks > like it is being sorted under "Muller-Westernhagen". I would use something like mp3tag and check extended tags. Sent from my Pixel 3a using Tapatalk slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609 View this thread: http://forums.slimdevices.com/showthread.php?t=112489 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
