I still can't browse my libary with the web interface - using the controler (Squeezebox Duet) it works fine so I don't think this to be a database problem! It SEEMS to depend on a missing column "albums.year"?

e.g.:
I can open "artists" from the main menu, but
Clicking on an artists name produces an error message in the server.log:

[09-08-04 19:12:46.6156] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'albums.year' in 'order clause' [for Statement "SELECT album.id, album.titlesort, album.contributor, album.compilation, album.year, album.artwork, album.disc, album.discc, album.musicmagic_mixable, album.titlesearch, album.replay_gain, album.replay_peak, album.musicbrainz_id, album.title FROM contributors me LEFT JOIN contributor_album contributorAlbums ON contributorAlbums.contributor = me.id JOIN albums album ON album.id = contributorAlbums.album WHERE ( ( contributorAlbums.role IN ( ?, ?, ? ) AND me.id = ? ) ) GROUP BY album.id ORDER BY albums.year,concat('0', contributors.namesort),concat('0', albums.titlesort) LIMIT 6" with ParamValues: 0=1, 1=5, 2=6, 3=508] at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 86
[09-08-04 19:12:46.6165] Slim::Schema::Storage::throw_exception (82) Backtrace: (...)


I CAN't open ALBUMS from the main menu, it produces another error message:
[09-08-04 19:15:30.4876] Slim::Networking::IO::Select::__ANON__ (140) Error: Select task failed calling Slim::Web::HTTP::processHTTP: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'albums.year' in 'order clause' [for Statement "SELECT 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.title FROM albums me JOIN contributors contributor ON contributor.id = me.contributor GROUP BY me.id ORDER BY albums.year,concat('0', contributors.namesort),concat('0', albums.titlesort),me.disc LIMIT 50"] at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 86
; fh=Slim::Web::HTTP::ClientConn=GLOB(0x786bfac)


Same with the search functions:
I can find albums, click on them, show them and play them.

BUT
If I search for an ARTIST and click on an artists name there's again only an error message in the server.log:

[09-08-04 19:19:52.5696] Slim::Networking::IO::Select::__ANON__ (140) Error: Select task failed calling Slim::Web::HTTP::processHTTP: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'albums.year' in 'order clause' [for Statement "SELECT album.id, album.titlesort, album.contributor, album.compilation, album.year, album.artwork, album.disc, album.discc, album.musicmagic_mixable, album.titlesearch, album.replay_gain, album.replay_peak, album.musicbrainz_id, album.title FROM contributors me LEFT JOIN contributor_album contributorAlbums ON contributorAlbums.contributor = me.id JOIN albums album ON album.id = contributorAlbums.album WHERE ( me.id = ? ) GROUP BY album.id ORDER BY albums.year,concat('0', contributors.namesort),concat('0', albums.titlesort) LIMIT 32" with ParamValues: 0=243] at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 86
; fh=Slim::Web::HTTP::ClientConn=GLOB(0x7a83fdc)


I did it 3 times now (re-install), 1 time with SQlite, 2 times with MYSql, 3 different builds, everytime the same error message.
If the database is "wrong" then "something" causes SC to create a wrong database, but what? (Firewall and AntiVir are off). And how can I repair, what could I do more thana a clean (re-install)?

TABLE `slimserver`.`albums` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` blob,
`titlesort` text,
`titlesearch` text,
`customsearch` text,
`compilation` tinyint(1) default NULL,
`year` smallint(5) unsigned default NULL,
`artwork` int(10) unsigned default NULL,
`disc` tinyint(1) unsigned default NULL,
`discc` tinyint(1) unsigned default NULL,
`replay_gain` float default NULL,
`replay_peak` float default NULL,
`musicbrainz_id` varchar(40) default NULL,
`musicmagic_mixable` tinyint(1) default NULL,
`contributor` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `albumsTitleIndex` (`title`(255)),
KEY `albumsSortIndex` (`titlesort`(255)),
KEY `albumsSearchIndex` (`titlesearch`(255)),
KEY `albumsCustomSearchIndex` (`customsearch`(255)),
KEY `compilationSortIndex` (`compilation`),
KEY `albumsYearIndex` (`year`),
KEY `albumsDiscIndex` (`disc`),
KEY `albumsDiscCountIndex` (`discc`),
KEY `albumsArtworkIndex` (`artwork`)