Unknown option: d_source 2007-03-08 09:29:34.8756 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2007-03-08 09:29:34.8967 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2007-03-08 09:29:34.9218 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1', 'isScanning' 2007-03-08 09:29:34.9448 Executing SQL statement: [SET foreign_key_checks = 0;] 2007-03-08 09:29:34.9456 Executing SQL statement: [DELETE FROM tracks;] 2007-03-08 09:29:34.9862 Executing SQL statement: [DELETE FROM playlist_track;] 2007-03-08 09:29:34.9872 Executing SQL statement: [DELETE FROM albums;] 2007-03-08 09:29:34.9893 Executing SQL statement: [DELETE FROM years;] 2007-03-08 09:29:34.9905 Executing SQL statement: [DELETE FROM contributors;] 2007-03-08 09:29:34.9918 Executing SQL statement: [DELETE FROM contributor_track;] 2007-03-08 09:29:35.0103 Executing SQL statement: [DELETE FROM contributor_album;] 2007-03-08 09:29:35.0120 Executing SQL statement: [DELETE FROM genres;] 2007-03-08 09:29:35.0132 Executing SQL statement: [DELETE FROM genre_track;] 2007-03-08 09:29:35.0188 Executing SQL statement: [DELETE FROM comments;] 2007-03-08 09:29:35.0205 Executing SQL statement: [DELETE FROM pluginversion;] 2007-03-08 09:29:35.0215 Executing SQL statement: [DELETE FROM unreadable_tracks;] 2007-03-08 09:29:35.0225 Executing SQL statement: [UPDATE metainformation SET value = 0 WHERE name = 'lastRescanTime';] 2007-03-08 09:29:35.0239 Executing SQL statement: [SET foreign_key_checks = 1;] 2007-03-08 09:29:35.0632 Executing SQL statement: [OPTIMIZE TABLE tracks;] 2007-03-08 09:29:35.1180 Executing SQL statement: [OPTIMIZE TABLE playlist_track;] 2007-03-08 09:29:35.1361 Executing SQL statement: [OPTIMIZE TABLE albums;] 2007-03-08 09:29:35.1626 Executing SQL statement: [OPTIMIZE TABLE years;] 2007-03-08 09:29:35.2340 Executing SQL statement: [OPTIMIZE TABLE contributors;] 2007-03-08 09:29:35.2593 Executing SQL statement: [OPTIMIZE TABLE contributor_track;] 2007-03-08 09:29:35.2844 Executing SQL statement: [OPTIMIZE TABLE contributor_album;] 2007-03-08 09:29:35.3013 Executing SQL statement: [OPTIMIZE TABLE genres;] 2007-03-08 09:29:35.3264 Executing SQL statement: [OPTIMIZE TABLE genre_track;] 2007-03-08 09:29:35.3383 Executing SQL statement: [OPTIMIZE TABLE comments;] 2007-03-08 09:29:35.3629 Executing SQL statement: [OPTIMIZE TABLE pluginversion;] 2007-03-08 09:29:35.3937 Executing SQL statement: [OPTIMIZE TABLE unreadable_tracks;] 2007-03-08 09:29:35.4151 scanPathOrURL: Finding valid files in: /var/spool/music/FLAC/B/Sam Brown/Ukulele and Voice - 5 Songs.../ 2007-03-08 09:29:35.4163 About to look for files in /var/spool/music/FLAC/B/Sam Brown/Ukulele and Voice - 5 Songs... 2007-03-08 09:29:35.4205 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave|mp3|mp2|m3u|pls|xspf|flc|flac|m4a|mov|m4b|mp4|cue|mp+|mpc|ogg|aif|aiff)$)] 2007-03-08 09:29:35.4299 Found 1 files in /var/spool/music/FLAC/B/Sam Brown/Ukulele and Voice - 5 Songs... 2007-03-08 09:29:35.6722 parseCUE: baseDir: [/var/spool/music/FLAC/B/Sam Brown/Ukulele and Voice - 5 Songs...] 2007-03-08 09:29:35.6751 URL: file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#0-135.333333333333 2007-03-08 09:29:35.6756 TRACKNUM: 1 2007-03-08 09:29:35.6762 URL: file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#135.333333333333-344.68 2007-03-08 09:29:35.6767 TRACKNUM: 2 2007-03-08 09:29:35.6771 URL: file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#344.68-587.68 2007-03-08 09:29:35.6775 TRACKNUM: 3 2007-03-08 09:29:35.6779 URL: file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#587.68-786.413333333333 2007-03-08 09:29:35.6783 TRACKNUM: 4 2007-03-08 09:29:35.6787 URL: file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#786.413333333333-886.453333333333 2007-03-08 09:29:35.6791 TRACKNUM: 5 2007-03-08 09:29:35.6804 matched: ALBUM = Ukulele and Voice - 5 Songs... 2007-03-08 09:29:35.6807 matched: ALBUMARTIST = Sam Brown 2007-03-08 09:29:35.6810 matched: ARTIST = Sam Brown 2007-03-08 09:29:35.6812 matched: ARTISTSORT = Brown, Sam 2007-03-08 09:29:35.6815 matched: ASIN = B000CFX6DQ 2007-03-08 09:29:35.6821 matched: DATE = 2005 2007-03-08 09:29:35.6824 matched: MUSICBRAINZ_ALBUMARTISTID = 8ec33fe2-4775-474c-a4a8-65dbbb98f87c 2007-03-08 09:29:35.6827 matched: MUSICBRAINZ_ALBUMID = 2e9a47a2-b945-4d49-b550-85c4a285322e 2007-03-08 09:29:35.6831 matched: MUSICBRAINZ_ALBUMSTATUS = official 2007-03-08 09:29:35.6834 matched: MUSICBRAINZ_ALBUMTYPE = EP 2007-03-08 09:29:35.6837 matched: TRACKNUMBER[1] = 1 2007-03-08 09:29:35.6840 grouped as track 1 2007-03-08 09:29:35.6844 matched: ARTIST[1] = Sam Brown 2007-03-08 09:29:35.6846 grouped as track 1 2007-03-08 09:29:35.6849 matched: ARTISTSORT[1] = Brown, Sam 2007-03-08 09:29:35.6852 grouped as track 1 2007-03-08 09:29:35.6854 matched: MUSICBRAINZ_ARTISTID[1] = 8ec33fe2-4775-474c-a4a8-65dbbb98f87c 2007-03-08 09:29:35.6857 grouped as track 1 2007-03-08 09:29:35.6860 matched: MUSICBRAINZ_TRACKID[1] = 509a26e7-cbfe-44d6-9229-f3107e15978e 2007-03-08 09:29:35.6863 grouped as track 1 2007-03-08 09:29:35.6865 matched: TITLE[1] = I'll Be Here 2007-03-08 09:29:35.6868 grouped as track 1 2007-03-08 09:29:35.6871 matched: TRACKNUMBER[2] = 2 2007-03-08 09:29:35.6874 grouped as track 2 2007-03-08 09:29:35.6876 matched: ARTIST[2] = Sam Brown 2007-03-08 09:29:35.6882 grouped as track 2 2007-03-08 09:29:35.6885 matched: ARTISTSORT[2] = Brown, Sam 2007-03-08 09:29:35.6888 grouped as track 2 2007-03-08 09:29:35.6890 matched: MUSICBRAINZ_ARTISTID[2] = 8ec33fe2-4775-474c-a4a8-65dbbb98f87c 2007-03-08 09:29:35.6893 grouped as track 2 2007-03-08 09:29:35.6896 matched: MUSICBRAINZ_TRACKID[2] = a7de012a-6f19-476e-b628-a2a6540ff78f 2007-03-08 09:29:35.6899 grouped as track 2 2007-03-08 09:29:35.6902 matched: TITLE[2] = Kiss of Love 2007-03-08 09:29:35.6904 grouped as track 2 2007-03-08 09:29:35.6907 matched: TRACKNUMBER[3] = 3 2007-03-08 09:29:35.6910 grouped as track 3 2007-03-08 09:29:35.6913 matched: ARTIST[3] = Sam Brown 2007-03-08 09:29:35.6916 grouped as track 3 2007-03-08 09:29:35.6919 matched: ARTISTSORT[3] = Brown, Sam 2007-03-08 09:29:35.6921 grouped as track 3 2007-03-08 09:29:35.6924 matched: MUSICBRAINZ_ARTISTID[3] = 8ec33fe2-4775-474c-a4a8-65dbbb98f87c 2007-03-08 09:29:35.6927 grouped as track 3 2007-03-08 09:29:35.6930 matched: MUSICBRAINZ_TRACKID[3] = c8ca42de-bbbe-4753-b377-82675da2d0cf 2007-03-08 09:29:35.6933 grouped as track 3 2007-03-08 09:29:35.6936 matched: TITLE[3] = Void 2007-03-08 09:29:35.6938 grouped as track 3 2007-03-08 09:29:35.6941 matched: TRACKNUMBER[4] = 4 2007-03-08 09:29:35.6944 grouped as track 4 2007-03-08 09:29:35.6947 matched: ARTIST[4] = Sam Brown 2007-03-08 09:29:35.6950 grouped as track 4 2007-03-08 09:29:35.6953 matched: ARTISTSORT[4] = Brown, Sam 2007-03-08 09:29:35.6956 grouped as track 4 2007-03-08 09:29:35.6959 matched: MUSICBRAINZ_ARTISTID[4] = 8ec33fe2-4775-474c-a4a8-65dbbb98f87c 2007-03-08 09:29:35.6962 grouped as track 4 2007-03-08 09:29:35.6964 matched: MUSICBRAINZ_TRACKID[4] = a6fcfdf3-5970-46a6-bb1b-c4cdf63eb83e 2007-03-08 09:29:35.6967 grouped as track 4 2007-03-08 09:29:35.6970 matched: TITLE[4] = Away With the Faeries 2007-03-08 09:29:35.6973 grouped as track 4 2007-03-08 09:29:35.6976 matched: TRACKNUMBER[5] = 5 2007-03-08 09:29:35.6979 grouped as track 5 2007-03-08 09:29:35.6981 matched: ARTIST[5] = Sam Brown 2007-03-08 09:29:35.6984 grouped as track 5 2007-03-08 09:29:35.6987 matched: ARTISTSORT[5] = Brown, Sam 2007-03-08 09:29:35.6990 grouped as track 5 2007-03-08 09:29:35.6993 matched: MUSICBRAINZ_ARTISTID[5] = 8ec33fe2-4775-474c-a4a8-65dbbb98f87c 2007-03-08 09:29:35.6996 grouped as track 5 2007-03-08 09:29:35.7001 matched: MUSICBRAINZ_TRACKID[5] = 0c9132b5-268b-403f-9901-e722c3542778 2007-03-08 09:29:35.7004 grouped as track 5 2007-03-08 09:29:35.7007 matched: TITLE[5] = Over the Moon 2007-03-08 09:29:35.7010 grouped as track 5 2007-03-08 09:29:35.7049 parse: calculating duration for anchor: 135.333333333333 2007-03-08 09:29:35.7052 parse: calculating header 0, startbytes 0 and endbytes 12472954 2007-03-08 09:29:35.7098 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 WHERE ( url = ? ): 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#0-135.333333333333' 2007-03-08 09:29:35.7556 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, lossless, musicbrainz_id, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '12472954', '736493.682690572', '2', 'flc', '1', '509a26e7-cbfe-44d6-9229-f3107e15978e', '0', '0', '44100', '135.333333333333', '1171620261', 'I'll Be Here', 'I LL BE HERE', 'I LL BE HERE', '1', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#0-135.333333333333', '2005' 2007-03-08 09:29:35.8011 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NO GENRE' 2007-03-08 09:29:35.8389 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'No Genre', 'NO GENRE', 'NO GENRE' 2007-03-08 09:29:35.8594 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NO GENRE' 2007-03-08 09:29:35.8671 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-03-08 09:29:35.9045 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '1' 2007-03-08 09:29:35.9252 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:35.9634 INSERT INTO contributors (musicbrainz_id, name, namesearch, namesort) VALUES (?, ?, ?, ?): 'NULL', 'Sam Brown', 'SAM BROWN', 'SAM BROWN' 2007-03-08 09:29:35.9843 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', '5', '1', '1', '5', '1' 2007-03-08 09:29:36.0257 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '1' 2007-03-08 09:29:36.0462 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.0538 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', '6', '1', '1', '6', '1' 2007-03-08 09:29:36.0587 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '6', '1' 2007-03-08 09:29:36.0683 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: 'Ukulele and Voice - 5 Songs...', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs...%' 2007-03-08 09:29:36.1081 INSERT INTO albums (title) VALUES (?): 'Ukulele and Voice - 5 Songs...' 2007-03-08 09:29:36.1381 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', '5', '1', '1', '5' 2007-03-08 09:29:36.2274 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '1', '1', '5' 2007-03-08 09:29:36.2494 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', '6', '1', '1', '6' 2007-03-08 09:29:36.2543 INSERT INTO contributor_album (album, contributor, role) VALUES (?, ?, ?): '1', '1', '6' 2007-03-08 09:29:36.2733 UPDATE albums SET contributor = ?, musicbrainz_id = ?, titlesearch = ?, titlesort = ?, year = ? WHERE ( id = ? ): '1', '2e9a47a2-b945-4d49-b550-85c4a285322e', 'UKULELE AND VOICE 5 SONGS', 'UKULELE AND VOICE 5 SONGS', '2005', '1' 2007-03-08 09:29:36.2906 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '1' 2007-03-08 09:29:36.2997 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '2005' 2007-03-08 09:29:36.3368 INSERT INTO years (id) VALUES (?): '2005' 2007-03-08 09:29:36.3544 parse: calculating duration for anchor: 209.346666666667 2007-03-08 09:29:36.3548 parse: calculating header 0, startbytes 12472954 and endbytes 31767323 2007-03-08 09:29:36.3590 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 WHERE ( url = ? ): 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#135.333333333333-344.68' 2007-03-08 09:29:36.3714 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, lossless, musicbrainz_id, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '19294369', '736493.682690572', '2', 'flc', '1', 'a7de012a-6f19-476e-b628-a2a6540ff78f', '0', '0', '44100', '209.346666666667', '1171620261', 'Kiss of Love', 'KISS OF LOVE', 'KISS OF LOVE', '2', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#135.333333333333-344.68', '2005' 2007-03-08 09:29:36.3791 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NO GENRE' 2007-03-08 09:29:36.3861 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '2', '1', '2' 2007-03-08 09:29:36.3906 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '2' 2007-03-08 09:29:36.3972 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.4055 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', '5', '2', '1', '5', '2' 2007-03-08 09:29:36.4104 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '2' 2007-03-08 09:29:36.4175 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.4247 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', '6', '2', '1', '6', '2' 2007-03-08 09:29:36.4299 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '6', '2' 2007-03-08 09:29:36.4820 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-03-08 09:29:36.4992 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', '5', '1', '1', '5' 2007-03-08 09:29:36.5081 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', '6', '1', '1', '6' 2007-03-08 09:29:36.5134 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '2' 2007-03-08 09:29:36.5212 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '2005' 2007-03-08 09:29:36.5272 parse: calculating duration for anchor: 243 2007-03-08 09:29:36.5275 parse: calculating header 0, startbytes 31767323 and endbytes 54163342 2007-03-08 09:29:36.5332 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 WHERE ( url = ? ): 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#344.68-587.68' 2007-03-08 09:29:36.5458 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, lossless, musicbrainz_id, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '22396019', '736493.682690572', '2', 'flc', '1', 'c8ca42de-bbbe-4753-b377-82675da2d0cf', '0', '0', '44100', '243', '1171620261', 'Void', 'VOID', 'VOID', '3', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#344.68-587.68', '2005' 2007-03-08 09:29:36.5552 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NO GENRE' 2007-03-08 09:29:36.5637 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '3', '1', '3' 2007-03-08 09:29:36.5695 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '3' 2007-03-08 09:29:36.5777 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.5853 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', '5', '3', '1', '5', '3' 2007-03-08 09:29:36.5912 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '3' 2007-03-08 09:29:36.5996 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.6068 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', '6', '3', '1', '6', '3' 2007-03-08 09:29:36.6179 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '6', '3' 2007-03-08 09:29:36.6275 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-03-08 09:29:36.6428 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', '5', '1', '1', '5' 2007-03-08 09:29:36.6501 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', '6', '1', '1', '6' 2007-03-08 09:29:36.6547 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '3' 2007-03-08 09:29:36.6620 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '2005' 2007-03-08 09:29:36.6658 parse: calculating duration for anchor: 198.733333333333 2007-03-08 09:29:36.6661 parse: calculating header 0, startbytes 54163342 and endbytes 72479537 2007-03-08 09:29:36.6701 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 WHERE ( url = ? ): 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#587.68-786.413333333333' 2007-03-08 09:29:36.6825 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, lossless, musicbrainz_id, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '18316195', '736493.682690572', '2', 'flc', '1', 'a6fcfdf3-5970-46a6-bb1b-c4cdf63eb83e', '0', '0', '44100', '198.733333333333', '1171620261', 'Away With the Faeries', 'AWAY WITH THE FAERIES', 'AWAY WITH THE FAERIES', '4', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#587.68-786.413333333333', '2005' 2007-03-08 09:29:36.6905 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NO GENRE' 2007-03-08 09:29:36.6977 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '4', '1', '4' 2007-03-08 09:29:36.7022 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '4' 2007-03-08 09:29:36.7091 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.7172 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', '5', '4', '1', '5', '4' 2007-03-08 09:29:36.7224 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '4' 2007-03-08 09:29:36.7295 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.7372 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', '6', '4', '1', '6', '4' 2007-03-08 09:29:36.7421 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '6', '4' 2007-03-08 09:29:36.7513 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-03-08 09:29:36.7670 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', '5', '1', '1', '5' 2007-03-08 09:29:36.7744 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', '6', '1', '1', '6' 2007-03-08 09:29:36.7791 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '4' 2007-03-08 09:29:36.7856 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '2005' 2007-03-08 09:29:36.7896 parse: calculating duration for anchor: 100.04 2007-03-08 09:29:36.7899 parse: calculating header 0, startbytes 72479537 and endbytes 81699692 2007-03-08 09:29:36.7943 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 WHERE ( url = ? ): 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#786.413333333333-886.453333333333' 2007-03-08 09:29:36.8069 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, lossless, musicbrainz_id, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '9220155', '736493.682690572', '2', 'flc', '1', '0c9132b5-268b-403f-9901-e722c3542778', '0', '0', '44100', '100.04', '1171620261', 'Over the Moon', 'OVER THE MOON', 'OVER THE MOON', '5', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac#786.413333333333-886.453333333333', '2005' 2007-03-08 09:29:36.8147 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'NO GENRE' 2007-03-08 09:29:36.8227 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '1', '5', '1', '5' 2007-03-08 09:29:36.8272 INSERT INTO genre_track (genre, track) VALUES (?, ?): '1', '5' 2007-03-08 09:29:36.8340 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.8417 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', '5', '5', '1', '5', '5' 2007-03-08 09:29:36.8466 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '5', '5' 2007-03-08 09:29:36.8539 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 = ? ) ): 'SAM BROWN' 2007-03-08 09:29:36.8612 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', '6', '5', '1', '6', '5' 2007-03-08 09:29:36.8664 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '1', '6', '5' 2007-03-08 09:29:36.8764 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-03-08 09:29:36.8913 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', '5', '1', '1', '5' 2007-03-08 09:29:36.8985 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', '6', '1', '1', '6' 2007-03-08 09:29:36.9033 UPDATE tracks SET album = ? WHERE ( id = ? ): '1', '5' 2007-03-08 09:29:36.9096 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '2005' 2007-03-08 09:29:36.9134 returning: 5 items 2007-03-08 09:29:36.9267 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '0', '0', '81699693', '736493.682690572', '2', 'fec', '0', '81699693', '1', '0', '0', '44100', '886.453333333333', '1171620261', 'Ukulele and Voice - 5 Songs...', 'UKULELE AND VOICE 5 SONGS', 'UKULELE AND VOICE 5 SONGS', 'file:///var/spool/music/FLAC/B/Sam%20Brown/Ukulele%20and%20Voice%20-%205%20Songs.../Sam%20Brown%20-%20Ukulele%20and%20Voice%20-%205%20Songs....flac', '2005' 2007-03-08 09:29:36.9372 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-03-08 09:29:36.9428 INSERT INTO contributors (name, namesearch, namesort) VALUES (?, ?, ?): 'Various Artists', 'VARIOUS ARTISTS', 'VARIOUS ARTISTS' 2007-03-08 09:29:36.9527 SELECT COUNT( DISTINCT( me.id ) ) FROM albums me WHERE ( me.compilation IS NULL AND me.title != ? ): 'No Album' 2007-03-08 09:29:36.9582 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-03-08 09:29:36.9703 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-03-08 09:29:36.9777 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'lastRescanTime' 2007-03-08 09:29:36.9862 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-03-08 09:29:36.9928 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-03-08 09:29:37.0462 UPDATE tracks SET cover = ? WHERE ( id = ? ): '1', '1' 2007-03-08 09:29:37.0541 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-03-08 09:29:37.0600 UPDATE albums SET artwork = ? WHERE ( id = ? ): '1', '1' 2007-03-08 09:29:37.0652 Executing SQL statement: [OPTIMIZE TABLE tracks;] 2007-03-08 09:29:37.1166 Executing SQL statement: [OPTIMIZE TABLE playlist_track;] 2007-03-08 09:29:37.1442 Executing SQL statement: [OPTIMIZE TABLE albums;] 2007-03-08 09:29:37.1845 Executing SQL statement: [OPTIMIZE TABLE years;] 2007-03-08 09:29:37.2090 Executing SQL statement: [OPTIMIZE TABLE contributors;] 2007-03-08 09:29:37.2429 Executing SQL statement: [OPTIMIZE TABLE contributor_track;] 2007-03-08 09:29:37.2680 Executing SQL statement: [OPTIMIZE TABLE contributor_album;] 2007-03-08 09:29:37.2930 Executing SQL statement: [OPTIMIZE TABLE genres;] 2007-03-08 09:29:37.3164 Executing SQL statement: [OPTIMIZE TABLE genre_track;] 2007-03-08 09:29:37.3401 Executing SQL statement: [OPTIMIZE TABLE comments;] 2007-03-08 09:29:37.3557 Executing SQL statement: [OPTIMIZE TABLE pluginversion;] 2007-03-08 09:29:37.3861 Executing SQL statement: [OPTIMIZE TABLE unreadable_tracks;] 2007-03-08 09:29:37.4246 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'lastRescanTime' 2007-03-08 09:29:37.4299 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1173346177', 'lastRescanTime' 2007-03-08 09:29:37.4384 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2007-03-08 09:29:37.4445 UPDATE metainformation SET value = ? WHERE ( name = ? ): '0', 'isScanning' COMMIT COMMIT COMMIT COMMIT COMMIT