I am currently experiencing an issue with SlimServer with an external MySQL DB, whereby at startup the database is cleared.
Rather than rescan my whole library multiple times whilst investigating this problem, I have been browsing the music folder to get a single album into the DB. This morning, my SlimServer alarm clock fired, which is set up to play random tracks. With just one album listed in the database (via BMF), I got the following crash: 2006-08-26 07:20:01.7547 DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY RAND() LIMIT 10' at line 1 at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 743. 2006-08-26 07:20:01.7549 ERROR: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me LEFT JOIN genre_track genreTracks ON ( genreTracks.track = me.id ) WHERE ( audio = ? AND genreTracks.genre IN ( ) ) ORDER BY RAND() LIMIT 10': DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY RAND() LIMIT 10' at line 1 at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 743. 2006-08-26 07:20:01.7552 ERROR: Backtrace follows: 2006-08-26 07:20:01.7556 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 745) frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 798) frame 2: DBIx::Class::Storage::DBI::_select (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 3: DBIx::Class::Storage::DBI::Cursor::next (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Cursor.pm line 69) frame 4: DBIx::Class::Cursor::all (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 115) frame 5: DBIx::Class::Storage::DBI::Cursor::all (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 921) frame 6: DBIx::Class::ResultSet::all (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 149) frame 7: DBIx::Class::ResultSet::search (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 635) frame 8: DBIx::Class::ResultSet::slice (P:\Music\SlimServer\trunk\server/Plugins/RandomPlay/Plugin.pm line 65) frame 9: Plugins::RandomPlay::Plugin::findAndAdd (P:\Music\SlimServer\trunk\server/Plugins/RandomPlay/Plugin.pm line 301) frame 10: Plugins::RandomPlay::Plugin::playRandom (P:\Music\SlimServer\trunk\server/Slim/Buttons/AlarmClock.pm line 438) frame 11: Slim::Buttons::AlarmClock::checkAlarms (P:\Music\SlimServer\trunk\server/Slim/Utils/Timers.pm line 181) frame 12: Slim::Utils::Timers::checkTimers (P:\Music\SlimServer\trunk\server\slimserver.pl line 506) frame 13: main::idle (P:\Music\SlimServer\trunk\server\slimserver.pl line 456) frame 14: main::main (P:\Music\SlimServer\trunk\server\slimserver.pl line 1055) 2006-08-26 07:20:01.7559 DBD::mysql::st fetchrow_array failed: fetch() without execute() at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 86. DBD::mysql::st fetchrow_array failed: fetch() without execute() at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 86. Phil _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
