MillmoorRon wrote: > I have now tested all my old playlists and I have just one type which is > causing errors. > > ... > > In iPeng or SqueezeCommander the '2nd year' selection does not appear at > all. I think Pippin suggested that the plugin was not passing the > correct data to is app but I thought that you had fixed this a couple of > years ago. > > ... > > I get this in the log: > > Code: -------------------- > > > [12-05-08 15:53:44.2372] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db prepare failed: near "and": syntax error [for Statement "select tracks.year,tracks.year from tracks where tracks.year>= and tracks.audio=1 group by tracks.year order by tracks.year"] > -------------------- > > > It's a bug in Dynamic Playlist, will try to release a new version where it's fixed in the near future, just want to test the correction a bit more first, if everything goes as planned I should be able to release it later this week. The issue is when PlaylistParameter2 sql have a SQL statement that contains PlaylistParameter1.
Just out of interest, have these playlists really worked with a previous Dynamic Playlist version in iPeng/SqueezeCommander/Radio/Touch/Controller ? I'm just asking because I can't remember that I've done any changes recently in this area, so it feels like a very old problem, but I might have done things which I don't remember at the moment. MillmoorRon wrote: > > If I try it through the web interface it seems to work - i.e. it returns > the expected tracks - however I get the following (and some backtrace > lines) log: > > Code: -------------------- > > > [12-05-08 15:59:22.4414] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select id,name from genres order by namesort"] > [12-05-08 15:59:24.7529] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select id,name from genres order by namesort"] > [12-05-08 15:59:25.1660] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select year,year from tracks where year is not null group by year order by year desc"] > [12-05-08 15:59:28.7134] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select id,name from genres order by namesort"] > [12-05-08 15:59:29.1253] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select year,year from tracks where year is not null group by year order by year desc"] > [12-05-08 15:59:29.5156] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select tracks.year,tracks.year from tracks where tracks.year>=1997 and tracks.audio=1 group by tracks.year order by tracks.year"] > -------------------- > > > These are harmless, I really should try to find a better way to handle it so they doing produce log messages but for now you can just ignore these messages. ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=94854 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
