Bug 881 - Alphabetic inconsistencies
: Alphabetic inconsistencies
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.0.0
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-02-28 08:29 UTC by Bart
Modified: 2008-08-18 10:53 UTC (History)
0 users

See Also:
Category: ---


Attachments
Test version of Slim::Utils::Text (3.18 KB, text/plain)
2005-03-02 23:47 UTC, Dan Sully
Details
Windows Locale program. (293 bytes, text/plain)
2005-03-02 23:50 UTC, Dan Sully
Details
Test version of MMM Plugin (31.00 KB, text/plain)
2005-03-12 14:58 UTC, Dan Sully
Details
Fixed test version of MusicMagic/Plugin.pm (31.00 KB, text/plain)
2005-03-12 18:14 UTC, Dan Sully
Details
2nd Test version of changed MMM Plugin (31.29 KB, text/plain)
2005-03-13 14:39 UTC, Dan Sully
Details
Try number 3 of MMM Plugin. (31.37 KB, text/plain)
2005-03-13 15:58 UTC, Dan Sully
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bart 2005-02-28 08:29:54 UTC
I have done a clean installation of 28 Feb build, on Windows XP, deleting 
previous installation directories
In "Browse Artists" I get a strange rendition of the alphabet, with a Z and L 
after the L
A B C D E F G H I J K L Z L M N O P Q R S T U V W X Y Z 
Also, I get the artist "�ico Saquito" at the end of the "A"s
This is with the Default skin and Fishbone in Internet Explorer on XP and 
Mozilla on linux.
Comment 1 Dan Sully 2005-02-28 11:45:27 UTC
Bart - if you wouldn't mind, could you attach your slimserversql.db file to this
bug?

Thanks.
Comment 2 Bart 2005-02-28 23:57:35 UTC
I tried to attach it but got "Error - The file you are trying to attach is 
12786 kilobytes (KB) in size. Non-patch attachments cannot be more than 
10000KB. If your attachment is an image, try converting it to a compressable 
format like JPG or PNG, or put it elsewhere on the web and link to it from the 
bug's URL field or in a comment on the bug."
so I have put it at:
https://www.bris.ac.uk/fluff/u/ecbjm/FMCMkOQcmxKit0cQOEPTuAcJ/
Comment 3 Dan Sully 2005-03-01 15:15:07 UTC
Bart - I've checked in the fix for this as subversion change 2272.

Thanks for the bug report - keep them comming!
Comment 4 Bart 2005-03-02 10:38:20 UTC
The spurious letters in the alphabet are fixed, great, but get the 
artist "�ico Saquito" still appears at the end of the "A"s
Comment 5 Dan Sully 2005-03-02 13:25:11 UTC
Bart - is it possible to upload a track from that artist to the bug, or via the
fluff service?

Thanks.
Comment 6 Bart 2005-03-02 13:49:24 UTC
I have uploaded 05_-_A_Orillas_Del_Cauto by �ico Saquito to 
https://www.bris.ac.uk/fluff/u/ecbjm/jeZVN6R2yPGEkpLob77khAcL/
Comment 7 Dan Sully 2005-03-02 23:47:57 UTC
Created attachment 301 [details]
Test version of Slim::Utils::Text

Bart - Could you try this version of Slim/Utils/Text.pm ?

Also - I've attached a program that will print out your current locale. If you
could run it in a command prompt with ActiveState perl, that'd be great.

Thanks.
Comment 8 Dan Sully 2005-03-02 23:50:05 UTC
Created attachment 302 [details]
Windows Locale program.
Comment 9 Bart 2005-03-03 07:20:43 UTC
locale: cp1252
Comment 10 Bart 2005-03-03 08:50:30 UTC
I have 03 March build on XP
I put that version of Slim/Utils/Text.pm into C:\Program 
Files\SlimServer\server\Slim\Utils, deleted the cache, reimported the data.  
It still shows "�ico Saquito" at the end of the "A"s
Comment 11 Dan Sully 2005-03-10 00:06:39 UTC
Bart - are you using NTFS or FAT32 for your filestore? Or is it over a network
share?
Comment 12 Bart 2005-03-10 00:13:20 UTC
It is NTFS and it is across a network share.
Comment 13 Dan Sully 2005-03-10 00:15:14 UTC
And the network share is Samba? What version?
Comment 14 Bart 2005-03-10 00:32:17 UTC
No, it is not on a Samba share.  The files are on an NTFS volume on an XP 
machine.  The directory they are in is shared and I map a drive to it from 
another XP machine, where I am currently running Slimserver.  My linux machine 
is not currently running Slimserver but I aim to put it on there when 
everything settles down.
Isn't this the same bug as 993?
Comment 15 Dan Sully 2005-03-10 00:36:24 UTC
Yes and no. That bug is more that we're not normalizing the MU character.

This bug is that the encoding is incorrect when it's stored in the database, and
therefore isn't normalized properly.
Comment 16 Bart 2005-03-10 00:48:08 UTC
I am importing the data from MusicMagic.  Would it help if I turned off 
MusicMagic, wiped the cache and let Slimserver rescan?
Comment 17 Dan Sully 2005-03-10 00:54:39 UTC
Bart - that'd be great. If you could upload the DB again as well.

Thanks.
Comment 18 Bart 2005-03-10 08:59:26 UTC
On my XP machine I wiped the cache, turned off MusicMagic and let Slimserver 
read from the music directory.  When it had finished �ico Saquito was in 
the "N"s, not at the end of the "A"s
I also ran 6.0b1 on linux, without MusicMagic.  It also put �ico Saquito in 
the "N"s, not at the end of the "A"s

