Hi!
After installing latest 7.9 build, the playlist generator fails when
creating playlists. Here from log:
[16-07-29 18:19:43.4125] Plugins::PlaylistGenerator::Generator::next
(106) Error fetching song references from database for playlist: >70
-jazz - udtræk 2: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
prepare failed: no such function: unix_timestamp [for Statement "
select tracks.id from tracks
join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and (track_statistics.rating>=70)
and not exists (select * from tracks
t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in
('Christmas','Comedy','HIGHFIDELITY','Jazz','Jazz+Funk'))
and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-2419200)
group by tracks.id
order by random()
limit 250
"] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
, no such function: unix_timestampIt took 0.007787 seconds
Version:
Logitech Media Server Version: 7.9.0 - 1469176740 @ Mon Jul 25 04:06:17
UTC 2016
Værtsnavn: nas-C1-71-AE
Serverens IP-adresse: 192.168.1.2
Serverens HTTP-portnummer: 9000
Styresystem: Netgear RAIDiator - DA - utf8
Platformarkitektur: i686-linux
Perl-version: 5.8.8 - i486-linux-gnu-thread-multi
Audio::Scan: 0.95
Databaseversion: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Samlet antal kendte afspillere: 5
Callesoroe
Living room: Transporter, Tact RCS 2.2X digital preamp, Martin Logan
Vista speakers, AMPS(Icepower): Acoustic Reality Ear Enigma
PLUS(PANELS), Acoustic Reality Ear TWO MKII(Bas)
Kitchen: Receiver - S.M.S.L DAC, Prodipe Pro 5 active bi-amp speakers.
Bedroom: Receiver+UE boombox, Kids: Receiver+Active speakers, Office:
Transporter, JBL LSR305 active speakers , TIDAL HIFI flac streaming.
http://www.last.fm/user/callesoroe
------------------------------------------------------------------------
callesoroe's Profile: http://forums.slimdevices.com/member.php?userid=22693
View this thread: http://forums.slimdevices.com/showthread.php?t=105921
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
