Changeset 939 being Used - 2008/02/25 23:24Re: Ticket 129
Testing the feature to add WMP playlists...
While Swiss does indeed recognize the WMP playlists. The playlist feature no longer works for me. It says that the playlist was successfullty loaded but then just says no playlist is defined.
The log shows the following error:
Unable to query database: Table 'swiss.radio_stations' doesn't exist
The Video playlists load fine.
Bug most likely introduced with Changeset 923 and can be reproduced on the PC.Showcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.07 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
Stu2j
User
Posts: 1234
Re: Changeset 939 being Used - 2008/03/05 19:16Bump ..
Help me Mr. Wizard... I have need of playlists Showcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.07 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
admin
Admin
Posts: 1542
Re: Changeset 939 being Used - 2008/03/06 15:46Try applying the following SQL statement and let me know if it fixes it:
Code:
update media_types set media_table = null where media_name='Radio';
Rob Player : Pinnacle Showcenter 200 and 1000 (wired ethernet) Server : Windows XP Pro running on an Athlon XP 2200, 768 Mb RAM, 1.8 Tb storage.
| | The administrator has disabled public write access.
Stu2j
User
Posts: 1234
Re: Changeset 939 being Used - 2008/03/06 16:20Hi Rob...
The good news is that I am no longer seeing that error. The bad news is that the music playlists still aren't loading.
Here's a clip from the log where the playlist is requested:
[2008.03.06 16:09:58] Page Requested : http://192.168.2.104:8080/load_pl.php?load=d%3A%2Fmusic%2Fmy%20playlists%2FMusic%2FEasy%
20Listening.m3u&action= by client (192.168.2.102) [2008.03.06 16:09:58] SQL> select value from system_prefs where name='CACHE_STYLE_DETAILS' [2008.03.06 16:09:58] SQL> select value from system_prefs where name='CACHE_LANGUAGE_STRINGS' [2008.03.06 16:09:58] Attempting to load playlist : d:/music/my playlists/Music/Easy Listening.m3u [2008.03.06 16:09:58] Playlist is of type: M3U [2008.03.06 16:09:58] Playlist tracks [2008.03.06 16:09:58] Array [2008.03.06 16:09:58] ( [2008.03.06 16:09:58] [0] => \Music\Aerosmith\Greatest Hits\01 Dream On.mp3 [2008.03.06 16:09:58] [1] => \Music\Tim McGraw\Live Like You Were Dying\05 Live Like You Were Dying.mp3 [2008.03.06 16:09:58] [2] => \Music\Air Supply\Greatest Hits [Arista]\01 Lost in Love.mp3 [2008.03.06 16:09:58] [3] => \Music\Marc Cohn\Marc Cohn\01 Walking in Memphis.mp3 [2008.03.06 16:09:58] [4] => \Music\James Taylor\Greatest Hits\02 Carolina in My Mind.mp3 [2008.03.06 16:09:58] [5] => \Music\Air Supply\Greatest Hits [Arista]\02 Even the Nights Are Better.mp3 [2008.03.06 16:09:58] [6] => \Music\Styx\Classics, Vol. 15\01 Babe.mp3 [2008.03.06 16:09:58] [7] => \Music\Styx\Greatest Hits\01 Lady '95.mp3 [2008.03.06 16:09:58] [8] => \Music\Air Supply\Greatest Hits [Arista]\04 Every Woman in the World.mp3 [2008.03.06 16:09:58] [9] => \Music\Bob Seger & the Silver Bullet Band\Nine Tonight\06 Mainstreet.mp3 [2008.03.06 16:09:58] [10] => \Music\Mariah Carey\Music Box\02 Hero.mp3 [2008.03.06 16:09:58] [11] => \Music\REO Speedwagon\Hi Infidelity\02 Keep on Loving You.mp3 [2008.03.06 16:09:58] [12] => \Music\Stevie Nicks\Timespace- The Best of Stevie Nicks\11 Leather and Lace.mp3 [2008.03.06 16:09:58] [13] => \Music\Prince & the Revolution\Purple Rain\06 When Doves Cry.mp3 [2008.03.06 16:09:58] [14] => \Music\Meat Loaf\Bat out of Hell\05 Two Out of Three Ain't Bad.mp3 [2008.03.06 16:09:58] [15] => \Music\James Taylor\Greatest Hits\11 Shower the People.mp3 [2008.03.06 16:09:58] [16] => \Music\Rod Stewart\Unplugged...and Seated\07 Reason to Believe.mp3 [2008.03.06 16:09:58] [17] => \Music\Michael Jackson\Number Ones\10 Man in the Mirror.mp3 [2008.03.06 16:09:58] [18] => \Music\The Monkees\Greatest Hits [Arista]\04 Daydream Believer.mp3 [2008.03.06 16:09:58] [19] => \Music\Rod Stewart\Greatest Hits\09 The First Cut Is the Deepest.mp3 [2008.03.06 16:09:58] [20] => \Music\Kansas\The Best of Kansas [1984]\04 Dust in the Wind.mp3 [2008.03.06 16:09:58] [21] => \Music\Billy Joel\Greatest Hits, Vols. 1 & 2 (1973-1985) Disc 1\01 Piano Man.mp3 [2008.03.06 16:09:58] [22] => \Music\Styx\Greatest Hits\16 Don't Let It End.mp3 [2008.03.06 16:09:58] [23] => \Music\Elton John\Greatest Hits\02 Daniel.mp3 [2008.03.06 16:09:58] [24] => \Music\Queen\Greatest Hits [Hollywood]\14 Save Me.mp3 [2008.03.06 16:09:58] [25] => \Music\Air Supply\Greatest Hits [Arista]\06 Making Love Out of Nothing at All.mp3 [2008.03.06 16:09:58] [26] => \Music\Jimmy Buffett\Songs You Know By Heart [1990]\07 Come Monday.mp3 [2008.03.06 16:09:58] [27] => \Music\Kiss\Greatest Kiss\09 Beth.mp3 [2008.03.06 16:09:58] [28] => \Music\Air Supply\Greatest Hits [Arista]\07 All Out of Love.mp3 [2008.03.06 16:09:58] [29] => \Music\Bob Seger & the Silver Bullet Band\Nine Tonight\14 Night Moves.mp3 [2008.03.06 16:09:58] [30] => \Music\Boston\Boston\08 Let Me Take You Home Tonight.mp3 [2008.03.06 16:09:58] [31] => \Music\Journey\Greatest Hits\12 Open Arms.mp3 [2008.03.06 16:09:58] [32] => \Music\Eric Clapton\Unplugged\04 Tears in Heaven.mp3 [2008.03.06 16:09:58] [33] => \Music\Boyz II Men\II\10 On Bended Knee.mp3 [2008.03.06 16:09:58] [34] => \Music\Chicago\Greatest Hits- 1982-1989\11 If She Would Have Been Faithful.mp3 [2008.03.06 16:09:58] [35] => \Music\Dr. Hook\Greatest Hits (And More)\10 When You're in Love With a Beautiful Woman.mp3 [2008.03.06 16:09:58] [36] => \Music\Hall & Oates\Rock 'n' Soul, Pt. 1- Greatest Hits\11 One on One.mp3 [2008.03.06 16:09:58] [37] => \Music\Eagles\The Eagles Greatest Hits, Vol. 2\05 The Sad Café.mp3 [2008.03.06 16:09:58] [38] => \Music\Fleetwood Mac\Greatest Hits [Reprise]\15 Over My Head.mp3 [2008.03.06 16:09:58] ) [2008.03.06 16:09:58] [2008.03.06 16:09:58] SQL> select value from system_prefs where name='PLAYLISTS' [2008.03.06 16:09:58] SQL> select media_id, media_table from media_types where media_table is not null [2008.03.06 16:09:58] SQL> select file_id from mp3s where concat(dirname,filename)='d:/music/my playlists//Music/Aerosmith/Greatest Hits/01 Dream On.mp3' limit 1 [2008.03.06 16:09:58] SQL> select file_id from photos where concat(dirname,filename)='d:/music/my playlists//Music/Aerosmith/Greatest Hits/01 Dream On.mp3' limit 1 [2008.03.06 16:09:58] SQL> select file_id from movies where concat(dirname,filename)='d:/music/my playlists//Music/Aerosmith/Greatest Hits/01 Dream On.mp3' limit 1 [2008.03.06 16:09:58] SQL> select file_id from tv where concat(dirname,filename)='d:/music/my playlists//Music/Aerosmith/Greatest Hits/01 Dream On.mp3' limit 1 [2008.03.06 16:09:58] The following file cannot be found in the SwissCenter database: d:/music/my playlists//Music/Aerosmith/Greatest Hits/01 Dream On.mp3
The SQL lines are identical for each song until it finally ends with "playlist loaded" (which is what appears on the screen) but it isn't and the menu says no playlist is defined.Showcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.07 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
admin
Admin
Posts: 1542
Re: Changeset 939 being Used - 2008/03/06 18:01It looks like the filename is getting slightly corrupted... there's a double slash in the filename in the SQL lines.
Where is that file stored actually stored?
Is it in the swisscenter database?
Can you post the results of the following query please:
select * from mp3s where dirname like '%Aerosmith%Dream On%';
Rob Player : Pinnacle Showcenter 200 and 1000 (wired ethernet) Server : Windows XP Pro running on an Athlon XP 2200, 768 Mb RAM, 1.8 Tb storage.
| | The administrator has disabled public write access.
Stu2j
User
Posts: 1234
Re: Changeset 939 being Used - 2008/03/06 20:39Sorry for the delay (tennis match)...
>>Where is that file stored actually stored?
My playlists are stored:
d:/music/my playlists
The music is stored:
d:/Music/Aerosmith/Greatest Hits/01 Dream On.mp3
In the SQL line per the log, the path before the // is the path to the playlist while the path after the // is the path to the music file.
>>>Is it in the swisscenter database?
Absolutely. I can select it as a single song and play it,
>>>Can you post the results of the following query please:
Certainly but where and how do I enter that query?
Thanks.Showcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.07 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
Stu2j
User
Posts: 1234
Re: Changeset 939 being Used - 2008/03/06 20:56Don't know if this will help but when I attempt to load a WMP playlist, it looks like this:
[2008.03.06 20:47:13] SQL> select file_id from mp3s where concat(dirname,filename)='d:/music/my playlists///Networkstorage/d/Music/Eric Clapton/Time Pieces- Best of Eric Clapton/06 Cocaine.mp3' limit 1 [2008.03.06 20:47:13] SQL> select file_id from photos where concat(dirname,filename)='d:/music/my playlists///Networkstorage/d/Music/Eric Clapton/Time Pieces- Best of Eric Clapton/06 Cocaine.mp3' limit 1 [2008.03.06 20:47:13] SQL> select file_id from movies where concat(dirname,filename)='d:/music/my playlists///Networkstorage/d/Music/Eric Clapton/Time Pieces- Best of Eric Clapton/06 Cocaine.mp3' limit 1 [2008.03.06 20:47:13] SQL> select file_id from tv where concat(dirname,filename)='d:/music/my playlists///Networkstorage/d/Music/Eric Clapton/Time Pieces- Best of Eric Clapton/06 Cocaine.mp3' limit 1 [2008.03.06 20:47:13] The following file cannot be found in the SwissCenter database: d:/music/my playlists///Networkstorage/d/Music/Eric Clapton/Time Pieces- Best of Eric Clapton/06 Cocaine.mp3
("Networkstorage" is the name of the server)Showcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.07 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
Stu2j
User
Posts: 1234
Re: Changeset 939 being Used - 2008/03/06 21:33OK boss... my original m3u playlist looked like this:
Please note that with version 1.19.2 the old playlist worked fine. Something since requires the drive letter.
Edit later...
OK boss... my original wpl file looked like this:
<media src="\\Networkstorage\d\Music\Aerosmith\Greatest Hits\04 Walk This Way.mp3"
Changed to this and it loaded fine:
<media src="d:\Music\Aerosmith\Greatest Hits\04 Walk This Way.mp3"
I once again have working playlists. What you do with this information is up to you but as it stands now the new version of Swiss could break some existing playlists and it appears to me that wpl files will have to be modified to work. Neither those created on a network machine nor the host machine would load without modification.
Ooops. Check that.
The WPL files will work fine if created on the local host machine. Sorry.Showcenters 1000g/200/250HD Popcorn Hour A-100 Netgear HDX101 Powerline Adapters Windows XP Simese 2.07 running latest SVN NAS Server IBM NetVista 900Mhz/256RAM
| | The administrator has disabled public write access.
admin
Admin
Posts: 1542
Re: Changeset 939 being Used - 2008/03/23 11:06OK boss... my original m3u playlist looked like this:
This is how it should work. Unless the entries in the playlist specify a drive letter or a share then they will be relative to the location of the playlist file.
In your original file, it is impossible to know which drive contains the "Music" directory. THerefore, it is (wrongly) taken to be relative to the playlist file.
In your updated file, it is an absolute path because it contains the drive letter. Therefore the location of the file is known and can be loaded.
Please note that with version 1.19.2 the old playlist worked fine. Something since requires the drive letter. It shouldn't have worked before!
OK boss... my original wpl file looked like this:
Code:
<media src="\\Networkstorage\d\Music\Aerosmith\Greatest Hits\4 Walk This Way.mp3"
Changed to this and it loaded fine:
Code:
<media src="d:\Music\Aerosmith\Greatest Hits\4 Walk This Way.mp3"
Swisscenter didn't support share names as part of the playlists - it was assuming that they were relative paths as in the above example. However, I've fixed that now and share names should work in the next version.
Rob Player : Pinnacle Showcenter 200 and 1000 (wired ethernet) Server : Windows XP Pro running on an Athlon XP 2200, 768 Mb RAM, 1.8 Tb storage.
| | The administrator has disabled public write access.
dahray02
User
Posts: 9
Re: Changeset 939 being Used - 2008/04/25 11:29Stu2j wrote: OK boss... my original m3u playlist looked like this:
Please note that with version 1.19.2 the old playlist worked fine. Something since requires the drive letter.
Edit later...
OK boss... my original wpl file looked like this:
<media src="\\Networkstorage\d\Music\Aerosmith\Greatest Hits\04 Walk This Way.mp3"
Changed to this and it loaded fine:
<media src="d:\Music\Aerosmith\Greatest Hits\04 Walk This Way.mp3"
I once again have working playlists. What you do with this information is up to you but as it stands now the new version of Swiss could break some existing playlists and it appears to me that wpl files will have to be modified to work. Neither those created on a network machine nor the host machine would load without modification.
Ooops. Check that.
The WPL files will work fine if created on the local host machine. Sorry.
i'm having the same problem...where did you make the changes for the .m3u playlists?
| | The administrator has disabled public write access.
dahray02
User
Posts: 9
Re: Changeset 939 being Used - 2008/04/25 11:50ok so i added the C: in front of the path and it works now.....is there a clear fix for this? or will i have to go and edit the playlist myself everytime i make one or make a change to it
| | The administrator has disabled public write access.
Forums 
What you do with this information is up to you 
but as it stands now the new version of Swiss could break some existing playlists and it appears to me that wpl files will have to be modified to work. Neither those created on a network machine nor the host machine would load without modification. 
