by Newbie » Mon Sep 12, 2011 4:39 am
Hey,
this is really a great program!
But I have a problem: It is playing the songs in my MM playlist (the last played songs with MM), but I cant play any tracks with remote control. I can create Playlists, but then I cant play them, following error is shown:
System.Exception: SQL: select distinct id COLLATE NOCASE ,artist COLLATE NOCASE ,album COLLATE NOCASE ,albumartist COLLATE NOCASE ,discnumber COLLATE NOCASE ,tracknumber COLLATE NOCASE ,songtitle COLLATE NOCASE ,songpath COLLATE NOCASE ,substr(year COLLATE NOCASE ,1,4) as year,genre COLLATE NOCASE ,songlength COLLATE NOCASE ,vbr COLLATE NOCASE ,band COLLATE NOCASE ,mood COLLATE NOCASE ,occasion COLLATE NOCASE ,lyrics COLLATE NOCASE ,extension COLLATE NOCASE from songs s left join playlistsongs ps on ps.idsong=s.id left join playlists p on p.idplaylist=ps.idplaylist where (p.idplaylist = '79') ORDER BY ps.SongOrder
SQLite error
no such column: band
bei MonkeyServer.DBBase.GetDataTable(String SQL, DbParameter[] params, Int32 Timeout)
bei MonkeyServer.MediaMonkeyLibrary.GetSongs(Query theQuery)
bei MonkeyServer.Page.9cxEfvCX4H8s()
bei MonkeyServer.Page.ProcessRequest(Request& theRequest, Response& theResponse)
bei MonkeyServer.ServerConnection.HandleRequest()
What am I doing wrong?
I am using MM newest beta 4, is this the problem? But as I said, I can play track which are in my playlist from starting MM.
Thank you for your help and your great programing work!