Bugzilla – Bug 1278
itunes playlists coming up empty or not at all
Last modified: 2009-09-08 09:18:03 UTC
received quite a few reports of this, but i haven't been able to reproduce it myself. it's difficult to have people work around this since there are many steps, so each time it comes up it's like a 20-30 minute call... what i know of the problem: - seems to occur more frequently with users who have changed their itunes music folder within itunes to something other than the default. (default being ~/Music/iTunes/iTunes Music/ on osx or C:\Documents and Settings\username\My Documents\My Music\iTunes\iTunes Music\ on windows) - seems to occur when the Music Folder setting in server settings is set to the same folder that the itunes content is in - seems to occur more frequently on windows, though i did talk to a couple of folks who have seen it on osx as well the workaround i've been having people use: - set the music folder to blank and stop the server - remove slimserversql.db - restart the server this seems to work just about every time...but it's tedious especially on windows.
I can't reproduce this either. Mostly becuase I can't even get to point one of yoru conditions. iTunes will never complain when I try to relocate my XML file, but it also completely ignores it. Any live updates are always done to the default location no matter what I try to tell it to do. In cases where users have moved the file, can they confirm that the old location has been left behind? It may be that selecting a new location doesn't create a proper xml file.
it's not from moving the XML file it's from changing your iTunes Music Folder location. the xml file always stays in the same spot, but the content has moved.
This is a serious issue for our tech support team.
A few questions - when they changed the location of their iTunes library - did they also change their Music Folder? Or did it become different at that point? After they changed the location in iTunes, did they manually rescan, or did the iTunes checker pick it up?
there is an key in teh xml for music folder. we should make sure that itunes is actually updating this when the user changes folders from itunes. we should also make sure we are checking against that for any changes when starting a rescan. any logs or sample xml files may help. working and non-working comparisons too.
--- A few questions - when they changed the location of their iTunes library - did they also change their Music Folder? Or did it become different at that point? After they changed the location in iTunes, did they manually rescan, or did the iTunes checker pick it up? --- i don't think this is really relevant since most of these people i've talked to i think are installing 6.0.0 from scratch, or have upgraded from 5.4 awaiting an sb2 (which on windows should blow away the prefs file), and anyway it's not the act of changing your itunes music folder that causes this. nobody went and changed their music folder at the same time as upgrading to 6.0.0. in fact i've talked to a few customers whose music folders were just set to C:\Documents and Settings\username\My Documents\My Music\iTunes\iTunes Music\. that was just a note saying that it seems to occur more often with people who have changed their music folder... and no, i don't think in any of these cases was the itunes music library setting DIFFERENT than the XML (i.e. corrupt database), because if the workaround i specified WORKED, that would mean that the paths match up properly and we can access the files. and it is mostly on windows--but not only.
i think the point is getting missed here. IN ALL CASES i've had reported to me: - Music Folder in SlimServer was set to the same folder as iTunes had its music folder set as - Use iTunes was enabled - UNSETTING the music folder and wiping the db made it behave as expected Those are the ONLY commonalities I've seen in ALL calls/emails about this.
Is this limited to playlists, or actual tracks as well?
i thought playlists and tracks, but the tracks issue may be related to the daylight savings issue vidur posted about on discuss...
just talked to someone again this morning using 6.0.1 and his playlists weren't showing up...
Kevin - I need a iTunes .xml file to debug this further. A d_itunes would be nice too.
Created attachment 412 [details] Itunes xml file
Will - can you run with --d_itunes ? Start without any database file. Thanks.
Wil - also, are your playlists showing up empty, or not at all?
got another report of playlists not showing up at all: - windows xp - ss 6.0.1 - itunes music folder in an alternate location will attach his itunes music library.xml file, and a d_itunes log should be on its way.
Created attachment 427 [details] another xml file
Created attachment 433 [details] yet another xml file
Created attachment 434 [details] d_itunes log, playlists coming up empty
latest attachment wont extract for me. I just get binary garbage.
The culprit (determined by direct communication with the person from whom the last XML file/log came) seems to be an apostrophe in playlist names. We're inconsistently escaping apostrophes in URLs.
Created attachment 435 [details] proposed patch This patch fixes itunesplaylist: paths before they go into the database. This ensures correct escaping of characters such as '. Since other codepaths - specifically web and player interfaces - escape URLs before querying the database, this allows for some level of consistency. A similar change may be necessary for the Moodlogic and Music Magic importers.
which apostrophe is the problem? creating a playlist called test'i`ng in moodlogic seems to still show up, and drop into a list of songs. I'll patch these two anyway, just to be safe, but I'd feel better actually being able to see the change.
I was able to recreate the problem in iTunes with ' but not ` (the latter worked).
I can't seem to trigger it in itunes by typing in either. however, the built-in 60's music playlist shows as a string of escaped characters. it still works for me, though. I'll patch the others anyway. can't possibly hurt to run things through fixPath even if they dont need it all the time :)
The built-in 90's music playlist definitely uses a different unicode character for th apostrophe (check it out in the iTunes XML file). On Windows, I am able to type in an apostrophe (') that remains unescaped in the XML file.
Fix checked in for playlists with apostrophes. This bug should be reopened if there are playlists with other names suffering from a similar problem.
spoke with a customer who appears to have no playlists with apostrophes in them, but the playlists don't show up after he does a rescan. if he removes the db file and restarts the server, they are there, until a rescan is performed. attaching xml and db file.
Created attachment 482 [details] gzipped xml from ryan j
Created attachment 483 [details] gzipped db from ryan j
Keep in mind that the playlists disappear while a rescan is happening. They should reappear once the scan is done. You're sure that isn't the problem, right?
One thing that would help would be to not delete the playlists from the db until we scan the first one from the XML (or we get to the end of the XML file). That would reduce the amount of time that playlists were absent.
if we can confirm that the temporary loss is the actual problem in this case and you want someone to take care of moving that temporary deletion, assign to me and I can deal with it.
have been unable to confirm for certain, but i did talk to someone today who checked and it was not rescanning at the time. playlists were showing up, but they were all empty...
did Vidur's fixPath change get committed? If not, it should probably be in there. it seems at least one built-in itunes playlist can trip it, so there could be others.
You mean change 3009, right? Yeah, it's in there.
*** Bug 1608 has been marked as a duplicate of this bug. ***
Kevin: Is this fixed with the committed patch?
it takes a while to discern that, given that i've never been able to reproduce this issue myself. next time i speak with a customer who's having this issue i will have them try the latest nightly of 6.1 without changing anything in the configuration, and see if it helps.
This may be a red herring but I noted that with the the latest nightly download that although the playlist was coming up empty if I scrolled though it names did start to appear, although they would not play. However, I had been attempting to run the play lists with iTunes off, I've just run iTunes and behold the play list now work. Is this the mistake that other are making? It may be an idea to tell people that to use the iTunes playlist you need to have iTunes running?
Keith: That's very interesting. You shouldn't need iTunes running for SlimServer to access it's XML file. I suspect that either the iTunes file is not being loaded by slimserver properly and then when iTunes starts it refereshes its file and SlimServer is smart enough to reload.
Running the 6.1 6/25 nightly (or maybe 6/24 - can't remember and at work now). On Slimserver: iTunes playlist shows up. The playlist song count (and corresponding number of pages) matches correct to iTunes, but no song titles show up. On the SB2: I can see the name of the playlist. I can scroll the playlist - but get all blank song titles. When I try to play, get an file not found error. NOTE: I have a house party this weekend and need to play the playlist. Is there a "last known good" version I can get to? Thanks!
Jason - could you attach your iTunes .xml file and your slimserver.db file to this bug? So far, I've been unable to reproduce this. Can you also try the 6/27 nightly? I made a change which might have an effect on this issue. Thanks.
I'll get it when I get home tonight. Do you want the xml and db file prior to upgrading to 6/27?
Yes - they should be the same before and after though.
Created attachment 576 [details] itunes XML
Created attachment 577 [details] SS DB File
Files uploaded. Installed 6.1b1 on 6/27. Did a wipe/rescan. Same problem. Playlists show up, has the correct number of songs - but when you open the list the song names are blank and won't play.
to clarify - in both the 6.1 and now the 6.1b1 I can scroll and play songs, albums, and artists. It's just the playlists that won't play.
wrote down the error displayed on the SB2: Error!URL[] is empty or track could not be retrieved
Jason - can you start the server with --d_info & --d_itunes , and then navigate to one of the play lists? I'd like to see that output. Thanks.
Lots of scrolling. What's the -option to write to a txt file I can attach?
I got the part where I was selecting the playlist: 2005-06-27 21:04:14.3402 DBI: Supressing periodic commit - no dirty items 2005-06-27 21:04:44.3405 DBI: Supressing periodic commit - no dirty items 2005-06-27 21:04:56.6549 Scanning with 0 import plugins 2005-06-27 21:04:56.8477 Scanning with 0 import plugins 2005-06-27 21:05:04.2249 browsedb - hierarchy: playlist,playlistTrack level: 0 2005-06-27 21:05:04.3563 Scanning with 0 import plugins 2005-06-27 21:05:09.1557 browsedb - hierarchy: playlist,playlistTrack level: 1 Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. 2005-06-27 21:05:09.7622 isFile(Z:\Lavigne, Avril\Let Go\Complicated.m4a) == 1 2005-06-27 21:05:09.9685 isFile(Z:\Lavigne, Avril\Let Go\Things I'll Never Say.m 4a) == 1 Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. 2005-06-27 21:05:10.4341 isFile(Z:\Ben Harper & The Innocent Criminals\Burn to S hine\Steal My Kisses.m4a) == 1 2005-06-27 21:05:10.5012 found JPEG image 2005-06-27 21:05:10.5327 isFile(Z:\Ben Harper & The Innocent Criminals\Live from Mars\Burn One Down.m4a) == 1 2005-06-27 21:05:11.5122 found JPEG image Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. Use of uninitialized value in substr at /PerlApp/Slim/Web/Pages.pm line 1852. 2005-06-27 21:05:11.5787 Scanning with 0 import plugins 2005-06-27 21:05:14.3560 DBI: Periodic commit - 2 dirty items 2005-06-27 21:05:14.3567 forceCommit: syncing to the database. 2005-06-27 21:05:44.3717 DBI: Supressing periodic commit - no dirty items 2005-06-27 21:06:15.1522 DBI: Supressing periodic commit - no dirty items
I just noticed something strange. SOME of my songs are showing up. For example, on the first page of the playlist (represented in the output above) the 2 songs by Avril Lavigne and 2 songs by Ben Harper are listed. Rest are blank. Same thing happens on the other page - a few show up but not all. I added a brand new playlist with random songs and the same thing happens. I'm trying to find some commonality...but no luck yet.
Jason - how far are you able to dig into this issue with me? Is it possible for you to install ActiveState Perl? http://www.activestate.com/ for further debugging? Thanks
i can try ... i might be bumping against my technical limitations. I'm trying one thing right now ... the output below is running slim.exe as an app. It "seems" that when I run it as app a few songs show up; when I run it as a service no songs show up. Environment: Windows Media Center, Music stored on a Bufallo Linkstation, itunes 4.89 Below is the top of the listing from running slim.exe as an app. C:\Program Files\SlimServer\server>slim --d_info --d_itunes 2005-06-27 21:26:43.7935 loading types config file... 2005-06-27 21:26:43.7976 Metadata database saving into: C:\Program Files\SlimSer ver\server\Cache\slimserversql.db 2005-06-27 21:26:43.8190 Connected to database dbi:SQLite:dbname=C:\Program File s\SlimServer\server\Cache\slimserversql.db 2005-06-27 21:26:43.8256 No upgrades found for database v. 8 2005-06-27 21:26:43.8262 DBI: Supressing periodic commit - no dirty items 2005-06-27 21:26:43.8269 Adding Folder Scan 2005-06-27 21:26:43.8580 Adding Playlist Scan 2005-06-27 21:26:49.0362 iTunes: found path via config file at: C:\Documents and Settings\Jason\My Documents\My Music\iTunes\iTunes Music Library.xml 2005-06-27 21:26:49.0524 iTunes: set iTunes library to itunes_library_music_path value of: \\linkstation\music 2005-06-27 21:26:49.0527 iTunes: Can use iTunes Music Folder - adding importer. 2005-06-27 21:26:49.0529 Adding iTunes Scan 2005-06-27 21:27:13.8404 DBI: Supressing periodic commit - no dirty items 2005-06-27 21:27:43.8412 DBI: Supressing periodic commit - no dirty items 2005-06-27 21:28:13.8560 DBI: Supressing periodic commit - no dirty items
which activestate product? I got about an hour i can work on this. East coast time and have to get up early.
ActiveState Perl: http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.6.811-MSWin32- x86-122208.msi Once that is installed, find and edit the file server/Slim/DataStores/DBI/DBIStore.pm - it should be underneath your SlimServer directory. At line 253, delete starting at: if (!$count && defined($items) && to the closing } - 9 lines total. Save and quit the file. Then change to the C:\Program Files\SlimServer\server and run: perl slimserver.pl --d_info Thanks!
in process. attaching another log file as well from browsing playlist while running as a service.
Created attachment 578 [details] log browing playlist
note - still trying. something didn't work right.
do you have to edit from the command line? don't understand the command line prompts. Did a quick purchase of DzSoft to edit it, but activation key has not come through email yet.
You should be able to edit using a text editor like Notepad. Open up the file c:\Program Files\SlimServer\server\Slim\DataStores\DBI\DBIStore.pm (assuming you installed SlimServer to the default location) in Notepad, delete the lines and save.
obviously made it more complicated than it needed to be. I'll try again tonight.
Created attachment 579 [details] Modified DBIStore.pm Jason - I've attached the modified file to this bug - so you just need to replace the existing one.
Thanks. I'll use that this evening. Again, sorry I made this more complicated than required. BTW, is the "latest" I should be running 6.1b1 or 6.1 nightly.
Either is fine. As we fix things though, 6.1 nightly might be better. 6.1b1 is just a point-in-time build from Monday morning.
Jason - I'm also curious - when you are running SlimServer as a service, can you play songs that happen to be in the playlists with empty entries? IE: If you navigate via Browse Album, etc - does playing audio work? Thanks.
Yes, I can play any song by browsing through artists. Just downloaded 6.1 nightly - same problem. Trying the other test now.
Here's the output. Note - I edited the file using a Perl editor I bought. C:\Program Files\SlimServer\server>perl slimserver.pl --d_info Global symbol "$items" requires explicit package name at C:/Program Files/SlimSe rver/server/Slim/DataStores/DBI/DBIStore.pm line 255. Global symbol "$count" requires explicit package name at C:/Program Files/SlimSe rver/server/Slim/DataStores/DBI/DBIStore.pm line 255. Global symbol "$items" requires explicit package name at C:/Program Files/SlimSe rver/server/Slim/DataStores/DBI/DBIStore.pm line 256. Global symbol "$items" requires explicit package name at C:/Program Files/SlimSe rver/server/Slim/DataStores/DBI/DBIStore.pm line 256. Unmatched right curly bracket at C:/Program Files/SlimServer/server/Slim/DataSto res/DBI/DBIStore.pm line 257, at end of line syntax error at C:/Program Files/SlimServer/server/Slim/DataStores/DBI/DBIStore. pm line 257, near "}" Compilation failed in require at C:/Program Files/SlimServer/server/Slim/Music/I nfo.pm line 19. BEGIN failed--compilation aborted at C:/Program Files/SlimServer/server/Slim/Mus ic/Info.pm line 19. Compilation failed in require at C:/Program Files/SlimServer/server/Slim/Utils/M isc.pm line 22. BEGIN failed--compilation aborted at C:/Program Files/SlimServer/server/Slim/Uti ls/Misc.pm line 22. Compilation failed in require at slimserver.pl line 203. BEGIN failed--compilation aborted at slimserver.pl line 203. C:\Program Files\SlimServer\server>
Jason - looks like you have a typo in the file. Could you drop in the Modified DBIStore.pm file I've attached to this bug? it should overwrite the file in: C:\Program Files\SlimServer\server\Slim\DataStores\DBI\DBIStore.pm Thanks.
Ignore above, I must have done something wrong. Used the file you posted and got the following output. Stil didn't see playlist songs. C:\Program Files\SlimServer\server>perl slimserver.pl --d_info 2005-06-28 17:14:21.0121 loading types config file... 2005-06-28 17:14:21.0241 Metadata database saving into: C:\Program Files\SlimSer ver\server\Cache\slimserversql.db 2005-06-28 17:14:21.0496 Connected to database dbi:SQLite:dbname=C:\Program File s\SlimServer\server\Cache\slimserversql.db 2005-06-28 17:14:21.0824 No upgrades found for database v. 8 2005-06-28 17:14:21.0830 DBI: Supressing periodic commit - no dirty items 2005-06-28 17:14:21.0836 Adding Folder Scan 2005-06-28 17:14:21.1209 Adding Playlist Scan 2005-06-28 17:14:26.4022 Adding iTunes Scan 2005-06-28 17:14:51.0834 DBI: Supressing periodic commit - no dirty items 2005-06-28 17:15:21.0844 DBI: Supressing periodic commit - no dirty items 2005-06-28 17:15:39.2750 Scanning with 0 import plugins 2005-06-28 17:15:51.0853 DBI: Supressing periodic commit - no dirty items 2005-06-28 17:16:05.6635 browsedb - hierarchy: playlist,playlistTrack level: 0 2005-06-28 17:16:05.8483 Scanning with 0 import plugins 2005-06-28 17:16:11.2465 browsedb - hierarchy: playlist,playlistTrack level: 1 Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. 2005-06-28 17:16:12.2001 Scanning with 0 import plugins 2005-06-28 17:16:21.0903 DBI: Supressing periodic commit - no dirty items 2005-06-28 17:16:53.0746 DBI: Supressing periodic commit - no dirty items
Jason - a couple of questions. This latest run, are you still using slim.exe, or are you using: perl slimserver.pl ? Please use the latter. Also, can you rescan and wipe your database? Thanks.
With that code change, the titles didn't show up. Then I added the playlist to the Music Playlist. No song titles showed up, but when I clicked "skip" ... it went to the next blank song, populated the song information, and plays it.
Running from the perl command. Will wipe/rescan.
removing those lines seems to have fixed it. songs are showing up and playing now. Anything more to test?
Created attachment 580 [details] Updated DBIStore.pm - more debugging. Jason - in order to get more information about this problem - could you drop in this new DBIStore.pm file, wipe/rescan, and access a playlist? Thanks.
in process
Done. Using new file. Playlists now not showing song data again. C:\Program Files\SlimServer\server>perl slimserver.pl --d_info 2005-06-28 18:43:34.8504 loading types config file... 2005-06-28 18:43:34.8628 Metadata database saving into: C:\Program Files\SlimSer ver\server\Cache\slimserversql.db 2005-06-28 18:43:34.8957 Connected to database dbi:SQLite:dbname=C:\Program File s\SlimServer\server\Cache\slimserversql.db 2005-06-28 18:43:34.9068 No upgrades found for database v. 8 2005-06-28 18:43:34.9073 DBI: Supressing periodic commit - no dirty items 2005-06-28 18:43:34.9079 Adding Folder Scan 2005-06-28 18:43:34.9815 Adding Playlist Scan 2005-06-28 18:43:40.2817 Adding iTunes Scan 2005-06-28 18:43:57.9647 Scanning with 0 import plugins 2005-06-28 18:43:58.0453 Scanning with 0 import plugins 2005-06-28 18:44:03.6774 browsedb - hierarchy: playlist,playlistTrack level: 0 2005-06-28 18:44:03.8142 Scanning with 0 import plugins 2005-06-28 18:44:04.9080 DBI: Supressing periodic commit - no dirty items 2005-06-28 18:44:11.1971 browsedb - hierarchy: playlist,playlistTrack level: 1 Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. 2005-06-28 18:44:11.7298 CacheItem: Checking status of file:///Z:/Lavigne,% 20Avr il/Let%20Go/Complicated.m4a (TTL: 0). 2005-06-28 18:44:11.7548 _hasChanged: checking [Z:\Lavigne, Avril\Let Go\Complic ated.m4a] 2005-06-28 18:44:11.7637 _hasChanged: fsdef: [1] fscheck: [1] agedef: [1] ageche ck: [1] 2005-06-28 18:44:11.7639 url: [file:///Z:/Lavigne,%20Avril/Let% 20Go/Complicated. m4a] updating validity cache! 2005-06-28 18:44:11.7779 isFile(Z:\Lavigne, Avril\Let Go\Complicated.m4a) == 1 2005-06-28 18:44:11.7786 Trying to load Slim::Formats::Movie 2005-06-28 18:44:12.0135 CacheItem: Checking status of file:///Z:/Lavigne,% 20Avr il/Let%20Go/Things%20I%27ll%20Never%20Say.m4a (TTL: 0). 2005-06-28 18:44:12.0142 _hasChanged: checking [Z:\Lavigne, Avril\Let Go\Things I'll Never Say.m4a] 2005-06-28 18:44:12.0228 _hasChanged: fsdef: [1] fscheck: [1] agedef: [1] ageche ck: [1] 2005-06-28 18:44:12.0230 url: [file:///Z:/Lavigne,%20Avril/Let%20Go/Things%20I% 2 7ll%20Never%20Say.m4a] updating validity cache! 2005-06-28 18:44:12.0383 isFile(Z:\Lavigne, Avril\Let Go\Things I'll Never Say.m 4a) == 1 Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. 2005-06-28 18:44:12.4348 CacheItem: Checking status of file:///Z:/Barenaked% 20La dies/Bare%20Naked%20Ladies%20-%20Everything%20to%20Everyo/Another% 20Postcard.m4a (TTL: 0). 2005-06-28 18:44:12.4355 _hasChanged: checking [Z:\Barenaked Ladies\Bare Naked L adies - Everything to Everyo\Another Postcard.m4a] 2005-06-28 18:44:12.4439 _hasChanged: fsdef: [1] fscheck: [1] agedef: [] agechec k: [0] 2005-06-28 18:44:12.4441 url: [file:///Z:/Barenaked%20Ladies/Bare%20Naked% 20Ladi es%20-%20Everything%20to%20Everyo/Another%20Postcard.m4a] updating validity cach e! 2005-06-28 18:44:12.4585 isFile(Z:\Barenaked Ladies\Bare Naked Ladies - Everythi ng to Everyo\Another Postcard.m4a) == 1 2005-06-28 18:44:12.6208 CacheItem: Checking status of file:///Z:/Barenaked% 20La dies/Bare%20Naked%20Ladies%20-%20Everything%20to%20Everyo/Testing%201-2-3.m4a (T TL: 0). 2005-06-28 18:44:12.6215 _hasChanged: checking [Z:\Barenaked Ladies\Bare Naked L adies - Everything to Everyo\Testing 1-2-3.m4a] 2005-06-28 18:44:12.6299 _hasChanged: fsdef: [1] fscheck: [1] agedef: [] agechec k: [0] 2005-06-28 18:44:12.6302 url: [file:///Z:/Barenaked%20Ladies/Bare%20Naked% 20Ladi es%20-%20Everything%20to%20Everyo/Testing%201-2-3.m4a] updating validity cache! 2005-06-28 18:44:12.6445 isFile(Z:\Barenaked Ladies\Bare Naked Ladies - Everythi ng to Everyo\Testing 1-2-3.m4a) == 1 2005-06-28 18:44:12.7863 CacheItem: Checking status of file:///Z:/Ben%20Harper% 2 0&%20The%20Innocent%20Criminals/Burn%20to%20Shine/Steal%20My%20Kisses.m4a (TTL: 0). 2005-06-28 18:44:12.7871 _hasChanged: checking [Z:\Ben Harper & The Innocent Cri minals\Burn to Shine\Steal My Kisses.m4a] 2005-06-28 18:44:12.7951 _hasChanged: fsdef: [1] fscheck: [1] agedef: [1] ageche ck: [1] 2005-06-28 18:44:12.7953 url: [file:///Z:/Ben%20Harper%20&%20The%20Innocent% 20Cr iminals/Burn%20to%20Shine/Steal%20My%20Kisses.m4a] updating validity cache! 2005-06-28 18:44:12.8092 isFile(Z:\Ben Harper & The Innocent Criminals\Burn to S hine\Steal My Kisses.m4a) == 1 2005-06-28 18:44:12.8951 found JPEG image 2005-06-28 18:44:12.9518 CacheItem: Checking status of file:///Z:/Ben%20Harper% 2 0&%20The%20Innocent%20Criminals/Live%20from%20Mars/Burn%20One%20Down.m4a (TTL: 0 ). 2005-06-28 18:44:12.9526 _hasChanged: checking [Z:\Ben Harper & The Innocent Cri minals\Live from Mars\Burn One Down.m4a] 2005-06-28 18:44:12.9606 _hasChanged: fsdef: [1] fscheck: [1] agedef: [1] ageche ck: [1] 2005-06-28 18:44:12.9608 url: [file:///Z:/Ben%20Harper%20&%20The%20Innocent% 20Cr iminals/Live%20from%20Mars/Burn%20One%20Down.m4a] updating validity cache! 2005-06-28 18:44:12.9748 isFile(Z:\Ben Harper & The Innocent Criminals\Live from Mars\Burn One Down.m4a) == 1 2005-06-28 18:44:13.8918 found JPEG image Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. Use of uninitialized value in substr at C:/Program Files/SlimServer/server/Slim/ Web/Pages.pm line 1852. 2005-06-28 18:44:14.0011 Scanning with 0 import plugins 2005-06-28 18:44:34.9087 DBI: Periodic commit - 2 dirty items 2005-06-28 18:44:34.9096 forceCommit: syncing to the database.
Jason - do the few files that you see in the log: Z:\Lavigne, Avril\Let Go\Complicated.m4a Z:\Lavigne, Avril\Let Go\Things I'll Never Say.m4a Z:\Barenaked Ladies\Bare Naked Ladies - Everything to Everyo\Another Postcard.m4a Do those show up in the playlist, if you page through it?
yes, those ones show up in the playlist. they didn't at first, but when i openeded the playlist a second time they were there.
When I add the playlist to the Music Player Playlist - some songs show up and some don't. When I press play, the song name shows up correctly and plays. When done with that song, it goes to the next song (also blank) and it again finds the song name and plays.
Correction to above - it will find and display the artist name, but not the song name, etc.
Created attachment 581 [details] DBIStore.pm with _includeInTrackCount() debugging. Jason - one more time, hopefully - here's a new DBIStore.pm - still trying to track down the exact cause. You know the drill now. Thanks. :)
got a bunch of unitialized string errors when it started up - but it is started. wipe/scan in process. having trouble copying the trace in the DOS window for some reason - sometimes it works, usually it doesn't. Is there a way to have it write to a txt file I can cut and paste from?
You can fetch the log from: http://localhost:9000/log.txt in your browser.
Didn't realize it wrote to that log when running "perl slimserver.pl --d_info" from the command line?
Created attachment 582 [details] Latest log file - Playlist showing music
That seemed to work. Completed a wipe/rescan and then server stop/restart using the perl command. Log file is attached. Browsed page 1 and page 2 of playlist, data showed up correctly. Added playlist to Music Player playlist and music showed up and played correctly. Noticed that song count is now way off - showing 1985 songs in iTunes and 3971 songs in SlimServer. Crashing out for the night, can test more tomorrow night.
fyi - tried 6/29 nightly. song count correct, iTunes playlist songs don't show up (as expected since fix not posted).
anything else or do you have what you need for a fix?
status????
Jason - it's not quite that easy. The difference between the last two DBIStore.pm files that I posted was just an extra bit of debugging. Yet you said that the last one I posted worked for you, but the second to last didn't. So that has me a bit confused.
ok, just let me know what I can do to help. I'll try rerunning both PMs again to see if I did anything different.
OK - Latest log files and notes attached. It seemed to work, but when I stopped and restarted the server I lost everything again.
Created attachment 589 [details] Log files from latest test with 7/1 nightly
Created attachment 601 [details] Possibly fixed DBIStore.pm Jason - can you give this version of DBIStore.pm a try? Please wipe your DB. Thanks.
will try tonight using the 7/8 nightly. been out of town, sorry for delay.
Created attachment 616 [details] July 8 Log File OK, that worked for the iTunes playlists. The Song count is wrong (not sure about others), and that is directly related to this new file because they were correct with the 7/8 nightly. Seems to take a bit long to load the playlist - probably because it's rescanning it at that time.
I got a new Dell 9100 (nice machine) and did a clean install of iTunes, SlimServer, etc. Had hoped that would fix my problem, but still can't read the playlists.
any suggestions on how i can help move this forward? i'm a bit stuck. currently using the last log file with nightlies. thanks.
Jason - you're using the nightly from July 20th? A few fixes have gone in as an attempt to fix this issue. Could you rescan your music library? Thanks.
I'm trying that now - working from home today! :-) I may have a problem though, it doesn't appear to be find my itunes library. Scan came back zero. The use itunes switch isn't showing up. On server settings, I have "music folder" and "playlists folder" set to blank. On iTunes page, I have "Specify Itunes Location", location set to: "C:\Documents and Settings\Jason\My Documents\My Music\iTunes\iTunes Music Library.xml", and iTunes Music folder set to: "\\linkstation\music". ???
Can you try setting the iTunes location to auto-detect?
no change. i tried putting the \\linkstation\music in the music folder and playlists on the server setting and it was able to find the music. it's doing that scan now - don't think it's picking up itunes though
You should be able to set the iTunes to autodetect and leave the playlist and music folders blank. Have you modified the slimserver service to run as a different user that may not have access to the XML file? The output of d_itunes would be most helpful.
had to set admin login for ther service, sorry. forgot to do that when i did the full uninstall / install. Itunes option shows up now, but still not scanning. will run using perl command line with --d_info and --d_itunes.
Created attachment 658 [details] 7-20 nighly log works using the perl command, very slow loading playlists though. still does not work running as a service (preferred). Attached log file from running as a service with d_itunes
This is going to have to wait until post-6.1. We'll keep investigating for the next release, but the issue doesn't appear to be widespread.
OK, thanks. If it's not widespread, then I'm open to ideas on environmental issues I can change. I've gone so far as to load an entirely new computer (the Dell 9100 mentioned above). I'll check back.
Kevin has gotten a couple of users just today with this issue. We need to take a look at it for 6.1.2
2 calls about this this morning. one running 6.1.1 and one running a 6.2 nightly from 7/30. - both on windows xp - both running itunes 4.9 - both had moved their default itunes library location - xml file was still in default location - both had NO 'Use iTunes' option in server settings was able to get one working by: - specifying itunes xml file location manually (which takes FOREVER to do over the phone because the path is STUPID long: C:\Documents and Settings\Username\My Documents\My Music\iTunes\iTunes Music Library.xml -- and one wrong character breaks it obviously.) - specifying the alternate music folder location - setting it to specify itunes library location manually - clicking rescan and wipe cache at this point showed NO content and NO playlists - stopped server, relaunched, and it worked. The other case had moved the itunes music folder to a NAS drive that was mapped in Windows as M:\, but since SS 6.1 now runs as a service only, I don't think this will work period.
Hm, kevin, this may be a separate issue, where the xml file isn't being discovered even though it's in the right place. Would like the output of d_itunes at start. The issue with the mapped drives is a separate one and has been opened as bug 1898
Tried 8/7 nightly with a full new installation of iTunes 4.9 (unistalled iTunes and deleted the itunes folder under My Music). Still not working. I'm going to give up on it - will try another software to manage playlists, etc.
I"m going to mark this bug as WORKSFORME, the last comment was 2 months old. PLEASE open a new bug if you are still having issues with the latest 6.2 beta release.