utf8 "\xC1" does not map to Unicode at /PerlApp/Slim/Utils/Strings.pm line 134, chunk 1. utf8 "\xC1" does not map to Unicode at /PerlApp/Slim/Utils/Strings.pm line 134, chunk 1. 2007-05-16 11:48:52.0468 Connected to database dbi:mysql:hostname=127.0.0.1;port=9092;database=slimserver - schema version: [3] 2007-05-16 11:48:52.3659 loading types config file... 2007-05-16 11:48:52.3707 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2007-05-16 11:48:52.3765 Import: Adding Slim::Music::PlaylistFolderScan Scan 2007-05-16 11:48:52.3769 Import: Adding Slim::Music::MusicFolderScan Scan 2007-05-16 11:48:52.3783 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2007-05-16 11:48:52.3868 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1', 'isScanning' 2007-05-16 11:48:52.3891 forceCommit: syncing to the database. 2007-05-16 11:48:52.3894 Import: Wiped all in-memory caches. 2007-05-16 11:48:52.3895 Import: Start schema_clear 2007-05-16 11:48:52.3898 Executing SQL file C:\Program Files\SlimServer\server\SQL\mysql\schema_clear.sql 2007-05-16 11:48:52.3902 Executing SQL statement: [SET foreign_key_checks = 0;] 2007-05-16 11:48:52.3904 Executing SQL statement: [DELETE FROM tracks;] 2007-05-16 11:48:52.3910 Executing SQL statement: [DELETE FROM playlist_track;] 2007-05-16 11:48:52.3912 Executing SQL statement: [DELETE FROM albums;] 2007-05-16 11:48:52.3915 Executing SQL statement: [DELETE FROM years;] 2007-05-16 11:48:52.3916 Executing SQL statement: [DELETE FROM contributors;] 2007-05-16 11:48:52.3919 Executing SQL statement: [DELETE FROM contributor_track;] 2007-05-16 11:48:52.3921 Executing SQL statement: [DELETE FROM contributor_album;] 2007-05-16 11:48:52.3923 Executing SQL statement: [DELETE FROM genres;] 2007-05-16 11:48:52.3925 Executing SQL statement: [DELETE FROM genre_track;] 2007-05-16 11:48:52.3927 Executing SQL statement: [DELETE FROM comments;] 2007-05-16 11:48:52.3929 Executing SQL statement: [DELETE FROM pluginversion;] 2007-05-16 11:48:52.3930 Executing SQL statement: [DELETE FROM unreadable_tracks;] 2007-05-16 11:48:52.3932 Executing SQL statement: [UPDATE metainformation SET value = 0 WHERE name = 'lastRescanTime';] 2007-05-16 11:48:52.3935 Executing SQL statement: [SET foreign_key_checks = 1;] 2007-05-16 11:48:52.4011 Connected to database dbi:mysql:hostname=127.0.0.1;port=9092;database=slimserver - schema version: [3] 2007-05-16 11:48:52.4013 Import: Start schema_optimize 2007-05-16 11:48:52.4184 Executing SQL file C:\Program Files\SlimServer\server\SQL\mysql\schema_optimize.sql 2007-05-16 11:48:52.4188 Executing SQL statement: [OPTIMIZE TABLE tracks;] 2007-05-16 11:48:52.4300 Executing SQL statement: [OPTIMIZE TABLE playlist_track;] 2007-05-16 11:48:52.4372 Executing SQL statement: [OPTIMIZE TABLE albums;] 2007-05-16 11:48:52.4463 Executing SQL statement: [OPTIMIZE TABLE years;] 2007-05-16 11:48:52.4536 Executing SQL statement: [OPTIMIZE TABLE contributors;] 2007-05-16 11:48:52.4623 Executing SQL statement: [OPTIMIZE TABLE contributor_track;] 2007-05-16 11:48:52.4733 Executing SQL statement: [OPTIMIZE TABLE contributor_album;] 2007-05-16 11:48:52.4825 Executing SQL statement: [OPTIMIZE TABLE genres;] 2007-05-16 11:48:52.4910 Executing SQL statement: [OPTIMIZE TABLE genre_track;] 2007-05-16 11:48:52.4998 Executing SQL statement: [OPTIMIZE TABLE comments;] 2007-05-16 11:48:52.5245 Executing SQL statement: [OPTIMIZE TABLE pluginversion;] 2007-05-16 11:48:52.5330 Executing SQL statement: [OPTIMIZE TABLE unreadable_tracks;] 2007-05-16 11:48:52.5417 Import: End schema_optimize 2007-05-16 11:48:52.5419 Import: End schema_clear 2007-05-16 11:48:52.5419 Import: Wiped info database 2007-05-16 11:48:52.5423 scanPathOrURL: Finding valid files in: g:\audio_test 2007-05-16 11:48:52.5427 About to look for files in G:\audio_test 2007-05-16 11:48:52.5451 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave|mp3|mp2|pls|xspf|flc|flac|m4a|mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|lnk)$)] 2007-05-16 11:48:52.5468 Found 3 files in G:\audio_test 2007-05-16 11:48:52.5501 flc file type for file:///G:/audio_test/Wes%20Montgomery%20-%20Full%20House%20(1962)%20(1991)%20[Flac]/09%20-%20Born%20To%20Be%20Blue.flac 2007-05-16 11:48:52.5503 ScanDirectory: Adding file:///G:/audio_test/Wes%20Montgomery%20-%20Full%20House%20(1962)%20(1991)%20[Flac]/09%20-%20Born%20To%20Be%20Blue.flac to database. 2007-05-16 11:48:52.5503 2007-05-16 11:48:52.5504 newTrack(): New Track: [file:///G:/audio_test/Wes%20Montgomery%20-%20Full%20House%20(1962)%20(1991)%20[Flac]/09%20-%20Born%20To%20Be%20Blue.flac] 2007-05-16 11:48:52.5504 newTrack(): readTags is 1 2007-05-16 11:48:52.5510 flc file type for G:\audio_test\Wes Montgomery - Full House (1962) (1991) [Flac]\09 - Born To Be Blue.flac 2007-05-16 11:48:52.5511 Trying to load Slim::Formats::FLAC 2007-05-16 11:48:52.5921 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, replay_gain, replay_peak, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '38997287', '699413.542600897', '2', 'flc', '0', '38997287', '1', '0', '0', '-0.38', '0.865723', '44100', '446', '1150787456', 'Born to Be Blue', 'BORN TO BE BLUE', 'BORN TO BE BLUE', '9', 'file:///G:/audio_test/Wes%20Montgomery%20-%20Full%20House%20(1962)%20(1991)%20[Flac]/09%20-%20Born%20To%20Be%20Blue.flac', '1962' 2007-05-16 11:48:52.6072 newTrack(): Created track 'Born to Be Blue' (id: [1]) 2007-05-16 11:48:52.6075 -- Track is a local track 2007-05-16 11:48:52.6076 Splitting Jazz & Guitar by & = Jazz Guitar 2007-05-16 11:48:52.6092 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'JAZZ' 2007-05-16 11:48:52.6218 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Jazz', 'JAZZ', 'JAZZ' 2007-05-16 11:48:52.6448 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '1', '1', '1' 2007-05-16 11:48:52.6569 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '1' 2007-05-16 11:48:52.6631 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'GUITAR' 2007-05-16 11:48:52.6646 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Guitar', 'GUITAR', 'GUITAR' 2007-05-16 11:48:52.6666 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '2', '1', '2', '1' 2007-05-16 11:48:52.6679 INSERT INTO genre_track (genre, track) VALUES (?, ?): '2', '1' 2007-05-16 11:48:52.6692 -- Track has genre 'Jazz & Guitar' 2007-05-16 11:48:52.6709 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'WES MONTGOMERY' 2007-05-16 11:48:52.6836 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Wes Montgomery', 'WES MONTGOMERY', 'WES MONTGOMERY' 2007-05-16 11:48:52.6906 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '1', '1', '1', '1', '1', '1' 2007-05-16 11:48:52.7031 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '1', '1' 2007-05-16 11:48:52.7086 -- Track has contributor 'Wes Montgomery' of role 'ARTIST' 2007-05-16 11:48:52.7087 -- Track has 1 contributor(s) 2007-05-16 11:48:52.7089 -- Track primary contributor is 'Wes Montgomery' (id: [1]) 2007-05-16 11:48:52.7090 -- Checking for discs 2007-05-16 11:48:52.7108 SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'Full House', 'file:///G:/audio_test/Wes%20Montgomery%20-%20Full%20House%20(1962)%20(1991)%20[Flac]%' 2007-05-16 11:48:52.7169 -- Searching for an album with: 2007-05-16 11:48:52.7173 --- tracks.url : { like => "file:///G:/audio_test/Wes%20Montgomery%20-%20Full%20House%20(1962)%20(1991)%20[Flac]%", } 2007-05-16 11:48:52.7174 --- me.disc : undef 2007-05-16 11:48:52.7175 --- me.title : "Full House" 2007-05-16 11:48:52.7175 --- me.discc : undef 2007-05-16 11:48:52.7300 INSERT INTO albums (title) VALUES (?): 'Full House' 2007-05-16 11:48:52.7642 -- Created album 'Full House' (id: [1]) 2007-05-16 11:48:52.7659 -- Updating album 'Full House' (id: [1]) with columns: 2007-05-16 11:48:52.7660 --- replay_peak : 1.000000 2007-05-16 11:48:52.7660 --- titlesort : FULL HOUSE 2007-05-16 11:48:52.7660 --- titlesearch : FULL HOUSE 2007-05-16 11:48:52.7661 --- replay_gain : -2.76 2007-05-16 11:48:52.7661 --- year : 1962 2007-05-16 11:48:52.7661 --- contributor : 1 2007-05-16 11:48:52.7666 -- Track has album 'Full House' (id: [1]) 2007-05-16 11:48:52.7680 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( album = ? AND contributor = ? ): '1', '1' 2007-05-16 11:48:52.7702 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '1', '1', '1', '1', '1', '1' 2007-05-16 11:48:52.7825 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '1', '1', '1' 2007-05-16 11:48:52.7921 -- Contributor 'Wes Montgomery' (id: [1]) linked to album 'Full House' (id: [1]) with role: 'ARTIST' 2007-05-16 11:48:52.7968 UPDATE albums SET contributor = ?, replay_gain = ?, replay_peak = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '1', '-2.76', '1.000000', 'FULL HOUSE', 'FULL HOUSE', '1962', '1' 2007-05-16 11:48:52.8027 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '1' 2007-05-16 11:48:52.8064 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '1962' 2007-05-16 11:48:52.8201 INSERT INTO years (id) VALUES (?): '1962' 2007-05-16 11:48:52.8350 flc file type for file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5%20[FLAC]/01%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5.flac 2007-05-16 11:48:52.8351 ScanDirectory: Adding file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5%20[FLAC]/01%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5.flac to database. 2007-05-16 11:48:52.8352 2007-05-16 11:48:52.8352 newTrack(): New Track: [file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5%20[FLAC]/01%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5.flac] 2007-05-16 11:48:52.8353 newTrack(): readTags is 1 2007-05-16 11:48:52.8362 flc file type for G:\audio_test\ - [FLAC]\01 - .flac 2007-05-16 11:48:52.8684 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, replay_gain, replay_peak, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '5101517', '534183.19650655', '2', 'flc', '0', '5101517', '1', '0', '0', '-1.45', '0.713654', '44100', '76.3333333333333', '1167573654', 'Волейбол на Сретенке', 'ВОЛЕЙБОЛ НА СРЕТЕНКЕ', 'ВОЛЕЙБОЛ НА СРЕТЕНКЕ', '1', 'file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5%20[FLAC]/01%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5.flac', '0' 2007-05-16 11:48:52.8858 newTrack(): Created track 'Волейбол на Сретенке' (id: [2]) 2007-05-16 11:48:52.8861 -- Track is a local track 2007-05-16 11:48:52.8877 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'БарХы' 2007-05-16 11:48:52.8896 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Барды', 'БарХы', 'БарХы' 2007-05-16 11:48:52.8919 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '3', '2', '3', '2' 2007-05-16 11:48:52.8936 INSERT INTO genre_track (genre, track) VALUES (?, ?): '3', '2' 2007-05-16 11:48:52.8946 -- Track has genre 'Барды' 2007-05-16 11:48:52.8965 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'ЮРИЙ ВИЗБОР' 2007-05-16 11:48:52.8991 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Юрий Визбор', 'ЮРИЙ ВИЗБОР', 'ЮРИЙ ВИЗБОР' 2007-05-16 11:48:52.9012 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '2', '1', '2', '2', '1', '2' 2007-05-16 11:48:52.9031 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '2', '1', '2' 2007-05-16 11:48:52.9042 -- Track has contributor 'Юрий Визбор' of role 'ARTIST' 2007-05-16 11:48:52.9043 -- Track has 1 contributor(s) 2007-05-16 11:48:52.9044 -- Track primary contributor is 'Юрий Визбор' (id: [2]) 2007-05-16 11:48:52.9046 -- Checking for discs 2007-05-16 11:48:52.9064 SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'Волейбол на Сретенке', 'file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5%20[FLAC]%' 2007-05-16 11:48:52.9319 -- Searching for an album with: 2007-05-16 11:48:52.9322 --- tracks.url : { like => "file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%C2%EE%EB%E5%E9%E1%EE%EB%20%ED%E0%20%D1%F0%E5%F2%E5%ED%EA%E5%20[FLAC]%", } 2007-05-16 11:48:52.9323 --- me.disc : undef 2007-05-16 11:48:52.9331 --- me.title : "\x{412}\x{43E}\x{43B}\x{435}\x{439}\x{431}\x{43E}\x{43B} \x{43D}\x{430} \x{421}\x{440}\x{435}\x{442}\x{435}\x{43D}\x{43A}\x{435}" 2007-05-16 11:48:52.9332 --- me.discc : undef 2007-05-16 11:48:52.9341 INSERT INTO albums (title) VALUES (?): 'Волейбол на Сретенке' 2007-05-16 11:48:52.9365 -- Created album 'Волейбол на Сретенке' (id: [2]) 2007-05-16 11:48:52.9383 -- Updating album 'Волейбол на Сретенке' (id: [2]) with columns: 2007-05-16 11:48:52.9383 --- replay_peak : 0.877899 2007-05-16 11:48:52.9384 --- titlesort : ВОЛЕЙБОЛ НА СРЕТЕНКЕ 2007-05-16 11:48:52.9384 --- titlesearch : ВОЛЕЙБОЛ НА СРЕТЕНКЕ 2007-05-16 11:48:52.9384 --- replay_gain : -2.25 2007-05-16 11:48:52.9385 --- year : 0 2007-05-16 11:48:52.9385 --- contributor : 2 2007-05-16 11:48:52.9390 -- Track has album 'Волейбол на Сретенке' (id: [2]) 2007-05-16 11:48:52.9400 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( album = ? AND contributor = ? ): '2', '2' 2007-05-16 11:48:52.9427 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '2', '2', '1', '2', '2', '1' 2007-05-16 11:48:52.9710 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '2', '2', '1' 2007-05-16 11:48:52.9725 -- Contributor 'Юрий Визбор' (id: [2]) linked to album 'Волейбол на Сретенке' (id: [2]) with role: 'ARTIST' 2007-05-16 11:48:52.9732 UPDATE albums SET contributor = ?, replay_gain = ?, replay_peak = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '2', '-2.25', '0.877899', 'ВОЛЕЙБОЛ НА СРЕТЕНКЕ', 'ВОЛЕЙБОЛ НА СРЕТЕНКЕ', '0', '2' 2007-05-16 11:48:52.9746 UPDATE tracks SET album = ? WHERE ( id = ? ): '2', '2' 2007-05-16 11:48:52.9770 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '0' 2007-05-16 11:48:52.9786 INSERT INTO years (id) VALUES (?): '0' 2007-05-16 11:48:52.9801 SELECT me.id, me.track, me.value FROM comments me WHERE ( me.track = ? AND me.value = ? ): '2', 'EAC Flac 1.1.2 -5' 2007-05-16 11:48:53.9923 INSERT INTO comments (track, value) VALUES (?, ?): '2', 'EAC Flac 1.1.2 -5' 2007-05-16 11:48:53.9978 -- Track has comment 'EAC Flac 1.1.2 -5' 2007-05-16 11:48:53.9992 mp3 file type for file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%EB%E5%F1%ED%EE%E5%20[MP3](128)/01%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%CB%E5%F1%ED%EE%E5.mp3 2007-05-16 11:48:53.9993 ScanDirectory: Adding file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%EB%E5%F1%ED%EE%E5%20[MP3](128)/01%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%CB%E5%F1%ED%EE%E5.mp3 to database. 2007-05-16 11:48:53.9994 2007-05-16 11:48:53.9994 newTrack(): New Track: [file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%EB%E5%F1%ED%EE%E5%20[MP3](128)/01%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%CB%E5%F1%ED%EE%E5.mp3] 2007-05-16 11:48:53.9995 newTrack(): readTags is 1 2007-05-16 11:48:53.0001 mp3 file type for G:\audio_test\ - [MP3](128)\01 - .mp3 2007-05-16 11:48:53.0002 Trying to load Slim::Formats::MP3 2007-05-16 11:48:53.0625 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, rating, remote, replay_gain, replay_peak, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '1317', '1975746', '128000', '1', 'mp3', '0', '1977161', '0', '0', '0', '-3.77', '0.724646', '44100', '123.48225', 'ID3v2.4.0', '1167573666', 'Солнышко лесное', 'СОЛНЫШКО ЛЕСНОЕ', 'СОЛНЫШКО ЛЕСНОЕ', '1', 'file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%EB%E5%F1%ED%EE%E5%20[MP3](128)/01%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%CB%E5%F1%ED%EE%E5.mp3', '0' 2007-05-16 11:48:53.0881 newTrack(): Created track 'Солнышко лесное' (id: [3]) 2007-05-16 11:48:53.0885 -- Track is a local track 2007-05-16 11:48:53.1102 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'БАРДЫ' 2007-05-16 11:48:53.1132 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Барды', 'БАРДЫ', 'БАРДЫ' 2007-05-16 11:48:53.1158 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '4', '3', '4', '3' 2007-05-16 11:48:53.1177 INSERT INTO genre_track (genre, track) VALUES (?, ?): '4', '3' 2007-05-16 11:48:53.1187 -- Track has genre 'Барды' 2007-05-16 11:48:53.1203 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'ЮРИЙ ВИЗБОР' 2007-05-16 11:48:53.1229 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '2', '1', '3', '2', '1', '3' 2007-05-16 11:48:53.1250 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '2', '1', '3' 2007-05-16 11:48:53.1261 -- Track has contributor 'Юрий Визбор' of role 'ARTIST' 2007-05-16 11:48:53.1272 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'ЮРИЙ ВИЗБОР' 2007-05-16 11:48:53.1295 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '2', '4', '3', '2', '4', '3' 2007-05-16 11:48:53.1310 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '2', '4', '3' 2007-05-16 11:48:53.1322 -- Track has contributor 'Юрий Визбор' of role 'BAND' 2007-05-16 11:48:53.1324 -- Track has 2 contributor(s) 2007-05-16 11:48:53.1325 -- Track primary contributor is 'Юрий Визбор' (id: [2]) 2007-05-16 11:48:53.1327 -- Checking for discs 2007-05-16 11:48:53.1343 SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id: 'Солнышко лесное', 'file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%EB%E5%F1%ED%EE%E5%20[MP3](128)%' 2007-05-16 11:48:53.1510 -- Searching for an album with: 2007-05-16 11:48:53.1513 --- tracks.url : { like => "file:///G:/audio_test/%DE%F0%E8%E9%20%C2%E8%E7%E1%EE%F0%20-%20%D1%EE%EB%ED%FB%F8%EA%EE%20%EB%E5%F1%ED%EE%E5%20[MP3](128)%", } 2007-05-16 11:48:53.1514 --- me.disc : undef 2007-05-16 11:48:53.1516 --- me.title : "\x{421}\x{43E}\x{43B}\x{43D}\x{44B}\x{448}\x{43A}\x{43E} \x{43B}\x{435}\x{441}\x{43D}\x{43E}\x{435}" 2007-05-16 11:48:53.1517 --- me.discc : undef 2007-05-16 11:48:53.1527 INSERT INTO albums (title) VALUES (?): 'Солнышко лесное' 2007-05-16 11:48:53.1546 -- Created album 'Солнышко лесное' (id: [3]) 2007-05-16 11:48:53.1563 -- Updating album 'Солнышко лесное' (id: [3]) with columns: 2007-05-16 11:48:53.1563 --- replay_peak : 0.784660 2007-05-16 11:48:53.1564 --- titlesort : СОЛНЫШКО ЛЕСНОЕ 2007-05-16 11:48:53.1564 --- titlesearch : СОЛНЫШКО ЛЕСНОЕ 2007-05-16 11:48:53.1565 --- replay_gain : -1.31 2007-05-16 11:48:53.1566 --- year : 0 2007-05-16 11:48:53.1567 --- contributor : 2 2007-05-16 11:48:53.1573 -- Track has album 'Солнышко лесное' (id: [3]) 2007-05-16 11:48:53.1583 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( album = ? AND contributor = ? ): '3', '2' 2007-05-16 11:48:53.1604 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '3', '2', '4', '3', '2', '4' 2007-05-16 11:48:53.1622 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '3', '2', '4' 2007-05-16 11:48:53.1637 -- Contributor 'Юрий Визбор' (id: [2]) linked to album 'Солнышко лесное' (id: [3]) with role: 'BAND' 2007-05-16 11:48:53.1651 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( album = ? AND contributor = ? ): '3', '2' 2007-05-16 11:48:53.1874 DELETE FROM contributor_album WHERE ( album = ? AND contributor = ? AND role = ? ): '3', '2', '4' 2007-05-16 11:48:53.1896 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '3', '2', '1', '3', '2', '1' 2007-05-16 11:48:53.1912 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '3', '2', '1' 2007-05-16 11:48:53.1926 -- Contributor 'Юрий Визбор' (id: [2]) linked to album 'Солнышко лесное' (id: [3]) with role: 'ARTIST' 2007-05-16 11:48:53.1933 UPDATE albums SET contributor = ?, replay_gain = ?, replay_peak = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '2', '-1.31', '0.784660', 'СОЛНЫШКО ЛЕСНОЕ', 'СОЛНЫШКО ЛЕСНОЕ', '0', '3' 2007-05-16 11:48:53.1947 UPDATE tracks SET album = ? WHERE ( id = ? ): '3', '3' 2007-05-16 11:48:53.1972 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '0' 2007-05-16 11:48:53.1989 Import: Starting mergeVariousArtistsAlbums(). 2007-05-16 11:48:53.2000 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'VARIOUS ARTISTS' 2007-05-16 11:48:53.2019 INSERT INTO contributors (name, namesearch, namesort) VALUES (?, ?, ?): 'Various Artists', 'VARIOUS ARTISTS', 'VARIOUS ARTISTS' 2007-05-16 11:48:53.2032 -- Created VARIOUS ARTIST (id: [3]) 2007-05-16 11:48:53.2047 SELECT COUNT( DISTINCT( me.id ) ) FROM albums me WHERE ( me.compilation IS NULL AND me.title != ? ): 'No Album' 2007-05-16 11:48:53.2069 SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( me.compilation IS NULL AND me.title != ? ) GROUP BY me.id: 'No Album' 2007-05-16 11:48:53.2113 -- VA postcheck for album 'Full House' (id: [1]) 2007-05-16 11:48:53.2140 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track: '1', '1' 2007-05-16 11:48:53.2212 --- Album has composite artist '1' 2007-05-16 11:48:53.2219 -- VA postcheck for album 'Волейбол на Сретенке' (id: [2]) 2007-05-16 11:48:53.2239 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track: '1', '2' 2007-05-16 11:48:53.2941 --- Album has composite artist '2' 2007-05-16 11:48:53.2948 -- VA postcheck for album 'Солнышко лесное' (id: [3]) 2007-05-16 11:48:53.2967 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track: '1', '3' 2007-05-16 11:48:53.3030 --- Album has composite artist '2' 2007-05-16 11:48:53.3033 Import: Completed mergeVariousAlbums Scan in 0 seconds. 2007-05-16 11:48:53.3034 Import: Starting findArtwork(). 2007-05-16 11:48:53.3042 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'lastRescanTime' 2007-05-16 11:48:53.3081 SELECT COUNT( DISTINCT( album ) ) FROM tracks me JOIN albums album ON ( album.id = me.album ) WHERE ( album.artwork IS NULL AND me.audio = ? AND me.timestamp >= ? ): '1', '0' 2007-05-16 11:48:53.3106 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me JOIN albums album ON ( album.id = me.album ) WHERE ( album.artwork IS NULL AND me.audio = ? AND me.timestamp >= ? ) GROUP BY album: '1', '0' 2007-05-16 11:48:53.3205 UPDATE tracks SET cover = ? WHERE ( id = ? ): 'G:\audio_test\Wes Montgomery - Full House (1962) (1991) [Flac]\cover.jpg', '1' 2007-05-16 11:48:53.3432 SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( ( ( me.id = ? ) ) ): '1' 2007-05-16 11:48:53.3467 Import: Album [Full House] has artwork. 2007-05-16 11:48:53.3475 UPDATE albums SET artwork = ? WHERE ( id = ? ): '1', '1' 2007-05-16 11:48:53.3814 Import: Completed findArtwork Scan in 0 seconds. 2007-05-16 11:48:53.3822 Import: Starting Database optimization. 2007-05-16 11:48:53.3822 Import: Start schema_optimize 2007-05-16 11:48:53.3827 Executing SQL file C:\Program Files\SlimServer\server\SQL\mysql\schema_optimize.sql 2007-05-16 11:48:53.3831 Executing SQL statement: [OPTIMIZE TABLE tracks;] 2007-05-16 11:48:53.4144 Executing SQL statement: [OPTIMIZE TABLE playlist_track;] 2007-05-16 11:48:53.4218 Executing SQL statement: [OPTIMIZE TABLE albums;] 2007-05-16 11:48:53.4309 Executing SQL statement: [OPTIMIZE TABLE years;] 2007-05-16 11:48:53.4389 Executing SQL statement: [OPTIMIZE TABLE contributors;] 2007-05-16 11:48:53.5131 Executing SQL statement: [OPTIMIZE TABLE contributor_track;] 2007-05-16 11:48:53.5222 Executing SQL statement: [OPTIMIZE TABLE contributor_album;] 2007-05-16 11:48:53.5310 Executing SQL statement: [OPTIMIZE TABLE genres;] 2007-05-16 11:48:53.5405 Executing SQL statement: [OPTIMIZE TABLE genre_track;] 2007-05-16 11:48:53.5497 Executing SQL statement: [OPTIMIZE TABLE comments;] 2007-05-16 11:48:53.5598 Executing SQL statement: [OPTIMIZE TABLE pluginversion;] 2007-05-16 11:48:53.6250 Executing SQL statement: [OPTIMIZE TABLE unreadable_tracks;] 2007-05-16 11:48:53.6580 Import: End schema_optimize 2007-05-16 11:48:53.6582 Import: Completed dbOptimize Scan in 0 seconds. 2007-05-16 11:48:53.6582 Import: Finished background scanning. 2007-05-16 11:48:53.6598 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'lastRescanTime' 2007-05-16 11:48:53.6616 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1179305333', 'lastRescanTime' 2007-05-16 11:48:53.6657 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2007-05-16 11:48:53.6672 UPDATE metainformation SET value = ? WHERE ( name = ? ): '0', 'isScanning' 2007-05-16 11:48:53.6691 forceCommit: syncing to the database. COMMIT COMMIT COMMIT COMMIT COMMIT