normally your head is good, so it's me. :-)
This: SELECT contributors.name, me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.extid, me.title FROM albums JOIN contributors ON contributors.id = me.contributor me WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( ( me.audio = 1 AND me.year = 2010 AND samplesize = 16 ) ) GROUP BY me.id ) ) ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001 leads to this: Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: near "me": syntax error [for Statement " SELECT contributors.name, me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.extid, me.title FROM albums JOIN contributors ON contributors.id = me.contributor me WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( ( me.audio = 1 AND me.year = 2010 AND samplesize = 16 ) ) GROUP BY me.id ) ) ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001 "] at /lms/Slim/Schema/Storage.pm line 125 , near "me": syntax error ------------------------------------------------------------------------ mamema's Profile: http://forums.slimdevices.com/member.php?userid=44662 View this thread: http://forums.slimdevices.com/showthread.php?t=115686 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
