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 me JOIN contributors ON contributors.id = me.contributor 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: Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: ambiguous column name: id [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 me JOIN contributors ON contributors.id = me.contributor 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 , ambiguous column name: id ------------------------------------------------------------------------ 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 [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
