Now I get this when DynamicMix is trying to choose a random song. Does
that mean DynamicMix won't work with SQLite? See
http://forums.slimdevices.com/showthread.php?p=669718#post669718
Code:
--------------------
[12-03-28 22:09:07.6924]
Plugins::DynamicMix::Plugin::getNextDynamicPlayListTracks (840) Choosing a
random song
[12-03-28 22:09:07.6998] Slim::Schema::Storage::throw_exception (122) Error:
DBI Exception: DBD::SQLite::db prepare_cached failed: no such function: RAND
[for Statement "SELECT me.id, me.urlmd5, me.url, me.content_type, me.title,
me.titlesort, me.titlesearch, me.album, me.primary_artist, me.tracknum,
me.timestamp, me.added_time, me.updated_time, me.filesize, me.disc, me.remote,
me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover,
me.cover_cached, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize,
me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm,
me.musicmagic_mixable, me.dlna_profile, me.musicbrainz_id, me.lossless,
me.lyrics, me.replay_gain, me.replay_peak, me.extid, me.virtual, me.coverid
FROM tracks me WHERE ( ( audio = ? AND remote = ? ) ) ORDER BY RAND()"]
--------------------
--
haschmich
------------------------------------------------------------------------
haschmich's Profile: http://forums.slimdevices.com/member.php?userid=41882
View this thread: http://forums.slimdevices.com/showthread.php?t=92248
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins