Problems with a playlist

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #331
    MCFH
    Participant

    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

    #4939
    rpedde
    Participant

    @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?

    #4940
    MCFH
    Participant

    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

    #4941
    rpedde
    Participant

    @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?

    #4942
    MCFH
    Participant

    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.

    #4943
    rpedde
    Participant

    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…

Viewing 6 posts - 1 through 6 (of 6 total)
  • The forum ‘Nightlies Feedback’ is closed to new topics and replies.