Hi,
I am trying to get my Music into LinuxMCE.
UTF-8 in filenames are working
But keep on stumbeling over Danish/German characters (f.eks. æøå) that get's converted to "?"
Thereby also making the id3 tags wrong.
The Artist is also added twice - see attached picture. Same happens if the Album contains Danish/German characters.
I have tried using UTF-8 for the id3-tags but that does not work.
I have tried mid3iconv like described
here. That does not change anything.
eyeD3 shows that artist is UTF-8.
# eyeD3 03\ Don\'t\ Go\ Breaking\ My\ Heart.mp3
03 Don't Go Breaking My Heart.mp3 [ 8.80 MB ]
-------------------------------------------------------------------------------
Time: 04:26 MPEG1, Layer III [ ~202 kb/s @ 44100 Hz - Joint stereo ]
-------------------------------------------------------------------------------
ID3 v2.3:
title: Don't Go Breaking My Heart artist: Fenger & Frödin
album: Alle Tiders Danske Hits 1 year: 2008
track: 3 genre: Pop (id 13)
UserTextFrame: [Description: Tagging time]
2009-12-14T18:10:12
FRONT_COVER Image: [Size: 2493464 bytes] [Type: image/jpeg]
Interesting enough id3v2 shows the converted character - maybe because it uses the language settings !?
# id3v2 -l 03\ Don\'t\ Go\ Breaking\ My\ Heart.mp3
id3v1 tag info for 03 Don't Go Breaking My Heart.mp3:
Title : Don't Go Breaking My Heart Artist: Fenger & Frödin
Album : Alle Tiders Danske Hits 1 Year: 2008, Genre: Pop (13)
Comment: Track: 3
id3v2 tag info for 03 Don't Go Breaking My Heart.mp3:
TIT2 (Title/songname/content description): Don't Go Breaking My Heart
TPE1 (Lead performer(s)/Soloist(s)): Fenger & Frödin
TALB (Album/Movie/Show title): Alle Tiders Danske Hits 1
TRCK (Track number/Position in set): 3
TYER (Year): 2008
TCON (Content type): Pop (13)
TLAN (Language(s)): Danish
TXXX (User defined text information): (Tagging time): 2009-12-14T18:10:12
APIC (Attached picture): ()[, 3]: image/jpeg, 2493464 bytes
Here is what happens when Resynchronizing a file with the Web frontend.
Specially "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)" shows that something is not right.
sudo -u root /usr/pluto/bin/UpdateMedia -d \"/home/public/data/audio/Storage1 [27]/4Test\"
10 12/16/09 21:14:23.560 Activating Pluto Media Identifier... <0xb6ba06c0>
10 12/16/09 21:14:23.564 Pluto Media Identifier activated. Extensions 39 <0xb6ba06c0>
10 12/16/09 21:14:23.565 MediaState::LoadDbInfo ready to run big query <0xb6ba06c0>
10 12/16/09 21:14:23.617 MediaState::LoadDbInfo got 0 rows <0xb6ba06c0>
10 12/16/09 21:14:23.617 UpdateMedia::ReadDirectory /home/public/data/audio/Storage1 [27]/4Test <0xb6ba06c0>
10 12/16/09 21:14:23.619 UpdateMedia::ScanFiles dir /home/public/data/audio/Storage1 [27]/4Test: files found: 1 <0xb6ba06c0>
10 12/16/09 21:14:23.619 Need to update file because it's not in the database /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 <0xb6ba06c0>
10 12/16/09 21:14:23.620 Sync mode for /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3: modeBoth <0xb6ba06c0>
05 12/16/09 21:14:23.620 # PlutoMediaFile STARTED: dir /home/public/data/audio/Storage1 [27]/4Test file 03 Don't Go Breaking My Heart.mp3 <0xb6ba06c0>
10 12/16/09 21:14:23.620 # ID3FileHandler::LoadAttributes: loading 0 attributes in the attribute file /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 <0xb6ba06c0>
10 12/16/09 21:14:23.737 # LoadPlutoAttributes: pluto attributes loaded (from id3 file - general object tag) 0 <0xb6ba06c0>
=== TIT2 (Title/songname/content description): Don't Go Breaking My Heart
=== TPE1 (Lead performer(s)/Soloist(s)): Fenger & Fr�din
=== TALB (Album/Movie/Show title): Alle Tiders Danske Hits 1
=== TRCK (Track number/Position in set): 3
=== TYER (Year): 2008
=== TCON (Content type): Pop
=== TLAN (Language(s)): Danish
=== TXXX (User defined text information): (Tagging time): 2009-12-14T18:10:12
=== APIC (Attached picture): ()[, 3]: image/jpeg, 2493464 bytes
10 12/16/09 21:14:23.862 # LoadPlutoAttributes: id3 attributes loaded (from id3 file - common tags) 7 <0xb6ba06c0>
10 12/16/09 21:14:23.862 MergePictures: merging 0 pictures from our tag with 1 pictures from PIC tags <0xb6ba06c0>
10 12/16/09 21:14:23.938 LoadPlutoAttributes: loading picture with size 2493464 from PIC tag - md5sum 1c1f4090e87ea662767e748bfd973ee5 <0xb6ba06c0>
10 12/16/09 21:14:23.939 Processing path /home/public/data/audio/Storage1 [27]/4Test, file 03 Don't Go Breaking My Heart.mp3. Found 7 attributes, 0 long attributes in file <0xb6ba06c0>
10 12/16/09 21:14:23.940 HandleFileNotInDatabase media type 0 <0xb6ba06c0>
10 12/16/09 21:14:23.943 Won't reuse file record 45003 from db because md5 is different <0xb6ba06c0>
10 12/16/09 21:14:23.945 /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 not IN db-attr: 0 INode: 66502658 <0xb6ba06c0>
10 12/16/09 21:14:23.945 Media Type is: 4, is folder 0 <0xb6ba06c0>
10 12/16/09 21:14:23.947 File /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 assigned to user 0 <0xb6ba06c0>
10 12/16/09 21:14:23.956 PlutoMediaFile::AddFileToDatabase new /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 PK_File 45007 Inode 66502658 <0xb6ba06c0>
10 12/16/09 21:14:23.956 # SyncDbAttributes: attributes is db 0, total 7 <0xb6ba06c0>
05 12/16/09 21:14:23.958 Resetting db_wrapper connection <0xb6ba06c0>
01 12/16/09 21:14:23.959 Table_Attribute::GetRows Cannot perform query [select `Attribute`.* from Attribute where FK_AttributeType=2 AND Name='Fenger & Fr�din'] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' reconnect: 1 result2: 1 <0xb6ba06c0>
01 12/16/09 21:14:23.960 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 2 string sName Fenger & Fr�din PK_Attribute_Related 0 size 0 <0xb6ba06c0>
10 12/16/09 21:14:23.985 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 40988, AttrType = 2 with value Fenger & Fr�din, section 0, track 0 <0xb6ba06c0>
01 12/16/09 21:14:24.299 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 5 string sName 3 PK_Attribute_Related 40988 size 1 <0xb6ba06c0>
10 12/16/09 21:14:24.308 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 159, AttrType = 5 with value 3, section 0, track 0 <0xb6ba06c0>
01 12/16/09 21:14:24.486 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 8 string sName Pop PK_Attribute_Related 40988 size 1 <0xb6ba06c0>
10 12/16/09 21:14:24.487 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 133, AttrType = 8 with value Pop, section 0, track 0 <0xb6ba06c0>
01 12/16/09 21:14:24.598 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 13 string sName Don't Go Breaking My Heart PK_Attribute_Related 40988 size 1 <0xb6ba06c0>
10 12/16/09 21:14:24.600 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 35837, AttrType = 13 with value Don't Go Breaking My Heart, section 0, track 0 <0xb6ba06c0>
01 12/16/09 21:14:24.722 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 19 string sName 2008 PK_Attribute_Related 40988 size 1 <0xb6ba06c0>
10 12/16/09 21:14:24.723 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 182, AttrType = 19 with value 2008, section 0, track 0 <0xb6ba06c0>
01 12/16/09 21:14:24.933 MediaAttributes_LowLevel::GetAttributeFromDescription album rows 0 PK_MediaType 4 PK_AttributeType 3 string sName Alle Tiders Danske Hits 1 PK_Attribute_Related 40988 size 0 <0xb6ba06c0>
01 12/16/09 21:14:24.933 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 3 string sName Alle Tiders Danske Hits 1 PK_Attribute_Related 40988 size 0 <0xb6ba06c0>
10 12/16/09 21:14:24.935 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 40989, AttrType = 3 with value Alle Tiders Danske Hits 1, section 0, track 0 <0xb6ba06c0>
10 12/16/09 21:14:24.935 # SyncDbAttributes: long attributes is db 0, total 0 <0xb6ba06c0>
10 12/16/09 21:14:24.935 PlutoMediaFile::AddFileToDatabase picture url <0xb6ba06c0>
10 12/16/09 21:14:24.935 Added /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 to db with PK_File = 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.935 UpdateMedia::ReadDirectory PlutoMediaFile_.HandleFileNotInDatabase 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.935 SetFileAttribute /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.936 Attr in db : type 8 value Pop <0xb6ba06c0>
10 12/16/09 21:14:24.936 Attr in db : type 5 value 3 <0xb6ba06c0>
10 12/16/09 21:14:24.936 Attr in db : type 19 value 2008 <0xb6ba06c0>
10 12/16/09 21:14:24.936 Attr in db : type 13 value Don't Go Breaking My Heart <0xb6ba06c0>
10 12/16/09 21:14:24.936 Attr in db : type 2 value Fenger & Fr?din <0xb6ba06c0>
10 12/16/09 21:14:24.936 # LoadPlutoAttributes: (from db) new attributes to add in attribute file - type 2, values Fenger & Fr?din <0xb6ba06c0>
10 12/16/09 21:14:24.936 Attr in db : type 3 value Alle Tiders Danske Hits 1 <0xb6ba06c0>
10 12/16/09 21:14:24.936 # LoadPlutoAttributes: pluto attributes merged with those from database 8 <0xb6ba06c0>
10 12/16/09 21:14:24.937 # LoadPlutoAttributes: pluto long attributes merged with those from database 0 <0xb6ba06c0>
10 12/16/09 21:14:24.966 LoadCoverarts: loaded 1 unique pictures from file <0xb6ba06c0>
10 12/16/09 21:14:24.967 # SaveMiscInfo: FK_FileFormat 0, FK_MediaSubType 0 <0xb6ba06c0>
10 12/16/09 21:14:24.967 # GetPicAttribute: file 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.967 Found 0 pics for file <0xb6ba06c0>
10 12/16/09 21:14:24.968 Found 0 pics for attribute <0xb6ba06c0>
10 12/16/09 21:14:24.968 # GetPicAttribute: got no picture for file 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.968 UpdateMedia::ReadDirectory File 45007 Picture 0 <0xb6ba06c0>
10 12/16/09 21:14:24.969 # GetPicAttribute: file 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.969 Found 0 pics for file <0xb6ba06c0>
10 12/16/09 21:14:24.969 Found 0 pics for attribute <0xb6ba06c0>
10 12/16/09 21:14:24.969 # GetPicAttribute: got no picture for file 45007 <0xb6ba06c0>
10 12/16/09 21:14:24.969 # ID3FileHandler::SaveAttributes: saving 8 attributes in the attribute file /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 <0xb6ba06c0>
05 12/16/09 21:14:24.969 # ID3FileHandler::SaveAttributes: saving 1 pictures into APIC tags to /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 <0xb6ba06c0>
10 12/16/09 21:14:24.969 # ID3FileHandler::SaveAttributes: saving into APIC picture size 2493464 <0xb6ba06c0>
Writing: PK_Attr = -1000 ()[]: image/jpeg
Don't know yet how to save tag with PK_Attr = -1000 and value ()[]: image/jpeg
Writing: PK_Attr = 2 Fenger & Fr?din
Writing: PK_Attr = 3 Alle Tiders Danske Hits 1
Writing: PK_Attr = 5 3
Writing: PK_Attr = 8 Pop
Writing: PK_Attr = 13 Don't Go Breaking My Heart
Writing: PK_Attr = 19 2008
10 12/16/09 21:14:25.037 Serialize write bookmarks: 0 <0xb6ba06c0>
10 12/16/09 21:14:25.099 # SyncDbAttributes: ready to sync db with attributes found in attribute file <0xb6ba06c0>
10 12/16/09 21:14:25.100 # SyncDbAttributes: attributes is db 6, total 8 <0xb6ba06c0>
05 12/16/09 21:14:25.100 Resetting db_wrapper connection <0xb6ba06c0>
01 12/16/09 21:14:25.101 Table_Attribute::GetRows Cannot perform query [select `Attribute`.* from Attribute where FK_AttributeType=2 AND Name='Fenger & Fr�din'] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' reconnect: 1 result2: 1 <0xb6ba06c0>
01 12/16/09 21:14:25.101 MediaAttributes_LowLevel::GetAttributeFromDescription PK_MediaType 4 PK_AttributeType 2 string sName Fenger & Fr�din PK_Attribute_Related 0 size 0 <0xb6ba06c0>
10 12/16/09 21:14:25.109 # SyncDbAttributes: Adding attribute to database: for PK_File 45007, AttrID 40990, AttrType = 2 with value Fenger & Fr�din, section 0, track 0 <0xb6ba06c0>
10 12/16/09 21:14:25.110 # SyncDbAttributes: long attributes is db 0, total 0 <0xb6ba06c0>
10 12/16/09 21:14:25.110 SaveCoverarts: got 0 coverarts in db. Merging with 1 from file <0xb6ba06c0>
10 12/16/09 21:14:25.134 SaveCoverarts: adding picture with size 2493464, md5sum 1c1f4090e87ea662767e748bfd973ee5 to db <0xb6ba06c0>
10 12/16/09 21:14:26.963 Thumbnail picture created with convert -scale 256x256 -antialias picture-1c1f4090e87ea662767e748bfd973ee5.jpg picture-1c1f4090e87ea662767e748bfd973ee5_tn.jpg and returned 0 <0xb6ba06c0>
10 12/16/09 21:14:27.011 # SaveMiscInfo: FK_FileFormat 0, FK_MediaSubType 0 <0xb6ba06c0>
10 12/16/09 21:14:27.012 File /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3, PK_File 45007 - midmd5 is 3074e6cfa24a4fb6b6d2c6a7a2a58a74 <0xb6ba06c0>
Mapped file /mnt/device/27 : 2305 -> 27
10 12/16/09 21:14:27.021 File /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 on pluto device 27 <0xb6ba06c0>
10 12/16/09 21:14:27.022 File /home/public/data/audio/Storage1 [27]/4Test/03 Don't Go Breaking My Heart.mp3 assigned to user 0 <0xb6ba06c0>
10 12/16/09 21:14:27.022 MediaState::LoadDbInfoForFile ready to run big query <0xb6ba06c0>
10 12/16/09 21:14:27.025 MediaState::LoadDbInfoForFile got 1 rows <0xb6ba06c0>
10 12/16/09 21:14:27.027 # PlutoMediaFile ENDED: dir /home/public/data/audio/Storage1 [27]/4Test file 03 Don't Go Breaking My Heart.mp3, sync mode modeBoth <0xb6ba06c0>
10 12/16/09 21:14:27.027 Need to update file because it's not in the database /home/public/data/audio/Storage1 [27]/4Test <0xb6ba06c0>
10 12/16/09 21:14:27.027 Sync mode for dir /home/public/data/audio/Storage1 [27]/4Test: modeBoth <0xb6ba06c0>
05 12/16/09 21:14:27.027 # PlutoMediaFile STARTED: dir /home/public/data/audio/Storage1 [27] file 4Test <0xb6ba06c0>
10 12/16/09 21:14:27.027 # ID3FileHandler::LoadAttributes: loading 0 attributes in the attribute file /home/public/data/audio/Storage1 [27]/ <0xb6ba06c0>
10 12/16/09 21:14:27.027 # LoadPlutoAttributes: pluto attributes loaded (from id3 file - general object tag) 0 <0xb6ba06c0>
10 12/16/09 21:14:27.028 # LoadPlutoAttributes: id3 attributes loaded (from id3 file - common tags) 0 <0xb6ba06c0>
10 12/16/09 21:14:27.028 MergePictures: merging 0 pictures from our tag with 0 pictures from PIC tags <0xb6ba06c0>
10 12/16/09 21:14:27.028 Processing path /home/public/data/audio/Storage1 [27], file 4Test. Found 0 attributes, 0 long attributes in file <0xb6ba06c0>
05 12/16/09 21:14:27.029 Adding parent folder to db: /home/public/data/audio/Storage1 [27]/4Test PlutoMediaParentFolder.HandleFileNotInDatabase <0xb6ba06c0>
10 12/16/09 21:14:27.029 HandleFileNotInDatabase media type 0 <0xb6ba06c0>
05 12/16/09 21:14:27.030 Reusing record PK_File 45004 for /home/public/data/audio/Storage1 [27]/4Test ? Md5 db , md5 file <0xb6ba06c0>
10 12/16/09 21:14:27.031 PlutoMediaFile::HandleFileNotInDatabase /home/public/data/audio/Storage1 [27]/4Test N db-attr: 45004 Inode: 66502657 size 1 mt 0/4, md5 <0xb6ba06c0>
10 12/16/09 21:14:27.031 /home/public/data/audio/Storage1 [27]/4Test not IN db-attr: 45004 INode: 66502657 <0xb6ba06c0>
10 12/16/09 21:14:27.031 Media Type is: 4, is folder 1 <0xb6ba06c0>
10 12/16/09 21:14:27.031 Reusing file, updating media type to 4 <0xb6ba06c0>
10 12/16/09 21:14:27.031 File /home/public/data/audio/Storage1 [27]/4Test assigned to user 0 <0xb6ba06c0>
Mapped file /mnt/device/27 : 2305 -> 27
10 12/16/09 21:14:27.032 File /home/public/data/audio/Storage1 [27]/4Test on pluto device 27 <0xb6ba06c0>
10 12/16/09 21:14:27.032 # GetPicAttribute: file 45004 <0xb6ba06c0>
10 12/16/09 21:14:27.033 Found 0 pics for file <0xb6ba06c0>
10 12/16/09 21:14:27.033 Found 0 pics for attribute <0xb6ba06c0>
10 12/16/09 21:14:27.033 # GetPicAttribute: got no picture for file 45004 <0xb6ba06c0>
10 12/16/09 21:14:27.034 # GetPicAttribute: file 45004 <0xb6ba06c0>
10 12/16/09 21:14:27.034 Found 0 pics for file <0xb6ba06c0>
10 12/16/09 21:14:27.034 Found 0 pics for attribute <0xb6ba06c0>
10 12/16/09 21:14:27.034 # GetPicAttribute: got no picture for file 45004 <0xb6ba06c0>
10 12/16/09 21:14:27.034 # Won't create id3 file (the media file doesn't have attributes) <0xb6ba06c0>
10 12/16/09 21:14:27.034 # ID3FileHandler::SaveAttributes: saving 0 attributes in the attribute file /home/public/data/audio/Storage1 [27]/ <0xb6ba06c0>
05 12/16/09 21:14:27.034 # ID3FileHandler::SaveAttributes: saving 0 pictures into APIC tags to /home/public/data/audio/Storage1 [27]/ <0xb6ba06c0>
10 12/16/09 21:14:27.034 Serialize write bookmarks: 0 <0xb6ba06c0>
10 12/16/09 21:14:27.034 # SyncDbAttributes: ready to sync db with attributes found in attribute file <0xb6ba06c0>
Mapped file /mnt/device/27 : 2305 -> 27
10 12/16/09 21:14:27.034 File /home/public/data/audio/Storage1 [27]/4Test on pluto device 27 <0xb6ba06c0>
10 12/16/09 21:14:27.035 File /home/public/data/audio/Storage1 [27]/4Test assigned to user 0 <0xb6ba06c0>
10 12/16/09 21:14:27.036 MediaState::LoadDbInfoForFile ready to run big query <0xb6ba06c0>
10 12/16/09 21:14:27.038 MediaState::LoadDbInfoForFile got 1 rows <0xb6ba06c0>
10 12/16/09 21:14:27.039 # PlutoMediaFile ENDED: dir /home/public/data/audio/Storage1 [27] file 4Test, sync mode modeBoth <0xb6ba06c0>
10 12/16/09 21:14:27.039 Sync'ing db with directory... <0xb6ba06c0>
10 12/16/09 21:14:27.040 DB sync'd with directory! <0xb6ba06c0>
10 12/16/09 21:14:27.041 AlarmManager::~AlarmManager start 0x9202258 <0xb6ba06c0>
21 12/16/09 21:14:27.041 lock(0x920229c) (>3) alarm: AlarmManager.cpp:87 <0xb6ba06c0>
21 12/16/09 21:14:27.041 acquired(0x920229c) #0 (>3) alarm AlarmManager.cpp:87 <0xb6ba06c0>
21 12/16/09 21:14:27.041 unlock(0x920229c) #0 (>3) alarm: AlarmManager.cpp:87 <0xb6ba06c0>
21 12/16/09 21:14:27.041 end cond wait AlarmManager.cpp:102 (0x920229c) <0xb6b9fb90>
21 12/16/09 21:14:27.041 unlock(0x920229c) #0 (>2) alarm: AlarmManager.cpp:102 <0xb6b9fb90>
21 12/16/09 21:14:27.041 removed from map (0x920229c) #0 (>2) alarm: AlarmManager.cpp:102 was: 2 size, now 1 Rel: Y Got: Y <0xb6b9fb90>
21 12/16/09 21:14:27.041 removed from map (0x920229c) #0 (>3) alarm: AlarmManager.cpp:87 was: 1 size, now 0 Rel: Y Got: Y <0xb6ba06c0>
10 12/16/09 21:14:27.042 AlarmManager::~AlarmManager done 0x9202258 <0xb6ba06c0>