FireFly Media Server

13/08/2006 at 4:45 PM #5891

Participant

As before, any songs that are referenced in my test .m3u Playlist has the actual filename as the “Name” of the song and not the song name in the metadata. (The rest of the song metadata is correct.) If I remove the playlist, all is fine.

In the log, I see Path not found errors for each entry when it parses the playlist… even though the path is valid. Not sure if this actually means anything. Example:

2006-08-13 05:07:29 (f3f11f6d): Checking C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3

2006-08-13 05:07:29 (f3f11f6d): Executing: select * from songs where upper(path)=upper('C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3') and idx=0

2006-08-13 05:07:29 (f3f11f6d): Executing: INSERT INTO updated VALUES (1067)

2006-08-13 05:07:29 (f3f11f6d): Rows: 15825

2006-08-13 05:07:29 (f3f11f6d): Resolved C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3 to 1067

2006-08-13 05:07:29 (f3f11f6d): Executing: select type from playlists where id=3

2006-08-13 05:07:29 (f3f11f6d): Executing: select count(*) from songs where id=1067

2006-08-13 05:07:29 (f3f11f6d): Executing: insert into playlistitems (playlistid, songid) values (3,1067)

2006-08-13 05:07:29 (f3f11f6d): Rows: 15826

2006-08-13 05:07:29 (f3f11f6d): Checking C:Documents and SettingsgrommetMy DocumentsMy MusicMy Playlists

2006-08-13 05:07:29 (f3f11f6d): Executing: select * from songs where upper(path)=upper('C:Documents and SettingsgrommetMy DocumentsMy MusicMy Playlists') and idx=0

2006-08-13 05:07:29 (f3f11f6d): Playlist entry  bad: Path not found

The entry in the .m3u located in C:Documents and SettingsgrommetMy DocumentsMy MusicMy Playlists looks like this:

#EXTINF:0,Ben Folds - Make Me Mommy.mp3

..Ben Folds - Make Me Mommy.mp3

Here is what Firefly did in the initial scan:

2006-08-13 03:37:30 (f3f11f6d): Rows: 1

2006-08-13 03:37:30 (f3f11f6d): Found C:Documents and SettingsgrommetMy DocumentsMy Music/Ben Folds - Make Me Mommy.mp3

2006-08-13 03:37:30 (f3f11f6d): Found music file: Ben Folds - Make Me Mommy.mp3

2006-08-13 03:37:30 (f3f11f6d): Codec type: mpeg

2006-08-13 03:37:30 (f3f11f6d):  Title: Make Me Mommy

2006-08-13 03:37:30 (f3f11f6d):  Track 4 of 0

2006-08-13 03:37:30 (f3f11f6d):  Genre: 20

2006-08-13 03:37:30 (f3f11f6d):  Album: Rockin' the Suburbs CD5 (UK)

2006-08-13 03:37:30 (f3f11f6d):  Orchestra: Ben Folds

2006-08-13 03:37:30 (f3f11f6d):  Artist: Ben Folds

2006-08-13 03:37:30 (f3f11f6d):  Year: 2001

2006-08-13 03:37:30 (f3f11f6d): Got id3 tag successfully

2006-08-13 03:37:30 (f3f11f6d): Found ID3 header

2006-08-13 03:37:30 (f3f11f6d): Header length: 2078

2006-08-13 03:37:30 (f3f11f6d): Reading in new block at 2088

2006-08-13 03:37:30 (f3f11f6d): valid header at 0

2006-08-13 03:37:30 (f3f11f6d): Found valid frame at 0828

2006-08-13 03:37:30 (f3f11f6d): Checking at 0a9a

2006-08-13 03:37:30 (f3f11f6d):  MPEG Version: 1

2006-08-13 03:37:30 (f3f11f6d):  Layer: 3

2006-08-13 03:37:30 (f3f11f6d):  Sample Rate: 44100

2006-08-13 03:37:30 (f3f11f6d):  Bit Rate: 192

2006-08-13 03:37:30 (f3f11f6d): Starting aggressive file length scan

2006-08-13 03:37:30 (f3f11f6d): Starting frame count

2006-08-13 03:37:30 (f3f11f6d): File appears to be CBR... quitting frame count

2006-08-13 03:37:30 (f3f11f6d):  Song Length: 138323

2006-08-13 03:37:30 (f3f11f6d):  Date Added: 1049993663

2006-08-13 03:37:30 (f3f11f6d):  Codec: mpeg

2006-08-13 03:37:30 (f3f11f6d): Executing: INSERT INTO songs VALUES (NULL,'C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3','Ben Folds - Make Me Mommy.mp3','Make Me Mommy','Ben Folds','Rockin'' the Suburbs CD5 (UK)','Alternative','','mp3','','Ben Folds','','','',192,44100,138323,3321856,2001,4,0,0,0,0,0,0,0,0,2,'MPEG audio file',1049993663,1118503651,0,1155465450,0,0,0,'mpeg',0,0,0)

And here is what happens when it sees the iTunes reference:

2006-08-13 05:08:20 (f3f11f6d): Scanning iTunes id #302

2006-08-13 05:08:20 (f3f11f6d): scan_path: file://localhost/C:/Documents and Settings/grommet/My Documents/My Music/Ben Folds - Make Me Mommy.mp3

2006-08-13 05:08:20 (f3f11f6d): Executing: select * from songs where upper(path)=upper('C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3') and idx=0

2006-08-13 05:08:20 (f3f11f6d): Executing: INSERT INTO updated VALUES (1067)

2006-08-13 05:08:20 (f3f11f6d): Rows: 16575

2006-08-13 05:08:20 (f3f11f6d): Executing: select count(*) from songs where path='C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3' and idx=0

2006-08-13 05:08:20 (f3f11f6d): Executing: UPDATE songs SET title='Make Me Mommy',artist='Ben Folds',album='Rockin'' the Suburbs CD5 (UK)',genre='Alternative',comment='',type='mp3',composer='',orchestra='Ben Folds',conductor='',grouping='',url='',bitrate=192,samplerate=44100,song_length=138318,file_size=3321856,year=2001,track=4,total_tracks=0,disc=0,total_discs=0,

time_modified=1118503651,db_timestamp=1155470900,bpm=0,disabled=0,compilation=0,rating=0,sample_count=0,codectype='mpeg' WHERE path='C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3' and idx=0

2006-08-13 05:08:20 (f3f11f6d): Rows: 16576

2006-08-13 05:08:20 (f3f11f6d): Executing: insert into updated (id) select id from songs where path='C:Documents and SettingsgrommetMy DocumentsMy MusicBen Folds - Make Me Mommy.mp3' and idx=0

2006-08-13 05:08:20 (f3f11f6d): Rows: 16577