This query ran fine in 7.5. I only had to change rand() to random().
-- PlaylistName:1) Evening Breeze
-- PlaylistGroups:Casual/Jazz Pop
select tracks.url from tracks
join genre_track on
tracks.id=genre_track.track
join genres on
Goattee wrote:
But when I test it, I get the following error. (I am currently scanning
a large set of music files on a NAS elsehwhere on my LAN-- could this be
the cause of thte error.)
Error:
Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception:
DBD::SQLite::st execute
Goattee wrote:
This query ran fine in 7.5. I only had to change rand() to random().
Error:
Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception:
DBD::SQLite::st execute failed: database is locked [for Statement
DELETE FROM tracks WHERE ( id = ? )] at /Slim/Schema/Storage.pm line
Works perfectly now. Thanks!
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=94854
erland wrote:
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.
Thanks!
erland wrote:
Just out of
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
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
Thanks for the tips.
I think I'll go with the cron suggestion as it seems the easiest!
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread:
Yes, that seems to work.
Thanks!
One other (slightly related) issue I'm having is that after creating a
new SQL Playlist or Custom Browse menu through the web interface I find
that the owner of the file (server is on Ubuntu) is 'squeezeboxserver'
and that only the owner has write permissions.
MillmoorRon wrote:
Yes, that seems to work.
Thanks!
One other (slightly related) issue I'm having is that after creating a
new SQL Playlist or Custom Browse menu through the web interface I find
that the owner of the file (server is on Ubuntu) is 'squeezeboxserver'
and that only the
Erland,
I'm trying to update my SQL Playlists to work on LMS.
I've changed all instances of rand() to random() which makes most work
OK but I still have some problematic ones.
My Recently Added SQL have a 'days' parameter:
Code:
-- PlaylistParameter1:list:Added in the
Have you tried this ?
Code:
and track_statistics.addedSTRFTIME(%s,DATE('NOW','-'PlaylistParameter1'
DAY'))
Let me know if this doesn't work and I'll take a closer look at it.
12 matches
Mail list logo
