I have now tested all my old playlists and I have just one type which is
causing errors.
They are all generally of this format:
Code:
--------------------
-- PlaylistName:All by Years...
-- PlaylistParameter1:year:Select 1st year:
-- PlaylistParameter2:custom:Select 2nd year:select tracks.year,tracks.year
from tracks where tracks.year>='PlaylistParameter1' and tracks.audio=1 group by
tracks.year order by tracks.year
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
tracks.audio=1
and dynamicplaylist_history.id is null
and tracks.year>='PlaylistParameter1'
and tracks.year<='PlaylistParameter2'
group by tracks.id
order by random()
limit 20;
--------------------
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"]
--------------------
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"]
--------------------
Is this something that needs changing in my SQL to make it compatible,
or a problem with the plugin?
------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=94854
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
