Bugzilla – Bug 15460
Track with Extended ASCII in directory name fails to appear in Browse Music Folder
Last modified: 2011-05-13 09:44:37 UTC
This problem surfaced some time after installing Squeezeserver 7.4.1, r7915. When folders in my Home server Music folder contains the Norwegian letters "æ", "ø" or "å", the controller reports the current playlist as empty. Changing æ to e, ø to o and å to a solves the problem. I am using English on my controller since I suspected that installing Norwegian might be the cause of some nasty connection problems. I have used English before without problems concerning Norwegian letters in the folder names.
How are you trying to play those tracks? Browse Music Folder? Playing from Artists/Albums or similar? The Controller's language setting shouldn't have any impact on this. It's rather the server configuration.
(In reply to comment #1) > How are you trying to play those tracks? Browse Music Folder? Playing from > Artists/Albums or similar? > > The Controller's language setting shouldn't have any impact on this. It's > rather the server configuration. It happens when I browse the music folders. I always played music that way, but I now tried to browse by artists and albums. That seems to work ok. My server is running Windows Home server. What kind of configuration could give these problems? I never had any problems of this kind until I upgraded to 7.4.1. However, I don't exactly know when the problems occurred after upgrading.
what are the server details as you find them in Settings/Information (web UI)?
I just stumbled across the same thing (I think). If I try to Browse Music Folder, to a folder that contains a sub-folder with accented characters, it is reporting errors: [22:37:01.1721] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Incorrect string value: '\xDC\xDCL II' for column 'titlesort' at row 1 [for Statement "INSERT INTO tracks (filesize,titlesort,content_type,timestamp,titlesearch,url,title,remote,year) VALUES (?,?,?,?,?,?,?,?,?)"] [22:37:01.1733] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage::DBI::__ANON__ (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 1013) frame 3: Slim::Schema::newTrack (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 1240) frame 4: Slim::Schema::updateOrCreate (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 838) frame 5: Slim::Schema::objectForUrl (P:/Music/SlimServer/trunk/server/Slim/Web/Pages/BrowseTree.pm line 114) frame 6: Slim::Web::Pages::BrowseTree::browsetree (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 1086) frame 7: Slim::Web::HTTP::generateHTTPResponse (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 913) frame 8: Slim::Web::HTTP::processURL (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 724) frame 9: Slim::Web::HTTP::processHTTP (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 139) frame 10: (eval) (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 123) frame 11: Slim::Networking::IO::Select::__ANON__ (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 183) frame 12: (eval) (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 183) frame 13: Slim::Networking::IO::Select::loop (P:\Music\SlimServer\trunk\server\slimserver.pl line 627) frame 14: main::idle (P:\Music\SlimServer\trunk\server\slimserver.pl line 581) frame 15: main::main (P:\Music\SlimServer\trunk\server\slimserver.pl line 1072) [22:37:01.1747] Slim::Networking::IO::Select::__ANON__ (146) Error: Select task failed calling Slim::Web::HTTP::processHTTP: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Incorrect string value: '\xDC\xDCL II' for column 'titlesort' at row 1 [for Statement "INSERT INTO tracks (filesize,titlesort,content_type,timestamp,titlesearch,url,title,remote,year) VALUES (?,?,?,?,?,?,?,?,?)"] at P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 86 ; fh=Slim::Web::HTTP::ClientConn=GLOB(0x17c2fc04) Windows XP, 7.5.0/trunk SVN 29883
Phil - you're seeing a different issue. The original report is about the Controller interface not showing a few items. Yours is rather about the web UI crashing. tskjaerpe - could you please give me the details as in comment #3? Also: if you scroll down at the bottom of the list, would those items show up down there?
tskjaerpe - any update? Could you please provide the server.log file from when you try to do this?
This is working fine for me in SBS 7.5. Please feel free to re-open this bug if you still see the issue with 7.5. Thanks!
Sorry for answering a bit late, but I have been away for a while. The problem with foreign charachters are still very much alive. It also happens with accented charachters like those in Spanish and French. I must admitt that I still am running v. 7.4.1 since that one presently is giving me not too much trouble. Before, I had all sorts of connecting and rebuffering problems. I was on my way to the Sonos store when I 7.4.1 seemed to solve the most serious problems. The system is still a bit shaky, but I don't dare risking another update until it is dead stable. I did not find any "information" menu under "setting" in the Web GUI. Concerning the server log file, is this what you asked for?: 10-03-16 18:59:40.0939] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-16 19:29:49.0314] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-17 19:35:36.2836] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-17 19:56:16.2030] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-17 21:40:40.3582] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT me.id, me.url, me.musicbrainz_id, me.added, me.playcount, me.lastplayed, me.rating FROM tracks_persistent me WHERE ( ( rating IS NOT NULL OR playcount IS NOT NULL OR lastplayed IS NOT NULL ) )"] [10-03-17 21:40:41.9811] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 1217) frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 532) frame 4: DBIx::Class::Storage::DBI::dbh_do (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 1227) frame 5: DBIx::Class::Storage::DBI::_execute (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 1451) frame 6: DBIx::Class::Storage::DBI::_select (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI/Cursor.pm line 82) frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 547) frame 8: (eval) (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 540) frame 9: DBIx::Class::Storage::DBI::dbh_do (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI/Cursor.pm line 101) frame 10: DBIx::Class::Storage::DBI::Cursor::next (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/ResultSet.pm line 953) frame 11: DBIx::Class::ResultSet::next (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/TrackPersistent.pm line 62) frame 12: Slim::Schema::TrackPersistent::export (slimserver.pl line 1008) frame 13: main::cleanup (slimserver.pl line 988) frame 14: main::stopServer (slimserver.pl line 58) frame 15: PerlSvc::Startup (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>PerlSvc.pm line 95) frame 16: PerlSvc::_startup (slimserver.pl line 0) frame 17: (eval) (slimserver.pl line 0) [10-03-17 21:41:04.5577] Slim::Schema::Storage::throw_exception (82) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (10061) at /<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 950 [10-03-17 21:41:04.5583] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 972) frame 2: DBIx::Class::Storage::DBI::_connect (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 814) frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI.pm line 568) frame 4: DBIx::Class::Storage::DBI::dbh_do (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/Storage/DBI/Cursor.pm line 101) frame 5: DBIx::Class::Storage::DBI::Cursor::next (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>DBIx/Class/ResultSet.pm line 953) frame 6: DBIx::Class::ResultSet::next (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Schema/TrackPersistent.pm line 62) frame 7: Slim::Schema::TrackPersistent::export (slimserver.pl line 1008) frame 8: main::cleanup (slimserver.pl line 988) frame 9: main::stopServer (slimserver.pl line 58) frame 10: PerlSvc::Startup (/<D:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>PerlSvc.pm line 95) frame 11: PerlSvc::_startup (slimserver.pl line 0) frame 12: (eval) (slimserver.pl line 0) [10-03-17 22:09:37.7658] main::init (320) Starting Squeezebox Server (v7.4.1, r28947, Tue Oct 20 08:13:15 PDT 2009) perl 5.010000 [10-03-18 18:44:21.4062] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-18 19:29:34.0939] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-18 19:59:46.4135] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-18 21:40:59.4843] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds [10-03-18 23:17:06.0783] Slim::Networking::SqueezeNetwork::Players::_players_error (241) Unable to get players from SN: Timed out waiting for data, retrying in 300 seconds
It's fixed in 7.5.
This bug has been marked fixed in a released version of Squeezebox Server or the accompanying firmware or mysqueezebox.com release. If you are still seeing this issue, please let us know!
could you please provide a zip file with such a folder structure? And the system description from Settings/Information?
*** Bug 16034 has been marked as a duplicate of this bug. ***
*** Bug 16353 has been marked as a duplicate of this bug. ***
(In reply to comment #13) > *** Bug 16353 has been marked as a duplicate of this bug. *** I opened bug 16353 (did not find this one through search, sorry!) and can confirm its presence in every software version from 7.4.1 to 7.5.1. My problem is with swedish characters åäö/ÅÄÖ. Please tell me if you'd need any further assistance (testing, file structure info, logs and so on) from my side and I'll do what I can to help. As far as I'm concerned, this problem really is the last major flaw with SB. In other aspects, the software has improved drastically with the last versions.
== Auto-comment from SVN commit #31773 to the slim repo by ayoung == == http://svn.slimdevices.com/slim?view=revision&revision=31773 == Fixed bug 15460: Track with Extended ASCII in directory name fails to appear in Browse Music Folder
Got SB server build 7.6.0-32364 Touch fw 9430, Radio fw 9432 I can still see this issue: If the folder has accents or umlauts or extended ascii: the file is not seen from the player UI: browse music folder
(In reply to comment #16) > Got SB server build 7.6.0-32364 Touch fw 9430, Radio fw 9432 > > I can still see this issue: > > If the folder has accents or umlauts or extended ascii: > the file is not seen from the player UI: browse music folder Now it is working after clean install on Mac 10.6 .7 , W7 64 and XP32. Have3 not verified on WHS build
Verified on 7.6.32407 ------The ext-asci tracks are showing correctly in Browse Music Folder. There are still some issues with tracks not appearing in BMF--= Adding folders and files with foreign character seemed to cause some of my 'normal' tracks to not be seen in the browse music folder ----willl open a new big if I can reproduce the steps