PDA

View Full Version : RandomPlay problem



Philip Meyer
2006-08-26, 00:34
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

Philip Meyer
2006-08-26, 00:48
In fact, I now get this error every time I try to start my server. I can't get in there to turn off random play mode or force a rescan, and it crashes with the same error.

Phil