Thanks. Here's the acc.log: ACC Version : 3.3 STARTED : 18-4-2010 --- 13:10:59 STATUS : fnStart():ENTER:13:10:59
MAIN PREFERENCES -------------------------------------------------------- OPTION SELEC: Catalog Title = Album Collection OPTION SELEC: Catalog Sub Title: = OPTION SELEC: Location of album property data = 0 OPTION SELEC: Display Tracks = Waar OPTION SELEC: Display track duration = Waar OPTION SELEC: Display Genre = Waar OPTION SELEC: Display starting Capitals = Waar OPTION SELEC: Display codec = Waar OPTION SELEC: Display bitrate = Waar OPTION SELEC: Create Table Of content = Waar OPTION SELEC: Normal album art = Onwaar OPTION SELEC: Use Large track fonts = Waar OPTION SELEC: Sort by = 1 OPTION SELEC: Sort artist by ARTISTSORT tag = Waar OPTION SELEC: Group by comment = 0 OPTIONS ----------------------------------------------------------------- OPTION SELEC: Use album cover stored in SqueezeCenter instead of physical file(slow) = Waar OPTION SELEC: Use Zero Prefix = -1 OPTION SELEC: Swap Artist - track for VA albums = -1 OPTION SELEC: Ignore 'The' prefix when sorting = Onwaar OPTION SELEC: Vertical align = -1 OPTION SELEC: Horizontal align = 0 OPTION SELEC: Alternative header = -1 OPTION SELEC: Display CD# (if applicable) in header instead of tracklist = -1 OPTION SELEC: Use Disc instead of CD for multiple CDs/Disc = 0 OPTION SELEC: Filter: From Date = OPTION SELEC: Filter: Genres entered = OPTION SELEC: Filter: GenreInclude = 0 OPTION SELEC: Filter: Comments entered = OPTION SELEC: Filter: CommentInclude = -1 OPTION SELEC: Filter: Starting folder = X:\ ADVANCED OPTIONS -------------------------------------------------------- OPTION SELEC: Create .MHT = -1 OPTION SELEC: TPE2 tag is AlbumArtist instead of band = 0 OPTION SELEC: Maximum tracks on page = 77 OPTION SELEC: Maximum album rows per page = 5 OPTION SELEC: Maximum TOC rows per page = 50 OPTION SELEC: Alternative coverart filename = OPTION SELEC: Alternative output folder = REMOTE SERVER OPTIONS --------------------------------------------------- OPTION SELEC: Remote IP Number = 192.168.1.120 OPTION SELEC: Port Number = 9002 OPTION SELEC: Mapped local drive = 20 OPTION SELEC: Physical directory path = volume1/MP3/ END OF GUI OPTIONS ------------------------------------------------------ STATUS : fnStart():LEAVE:13:10:59 STATUS : fnStart2():ENTER:13:10:59 STATUS : fnStart2():MySQL Connectstring=DRIVER={MySQL ODBC 5.1 Driver};Server=192.168.1.120;Port=9092;Database=slimserver;UID=slimserver;Password=slimserver;Option=3 STATUS : fnQueryLogic():ENTER:13:10:59 STATUS : fnCreateACCTable():ENTER:13:10:59 STATUS : fnCreateACCTable():sql(1): Create table ACC SELECT DISTINCT CONVERT(album_artist.name USING UTF8) AS 'AlbumArtist', IF ( LEFT( CONVERT(album_artist.name USING UTF8), 4)='The ', SUBSTRING(CONVERT(album_artist.name USING UTF8) FROM 5), CONVERT(album_artist.name USING UTF8)) AS AlbumArtistAlt, CONVERT(album_artist.namesort USING UTF8) AS 'AlbumArtistSort', IF ( LEFT( CONVERT(album_artist.namesort USING UTF8), 4)='THE ', SUBSTRING(CONVERT(album_artist.namesort USING UTF8) FROM 5), CONVERT(album_artist.namesort USING UTF8)) AS AlbumArtistSortAlt, CONVERT(albums.title USING UTF8) AS 'AlbumName', albums.id AS 'AlbumID', CONVERT(tracks.title USING UTF8) AS 'Title', CONVERT(tracks.disc USING UTF8) AS 'Disc', CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as 'Duration', albums.year AS 'AlbumYear', tracks.url AS 'path', tracks.tracknum AS 'TrackNum', comments.value AS 'comment', tracks.id AS 'TrackID', GROUP_CONCAT(DISTINCT CONVERT(track_artist.name USING UTF8) SEPARATOR ';') AS 'TrackArtist', GROUP_CONCAT(DISTINCT CONVERT(genres.name USING UTF8) SEPARATOR ';') AS 'genre', tracks.lossless AS 'lossless', tracks.bitrate AS 'bitrate', tracks.content_type AS 'codec' FROM albums join contributors AS album_artist on albums.contributor=album_artist.id left join tracks on tracks.album=albums.id left join genre_track on genre_track.track=tracks.id left join genres on genre_track.genre=genres.id left join comments on comments.track=tracks.id join contributor_track ON tracks.id = contributor_track.track and contributor_track.role in (1,6) join contributors AS track_artist on contributor_track.contributor = track_artist.id WHERE INSTR(UCASE(tracks.url), 'volume1/MP3') GROUP BY TrackID, AlbumName, Disc, TrackNum ORDER BY album_artist.namesort, albums.titlesort, ABS(tracks.disc), tracks.tracknum, track_artist.name, tracks.url; -- arubaluba ------------------------------------------------------------------------ arubaluba's Profile: http://forums.slimdevices.com/member.php?userid=32369 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss