Hello.
Hope somebody here can help me.
First of all. Ive used an earlier version of ACC and I think it is
marvelous! It gave me a very nice catalogue of all my music.
Now I have resintalled a new PC and a new Squeezebox server and I am
not able to make ACC run.
PC is running windows XP with servicepack 3. Norwegian version. This
means I dont have C:\Program Files, but I have C:\Programfiler
Squeezebox server installed is latest version 7,6,1 and data and server
are all installed on the same PC
Running ACC 3.4 and MySQLconnection 5.1.9, (installed from
mysql-connector-odbc-5.1.9-win32.msi)
All 32bit
Windows XP, Squeezebox server, the music collection and ACC are all
installed and running on the same PC. Nothing is remote
I have removed HKEY-CURRENT_USER\Software\ACC key from the registry,
but still no success.
I have tried to turn off Windows firewall and antivirus but no
success.
I will be very happy any feedback on this.
Regards T2capa
I get this error message 3716 and a picture is attached
Here is a copy of the ACC log file:
ACC Version : 3.4
STARTED : 07.10.2011 --- 07:12:42
STATUS : fnStart():ENTER:07:12:42
MAIN PREFERENCES
--------------------------------------------------------
OPTION SELEC: Catalog Title = Squeezebox Album Collection
OPTION SELEC: Catalog Sub Title: =
OPTION SELEC: Location of album property data = 1
OPTION SELEC: Display Tracks = Sann
OPTION SELEC: Display track duration = Sann
OPTION SELEC: Display Genre = Usann
OPTION SELEC: Display starting Capitals = Usann
OPTION SELEC: Display codec = Usann
OPTION SELEC: Display bitrate = Usann
OPTION SELEC: Create Table Of content = Sann
OPTION SELEC: Normal album art = Sann
OPTION SELEC: Use Large track fonts = Sann
OPTION SELEC: Sort by = 1
OPTION SELEC: Sort artist by ARTISTSORT tag = Usann
OPTION SELEC: Group by comment = 0
OPTIONS
-----------------------------------------------------------------
OPTION SELEC: Use album cover stored in SqueezeCenter instead of
physical file(slow) = Sann
OPTION SELEC: Use Zero Prefix = 0
OPTION SELEC: Swap Artist - track for VA albums = 0
OPTION SELEC: Ignore 'The' prefix when sorting = Usann
OPTION SELEC: Vertical align = 0
OPTION SELEC: Horizontal align = 0
OPTION SELEC: Apply Drop Shadows to Album covers = -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 = -1
OPTION SELEC: Filter: Comments entered =
OPTION SELEC: Filter: CommentInclude = -1
OPTION SELEC: Filter: Starting folder =
ADVANCED OPTIONS
--------------------------------------------------------
OPTION SELEC: Create .MHT = 0
OPTION SELEC: TPE2 tag is AlbumArtist instead of band = 0
OPTION SELEC: Create CSV file = 0
OPTION SELEC: Maximum tracks on page = 110
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 = 127.0.0.1
OPTION SELEC: Port Number = 9000
OPTION SELEC: Mapped local drive = -1
OPTION SELEC: Physical directory path =
END OF GUI OPTIONS
------------------------------------------------------
STATUS : fnStart():LEAVE:07:12:42
STATUS : fnStart2():ENTER:07:12:42
STATUS : fnStart2():MySQL Connectstring=DRIVER={MySQL ODBC 5.1
Driver};Server=127.0.0.1;Port=9092;Database=slimserver;UID=slimserver;Password=slimserver;Option=3
STATUS : fnQueryLogic():ENTER:07:12:42
STATUS : fnCreateACCTable():ENTER:07:13:01
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
GROUP BY TrackID, AlbumName, Disc, TrackNum
ORDER BY album_artist.name, albums.titlesort, ABS(tracks.disc),
tracks.tracknum, track_artist.name, tracks.url;
+-------------------------------------------------------------------+
|Filename: acc feilmeld.JPG |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=12573|
+-------------------------------------------------------------------+
--
t2capa
------------------------------------------------------------------------
t2capa's Profile: http://forums.slimdevices.com/member.php?userid=10030
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
