Problems with a playlist

[MCFH]

Ron,
One of my playlists is causing problems – I don’t believe this is your UTF8 issue. Here is the log for a regular playlist:

2006-06-01 : Found playlist: Default

2006-06-01 : Creating playlist for Default

2006-06-01 : Executing: select * from playlists where path='c:documents and settingsitunesmy documentsmy musicitunesitunes music library.xml' and idx=3737

2006-06-01 : Executing: insert into plupdated values (725)

2006-06-01 : Rows: 1

2006-06-01 : Executing: select type from playlists where id=725

2006-06-01 : Executing: delete from playlists where id=725

2006-06-01 : Rows: 1

2006-06-01 : Executing: delete from playlistitems where playlistid=725

2006-06-01 : Rows: 1183

2006-06-01 : Executing: select count(*) from playlists where upper(title)=upper('Default')

2006-06-01 : Executing: insert into playlists (title,type,items,query,db_timestamp,path,idx) values ('Default',3,0,NULL,1149195898,'c:documents and settingsitunesmy documentsmy musicitunesitunes music library.xml',3737)

2006-06-01 : Rows: 1

2006-06-01 : Executing: select id from playlists where title='Default'

2006-06-01 : Executing: insert into plupdated values (733)

2006-06-01 : Rows: 1

2006-06-01 : Adding itunes track #518

2006-06-01 : Executing: select type from playlists where id=733

2006-06-01 : Executing: select count(*) from songs where id=147

2006-06-01 : Executing: insert into playlistitems (playlistid, songid) values (733,147)

Here is the log for the bad playlist:

2006-06-06 : Found playlist: Aspects of Love

2006-06-06 : Creating playlist for Aspects of Love

2006-06-06 : Executing: select * from playlists where path='c:documents and settingsitunesmy documentsmy musicitunesitunes music library.xml' and idx=5246

2006-06-06 : Executing: insert into plupdated values (4323)

2006-06-06 : Rows: 1

2006-06-06 : Executing: select type from playlists where id=4323

2006-06-06 : Executing: delete from playlists where id=4323

2006-06-06 : Rows: 1

2006-06-06 : Executing: delete from playlistitems where playlistid=4323

2006-06-06 : Rows: 0

2006-06-06 : Executing: select count(*) from playlists where upper(title)=upper('Aspects of Love')

2006-06-06 : Executing: insert into playlists (title,type,items,query,db_timestamp,path,idx) values ('Aspects of Love',3,0,NULL,1149626631,'c:documents and settingsitunesmy documentsmy musicitunesitunes music library.xml',5246)

2006-06-06 : Rows: 1

2006-06-06 : Executing: select id from playlists where title='Aspects of Love'

2006-06-06 : Executing: insert into plupdated values (4331)

2006-06-06 : Rows: 1

2006-06-06 : Adding itunes track #1445

2006-06-06 : Adding itunes track #1446

2006-06-06 : Adding itunes track #1447

2006-06-06 : Adding itunes track #1448

2006-06-06 : Adding itunes track #1449

2006-06-06 : Adding itunes track #1450

2006-06-06 : Adding itunes track #1451

2006-06-06 : Adding itunes track #1452

2006-06-06 : Adding itunes track #1453

2006-06-06 : Adding itunes track #1454

2006-06-06 : Adding itunes track #1455

2006-06-06 : Adding itunes track #1456

2006-06-06 : Adding itunes track #1457

2006-06-06 : Adding itunes track #1458

2006-06-06 : Adding itunes track #1459

2006-06-06 : Adding itunes track #1460

2006-06-06 : Adding itunes track #1461

2006-06-06 : Adding itunes track #1462

2006-06-06 : Adding itunes track #1463

2006-06-06 : Adding itunes track #1464

20

From my reading of this the SQL for adding the tracks is never executed.

Regards
Mark

[rpedde]

@MCFH wrote:

From my reading of this the SQL for adding the tracks is never executed.

It wasn’t able to locate that file in the path it exists in the itunes music file.xml, and it wasn’t able to map it to a file in your mp3_dir.

What’s the path to the file it’s looking for? Say track #1445 as numbered from the iTunes xml file?

[MCFH]

It’s there…
(in the XML)
file://localhost/C:/Documents%20and%20Settings/iTunes/My%20Documents/My%20Music/iTunes/iTunes%20Music/Andrew%20Lloyd%20Webber/Aspects%20Of%20Love%20%5BRemastered%5D%20%5BDisc%201%5D/1-01%20Railway%20Station%20At%20Pau,%201961%20(L.aif

(in the directory structure)
C:Documents and SettingsiTunesMy DocumentsMy MusiciTunesiTunes MusicAndrew Lloyd WebberAspects Of Love [Remastered] [Disc 1]1-01 Railway Station At Pau, 1961 (L.aif

Note that there is another 16 characters on my version which I have removed to change the username in use…

Regards
Mark

[rpedde]

@MCFH wrote:

It’s there…
(in the XML)
file://localhost/C:/Documents%20and%20Settings/iTunes/My%20Documents/My%20Music/iTunes/iTunes%20Music/Andrew%20Lloyd%20Webber/Aspects%20Of%20Love%20%5BRemastered%5D%20%5BDisc%201%5D/1-01%20Railway%20Station%20At%20Pau,%201961%20(L.aif

is aif in your extensions lists?

[MCFH]

OK – adding .AIF fixed the contents of the playlist problem – can you I suggest an enhancement request to warn that a file existed in the playlist in an unrecognised format and will be ignored.

When I added the .aif extension (via the web config page) Firefly got sick and the Soundbridge was no longer able to connect to it. Stopping and restarting the server cured that problem.

The above leads onto the next problem – can you serve AIFF files? The Soundbridge can clearly handle them since I get them from iTunes but with yours I get a cross besides them. If not this should probably be an enhancement request for the poor Pinnacle users?

One other suggestion – you need to write a resource DLL and create a resource with the event ID 1 and register this DLL with the event viewer application (see http://msdn.microsoft.com/library/en-us/eventlog/base/adding_a_source_to_the_registry.asp?frame=true)

So that we don’t get the guff at the front of the event log warnings.

[rpedde]

The above leads onto the next problem – can you serve AIFF files? The Soundbridge can clearly handle them since I get them from iTunes but with yours I get a cross besides them. If not this should probably be an enhancement request for the poor Pinnacle users?

Yes, but I don’t know what the codectype as reported by iTunes is. (aiff, probably?) I’ll see if I can track that down.

One other suggestion – you need to write a resource DLL and create a resource with the event ID 1 and register this DLL with the event viewer application (see http://msdn.microsoft.com/library/en-us/eventlog/base/adding_a_source_to_the_registry.asp?frame=true)

it’s there, and I used to do a “mt-daapd -i” on install to set up the service and register the message dll, but since I stopped registering it that way, I keep forgetting to self-register on startup. Note to self…

[Author]

Posts