I get the same error with trackstat installed .
I'm trying to use Sugarcube (newb at that too )
Code:
--------------------
frame 19: Slim::Control::Request::notify
(/usr/local/bin/myperl/lib/site_perl/Slim/Control/Request.pm line 860)
frame 20: Slim::Control::Request::checkNotifications
(/usr/libexec/squeezeboxserver line 676)
frame 21: main::idle (/usr/libexec/squeezeboxserver line 645)
frame 22: main::main (/usr/libexec/squeezeboxserver line 1158)
[11-11-12 19:10:33.1812] Slim::Schema::Storage::throw_exception (122) Error:
Carp::Clan::__ANON__(): 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()"] at
/usr/local/bin/myperl/lib/site_perl/Slim/Schema/Storage.pm line 126
[11-11-12 19:10:33.1834] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/local/bin/myperl/lib/site_perl/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 598)
frame 2: DBIx::Class::Storage::DBI::dbh_do
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 105)
frame 3: DBIx::Class::Storage::DBI::Cursor::next
(/usr/share/squeezeboxserver/lib/DBIx/Class/ResultSet.pm line 954)
frame 4: DBIx::Class::ResultSet::next
(/usr/share/squeezeboxserver/lib/DBIx/Class/ResultSet.pm line 1483)
frame 5: DBIx::Class::ResultSet::first
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/SugarCube/Plugin.pm
line 663)
frame 6: Plugins::SugarCube::Plugin::kickoff
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/SugarCube/Plugin.pm
line 626)
frame 7: Plugins::SugarCube::Plugin::commandCallback
(/usr/local/bin/myperl/lib/site_perl/Slim/Control/Request.pm line 2082)
frame 8: (eval) (/usr/local/bin/myperl/lib/site_perl/Slim/Control/Request.pm
line 2082)
frame 9: Slim::Control::Request::notify
(/usr/local/bin/myperl/lib/site_perl/Slim/Control/Request.pm line 860)
frame 10: Slim::Control::Request::checkNotifications
(/usr/libexec/squeezeboxserver line 676)
frame 11: main::idle (/usr/libexec/squeezeboxserver line 645)
frame 12: main::main (/usr/libexec/squeezeboxserver line 1158)
[11-11-12 19:10:33.1852] Slim::Control::Request::notify (2085) Error: Failed
notify: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): 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()"] at
/usr/local/bin/myperl/lib/site_perl/Slim/Schema/Storage.pm line 126
[11-11-12 19:10:34.0748] Slim::Music::Import::nextScanTask (709) remaining
scans in queue:()
--------------------
--
Mnyb
--------------------------------------------------------------------
Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH 2 x
MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3
sub.
Bedroom/Office: Boom
Kitchen: Touch + powered Fostex PM0.4
Misc use: Radio (with battery)
iPad 64gB wifi +3g with iPengHD & SqueezePad
(in storage SB3, reciever )
------------------------------------------------------------------------
Mnyb's Profile: http://forums.slimdevices.com/member.php?userid=4143
View this thread: http://forums.slimdevices.com/showthread.php?t=91406
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