I uploaded the before and after databases from the XP machine:
database where I imported from MusicMagic
https://www.bris.ac.uk/fluff/u/ecbjm/2qVCgR2lERPI6BZ0r4384QcT/
database where I turned off MusicMagic and let Slimserver read the music 
directory
https://www.bris.ac.uk/fluff/u/ecbjm/BzL2QvNPl8Bg_GnJdvPRsgcT/
Comment 19 Dan Sully 2005-03-12 14:43:39 UTC
Bart - this appears to be a MusicMagic bug. I'll work with them to get it fixed,
and am investigating a workaround in SlimServer.

Thanks.
Comment 20 Dan Sully 2005-03-12 14:58:28 UTC
Created attachment 328 [details]
Test version of MMM Plugin

Bart - could you replace your Plugins/MusicMagic/Plugin.pm file with this one,
and rescan with MMM on?

Thanks.
Comment 21 KDF 2005-03-12 18:12:00 UTC
line 447 of this test plugin is wrong:
if (Slim::Utils::OSDetect::OS() eq 'win' && $initialized =~ /1\.1\.4$/);

needs to be:
if (Slim::Utils::OSDetect::OS() eq 'win' && $initialized =~ /1\.1\.4$/) {
Comment 22 Dan Sully 2005-03-12 18:14:11 UTC
Created attachment 331 [details]
Fixed test version of MusicMagic/Plugin.pm
Comment 23 Bart 2005-03-13 02:29:53 UTC
The new Plugin.pm fixed the sorting bug, �ico Saquito is now in the "N"s.

In the web interface if I browse to �ico Saquito and click on the MM symbol to 
make a MusicMagic mix it returns an empty page - the logfile shows:
http://localhost:10002/api/mix?artist%3D%C3%91ico%
20Saquito&variety=0&style=0&sizetype=tracks&size=12
 2005-03-13 09:46:56.8294 Musicmagic Error - Couldn't get mix: artist%3D%C3%
91ico%20Saquito&variety=0&style=0&sizetype=tracks&size=122005-03-13 
09:47:01.9359 browsedb - hierarchy: artist,album,track level: 0

On the Squeezebox if I browse to �ico Saquito and click on the MM symbol to 
make a MusicMagic mix it crashes the server - the logfile shows:
2005-03-13 10:22:23.5650 Musicmagic request: http://localhost:10002/api/mix?
album%3D%C3%91ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=25
2005-03-13 10:22:23.5737 Musicmagic Error - Couldn't get mix: album%3D%C3%
91ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=25Can't use string ("0") as an 
ARRAY ref while "strict refs" in use at C:/Program 
Files/SlimServer/server/Plugins/MusicMagic/Plugin.pm line 784.
Comment 24 Dan Sully 2005-03-13 02:45:11 UTC
Ok - I'll take a look. This will be a whole lot easier once MMM itself is fixed.
Comment 25 Dan Sully 2005-03-13 14:39:46 UTC
Created attachment 333 [details]
2nd Test version of changed MMM Plugin

Bart - I've updated the plugin again - could you give it a try?

No need to rescan.
Comment 26 Bart 2005-03-13 15:07:58 UTC
Copied the attachment to C:\Program 
Files\SlimServer\server\Plugins\MusicMagic\Plugin.pm
Restarted Slimserver
Navigated to �ico Saquito, clicked on MM/held "Play"
Still fails to return a MusicMagic mix, but does not crash the server if 
invoked from the Squeezebox

From the web interface:
2005-03-13 22:52:26.6945 Musicmagic request: http://localhost:10002/api/mix?
album%3D%C3%91ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=25
2005-03-13 22:52:26.7036 Musicmagic Error - Couldn't get mix: album%3D%C3%
91ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=252005-03-13 22:52:32.4459 DBI: 
Supressing periodic commit - no dirty items


From the Squeezebox:
22:54:58.5904 Musicmagic request: http://localhost:10002/api/mix?album%3D%C3%
91ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=25
2005-03-13 22:54:58.5993 Musicmagic Error - Couldn't get mix: album%3D%C3%
91ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=252005-03-13 22:55:02.6561 DBI: 
Supressing periodic commit - no dirty items


Comment 27 Bart 2005-03-13 15:29:41 UTC
Is my geography way out or are Mountain View CA and Monrovia CA  pretty close?
Comment 28 Dan Sully 2005-03-13 15:36:16 UTC
They are not close. About 360 miles / 5 hours away.

http://maps.google.com/maps?q=from%3A%20Mountain%20View%2C%20CA%20to%3A%20Monrovia%2C%20CA&hl=en
Comment 29 Dan Sully 2005-03-13 15:58:02 UTC
Created attachment 334 [details]
Try number 3 of MMM Plugin.

Again, no rescan is needed.
Comment 30 Bart 2005-03-13 23:47:58 UTC
That seems to have done it - makes a MusicMagic mix from both the web 
interface and the Squeezebox.  

2005-03-14 07:35:08.1631 mp3 file type for http://localhost:10002/api/mix?
album%3D%D1ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=25

2005-03-14 07:36:03.1266 Musicmagic request: http://localhost:10002/api/mix?
album%3D%D1ico%20Saquito%40%40The%20Music%20of%
20Cuba&variety=0&style=0&sizetype=tracks&size=25

360 miles is a long way!
Comment 31 Dan Sully 2005-03-13 23:56:43 UTC
It is. I imagine we'll head down there, or they'll come up here at some point to
meet.

Checked in as subversion change 2477.

Closing this bug.