Re: [SlimDevices: Beta] Unable to browse Music Folder in web and SqueezePlay interfaces

Mon, 04 Jan 2010 05:28:09 -0800 

Following a full clear & rescan, the problem persists.  I don't think
the fact that I added new content had anything to do with the problem. 
Enabling some additional database logging, the problem is with some
content that's been in the library for years.

It's trying to add the directory for the artist 'André Previn' when it
chokes.  That directory should already be in the database, but isn't.


Code:
--------------------
    
  [10-01-04 06:00:24.6162] Slim::Schema::Debug::query_start (23) SELECT me.id, 
me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, 
me.primary_artist, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, 
me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, 
me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, 
me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, 
me.musicmagic_mixable, me.musicbrainz_id, me.lossless, me.lyrics, 
me.replay_gain, me.replay_peak, me.extid FROM tracks me WHERE ( url = ? ): 
'file:///E:/Flac/Andr%E9%20Previn'
  [10-01-04 06:00:24.6194] Slim::Schema::Debug::query_start (23) SELECT me.id, 
me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, 
me.primary_artist, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, 
me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, 
me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, 
me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, 
me.musicmagic_mixable, me.musicbrainz_id, me.lossless, me.lyrics, 
me.replay_gain, me.replay_peak, me.extid FROM tracks me WHERE ( url = ? ): 
'file:///E:/Flac/Andr%E9%20Previn'
  [10-01-04 06:00:24.6209] Slim::Schema::newTrack (917) 
  New Track: [file:///E:/Flac/Andr%E9%20Previn]
  [10-01-04 06:00:24.6214] Slim::Schema::newTrack (927) readTags is 1
  [10-01-04 06:00:24.6221] Slim::Music::Info::plainTitle (624) Plain title for: 
file:///E:/Flac/Andr%E9%20Previn
  [10-01-04 06:00:24.6227] Slim::Music::Info::plainTitle (644)  is André Previn
  [10-01-04 06:00:24.6238] Slim::Schema::_preCheckAttributes (2152) Report for 
file:///E:/Flac/Andr%E9%20Previn:
  [10-01-04 06:00:24.6245] Slim::Schema::_preCheckAttributes (2153) * 
Attributes *
  [10-01-04 06:00:24.6250] Slim::Schema::_preCheckAttributes (2162) .. YEAR : 0
  [10-01-04 06:00:24.6255] Slim::Schema::_preCheckAttributes (2162) .. 
CONTENT_TYPE : dir
  [10-01-04 06:00:24.6260] Slim::Schema::_preCheckAttributes (2162) .. REMOTE : 0
  [10-01-04 06:00:24.6265] Slim::Schema::_preCheckAttributes (2162) .. 
TITLESEARCH : ANDRÉ PREVIN
  [10-01-04 06:00:24.6270] Slim::Schema::_preCheckAttributes (2162) .. 
TITLESORT : ANDRÉ PREVIN
  [10-01-04 06:00:24.6275] Slim::Schema::_preCheckAttributes (2162) .. FILESIZE 
: 0
  [10-01-04 06:00:24.6280] Slim::Schema::_preCheckAttributes (2162) .. RATING : 0
  [10-01-04 06:00:24.6285] Slim::Schema::_preCheckAttributes (2162) .. 
TIMESTAMP : 1215785115
  [10-01-04 06:00:24.6289] Slim::Schema::_preCheckAttributes (2162) .. TITLE : 
André Previn
  [10-01-04 06:00:24.6294] Slim::Schema::_preCheckAttributes (2166) * Deferred 
Attributes *
  [10-01-04 06:00:24.6299] Slim::Schema::_preCheckAttributes (2175) .. COMMENT 
: ARRAY(0x7283d24)
  [10-01-04 06:00:24.6304] Slim::Schema::newTrack (964) Creating Track with 
columns:
  [10-01-04 06:00:24.6309] Slim::Schema::newTrack (977)   year : 0
  [10-01-04 06:00:24.6314] Slim::Schema::newTrack (977)   content_type : dir
  [10-01-04 06:00:24.6319] Slim::Schema::newTrack (977)   remote : 0
  [10-01-04 06:00:24.6324] Slim::Schema::newTrack (977)   titlesearch : ANDRÉ 
PREVIN
  [10-01-04 06:00:24.6329] Slim::Schema::newTrack (977)   titlesort : ANDRÉ 
PREVIN
  [10-01-04 06:00:24.6334] Slim::Schema::newTrack (977)   filesize : 0
  [10-01-04 06:00:24.6339] Slim::Schema::newTrack (977)   timestamp : 1215785115
  [10-01-04 06:00:24.6344] Slim::Schema::newTrack (977)   title : André Previn
  [10-01-04 06:00:24.6359] Slim::Schema::Storage::throw_exception (82) Error: 
DBI Exception: DBD::mysql::st execute failed: Incorrect string value: '\xC9 
PREV...' for column 'titlesort' at row 1 [for Statement "INSERT INTO tracks 
(filesize,titlesort,content_type,timestamp,titlesearch,url,title,remote,year) 
VALUES (?,?,?,?,?,?,?,?,?)"]
  [10-01-04 06:00:24.6371] Slim::Schema::Storage::throw_exception (82) 
Backtrace:
  
--------------------


What I find looking at the tracks table in the database is that there
are only 27 records with a content_type of 'dir', ending at the artist
directory immediately before 'André Previn'.  So the scanner must also
be choking on the same thing, and doesn't complete the pass where it
enters directories.  Apparently it recovers from the error and completes
the scanning of music files.


+-------------------------------------------------------------------+
|Filename: 2010-01-04_062247.jpg                                    |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=8964|
+-------------------------------------------------------------------+

-- 
JJZolx

Jim
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=73507


_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta

Reply via email to