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
