PDA

View Full Version : 6.5.3 No Artwork and Cannot restore TrackStat



ganjastone
2007-07-21, 16:21
Hi,

must be doing something extremly stupid. I was running 6.5.1 and was very happy with it. found out new hebrew fonts are available in 6.5.3, and silly me, I upgraded!

Now no artwork at all, except for if I drill down to albums, so I disable antivirus not to interfere with mysql and did a clean rescan. still the same...

Also tried restoring from my latest TrackStat backup but it shows no indication the old statistics are applied in any trackstat lists...

Please help.

here is some voodoo from log.txt:

2007-07-22 01:11:14.8761 ERROR: Error executing '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 GROUP BY me.id ORDER BY concat('0', me.titlesort),me.disc LIMIT 94': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8c4_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-07-22 01:11:14.8763 ERROR: Backtrace follows:

2007-07-22 01:11:14.8768 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Cursor.pm line 69)
frame 4: DBIx::Class::Cursor::all (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 115)
frame 5: DBIx::Class::Storage::DBI::Cursor::all (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 945)
frame 6: DBIx::Class::ResultSet::all (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 143)
frame 7: DBIx::Class::ResultSet::search (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 659)
frame 8: DBIx::Class::ResultSet::slice (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/Pages/BrowseDB.pm line 388)
frame 9: Slim::Web::Pages::BrowseDB::browsedb (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 837)
frame 10: Slim::Web::HTTP::generateHTTPResponse (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 703)
frame 11: Slim::Web::HTTP::processURL (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 549)
frame 12: Slim::Web::HTTP::processHTTP (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Networking/Select.pm line 238)
frame 13: (eval) (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Networking/Select.pm line 238)
frame 14: Slim::Networking::Select::select (slimserver.pl line 492)
frame 15: main::idle (slimserver.pl line 445)
frame 16: main::main (slimserver.pl line 58)
frame 17: PerlSvc::Interactive (perlsvc line 854)
frame 18: PerlSvc::_interactive (slimserver.pl line 0)
frame 19: (eval) (slimserver.pl line 0)

2007-07-22 01:11:14.8780 Select task failed: Carp::Clan::__ANON__(): Error executing '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 GROUP BY me.id ORDER BY concat('0', me.titlesort),me.disc LIMIT 94': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8c4_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

...

2007-07-22 01:16:52.9001 no need to process image for music/7130/cover.jpg
2007-07-22 01:16:52.9002 caching result key: 7130-squash---2147483647
2007-07-22 01:35:21.0029 ERROR: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8c4_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-07-22 01:35:21.0032 ERROR: Backtrace follows:

2007-07-22 01:35:21.0035 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 3: DBIx::Class::Storage::DBI::select_single (C:\Program Files\SlimServer\server/Slim/Schema/Storage.pm line 94)
frame 4: Slim::Schema::Storage::select_single (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 509)
frame 5: DBIx::Class::ResultSet::single (C:\Program Files\SlimServer\server/Slim/Schema/Track.pm line 95)
frame 6: Slim::Schema::Track::artist (C:\Program Files\SlimServer\server/Slim/Schema/Track.pm line 390)
frame 7: Slim::Schema::Track::displayAsHTML (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/Pages/BrowseDB.pm line 424)
frame 8: Slim::Web::Pages::BrowseDB::browsedb (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 837)
frame 9: Slim::Web::HTTP::generateHTTPResponse (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 703)
frame 10: Slim::Web::HTTP::processURL (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 549)
frame 11: Slim::Web::HTTP::processHTTP (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Networking/Select.pm line 238)
frame 12: (eval) (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Networking/Select.pm line 238)
frame 13: Slim::Networking::Select::select (slimserver.pl line 492)
frame 14: main::idle (slimserver.pl line 445)
frame 15: main::main (slimserver.pl line 58)
frame 16: PerlSvc::Interactive (perlsvc line 854)
frame 17: PerlSvc::_interactive (slimserver.pl line 0)
frame 18: (eval) (slimserver.pl line 0)

2007-07-22 01:35:21.0052 Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8c4_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-07-22 01:35:24.8431 Retrieving artwork (cover) for: file:///F:/Music/Emilie%20Simon/Vegetal/01%20-%20alicia.flac
2007-07-22 01:35:24.8630 readCoverArtTags: Looking for a cover art image in the tags of: [F:\Music\Emilie Simon\Vegetal\01 - alicia.flac]
2007-07-22 01:35:24.8908 Looking for image files in F:\Music\Emilie Simon\Vegetal
2007-07-22 01:35:24.9646 Found cover file: F:\Music\Emilie Simon\Vegetal\folder.jpg
2007-07-22 01:35:26.6699 Cover Art asking for trackid: 1342 - cover
2007-07-22 01:35:26.6701 artwork cache key: 1342-squash---2147483647
2007-07-22 01:35:26.6936 Retrieving artwork (cover) for: file:///F:/Music/Emilie%20Simon/Vegetal/01%20-%20alicia.flac
2007-07-22 01:35:26.7017 coverArt: Found cached cover file: F:\Music\Emilie Simon\Vegetal\folder.jpg
2007-07-22 01:35:26.7032 got cover art image image/jpeg of 116386 bytes
2007-07-22 01:35:26.7034 no need to process image for music/1342/cover.jpg
2007-07-22 01:35:26.7035 caching result key: 1342-squash---2147483647
2007-07-22 01:39:08.7579 Retrieving artwork (cover) for: file:///F:/Music/Various/Lazy%20Days%20And%20Sundays%20II/01%20six%20seven%20times.flac
2007-07-22 01:39:08.7594 readCoverArtTags: Looking for a cover art image in the tags of: [F:\Music\Various\Lazy Days And Sundays II\01 six seven times.flac]
2007-07-22 01:39:08.7638 Looking for image files in F:\Music\Various\Lazy Days And Sundays II
2007-07-22 01:39:08.8082 Found cover file: F:\Music\Various\Lazy Days And Sundays II\folder.jpg
2007-07-22 01:39:09.4314 Cover Art asking for trackid: 9406 - cover
2007-07-22 01:39:09.4316 artwork cache key: 9406-squash---2147483647
2007-07-22 01:39:09.4325 Retrieving artwork (cover) for: file:///F:/Music/Various/Lazy%20Days%20And%20Sundays%20II/01%20six%20seven%20times.flac
2007-07-22 01:39:09.4360 coverArt: Found cached cover file: F:\Music\Various\Lazy Days And Sundays II\folder.jpg
2007-07-22 01:39:09.4377 got cover art image image/jpeg of 160506 bytes
2007-07-22 01:39:09.4379 no need to process image for music/9406/cover.jpg
2007-07-22 01:39:09.4380 caching result key: 9406-squash---2147483647
2007-07-22 01:39:15.8007 Retrieving artwork (thumb) for: file:///F:/Music/Various/Lazy%20Days%20And%20Sundays%20II/01%20six%20seven%20times.flac
2007-07-22 01:39:15.8012 readCoverArtTags: Looking for a cover art image in the tags of: [F:\Music\Various\Lazy Days And Sundays II\01 six seven times.flac]
2007-07-22 01:39:15.8046 Looking for image files in F:\Music\Various\Lazy Days And Sundays II
2007-07-22 01:39:15.8140 Found thumb file: F:\Music\Various\Lazy Days And Sundays II\folder.jpg
2007-07-22 01:39:16.1613 Retrieving artwork (cover) for: file:///F:/Music/Various/Lazy%20Days%20And%20Sundays%20II/01%20six%20seven%20times.flac

ganjastone
2007-07-21, 16:21
2007-07-22 01:39:16.1645 coverArt: Found cached cover file: F:\Music\Various\Lazy Days And Sundays II\folder.jpg
2007-07-22 01:39:16.3174 Cover Art asking for trackid: 9406 - cover
2007-07-22 01:39:16.3176 artwork cache key: 9406-squash---2147483647
2007-07-22 01:39:16.3227 returning cached artwork image.
2007-07-22 01:42:06.7741 Couldn't open backup file: trackstat_scheduled_backup_20070721 at C:\Program Files\SlimServer\server/Plugins/TrackStat/Backup/File.pm line 226.
2007-07-22 01:44:13.6577 Couldn't open backup file: trackstat_scheduled_backup_20070721.xml at C:\Program Files\SlimServer\server/Plugins/TrackStat/Backup/File.pm line 226.
2007-07-22 01:46:15.8378 TrackStat: Entering baseWebPage
2007-07-22 01:46:15.8380 TrackStat: Entering getTrackInfo
2007-07-22 01:46:15.8382 TrackStat: Exiting getTrackInfo
2007-07-22 01:46:15.8394 TrackStat: Get statistic context for level=1
2007-07-22 01:46:15.8396 TrackStat: Get statistic context for level=2
2007-07-22 01:46:15.8398 TrackStat: Exiting baseWebPage
2007-07-22 01:46:15.8402 TrackStat: Calling webfunction for toprated
2007-07-22 01:46:15.8408 TrackStat::Statistics: Executing: select tracks.id,track_statistics.playCount,track_statist ics.added,track_statistics.lastPlayed,track_statis tics.rating from tracks left join track_statistics on tracks.url = track_statistics.url where tracks.audio=1 order by track_statistics.rating desc,track_statistics.playCount desc,tracks.playCount desc,rand() limit 50;
2007-07-22 01:46:16.3207 TrackStat::Statistics: Got 50 items
2007-07-22 01:46:16.8593 TrackStat::Statistics: Returning 50 items
2007-07-22 01:46:37.3345 TrackStat:Backup: Restore from: trackstat_scheduled_backup_20070721
2007-07-22 01:46:40.4772 Couldn't open backup file: trackstat_scheduled_backup_20070721 at C:\Program Files\SlimServer\server/Plugins/TrackStat/Backup/File.pm line 226.
2007-07-22 01:46:45.0983 TrackStat: Entering baseWebPage
2007-07-22 01:46:45.0985 TrackStat: Entering getTrackInfo
2007-07-22 01:46:45.0987 TrackStat: Exiting getTrackInfo
2007-07-22 01:46:45.0999 TrackStat: Get statistic context for level=1
2007-07-22 01:46:45.1024 TrackStat: Get statistic context for level=2
2007-07-22 01:46:45.1026 TrackStat: Exiting baseWebPage
2007-07-22 01:46:45.1028 TrackStat: Calling webfunction for toprated
2007-07-22 01:46:45.1033 TrackStat::Statistics: Executing: select tracks.id,track_statistics.playCount,track_statist ics.added,track_statistics.lastPlayed,track_statis tics.rating from tracks left join track_statistics on tracks.url = track_statistics.url where tracks.audio=1 order by track_statistics.rating desc,track_statistics.playCount desc,tracks.playCount desc,rand() limit 50;
2007-07-22 01:46:45.5781 TrackStat::Statistics: Got 50 items
2007-07-22 01:46:46.1093 TrackStat::Statistics: Returning 50 items
2007-07-22 01:46:50.3599 TrackStat: Entering baseWebPage
2007-07-22 01:46:50.3602 TrackStat: Entering getTrackInfo
2007-07-22 01:46:50.3604 TrackStat: Exiting getTrackInfo
2007-07-22 01:46:50.3617 TrackStat: Get statistic context for level=1
2007-07-22 01:46:50.3620 TrackStat: Get statistic context for level=2
2007-07-22 01:46:50.3622 TrackStat: Exiting baseWebPage
2007-07-22 01:46:50.3623 TrackStat: Calling webfunction for toprated
2007-07-22 01:46:50.3628 TrackStat::Statistics: Executing: select tracks.id,track_statistics.playCount,track_statist ics.added,track_statistics.lastPlayed,track_statis tics.rating from tracks left join track_statistics on tracks.url = track_statistics.url where tracks.audio=1 order by track_statistics.rating desc,track_statistics.playCount desc,tracks.playCount desc,rand() limit 50;
2007-07-22 01:46:50.8281 TrackStat::Statistics: Got 50 items
2007-07-22 01:46:51.3750 TrackStat::Statistics: Returning 50 items
2007-07-22 01:54:41.8908 TrackStat: Checking if its time to do a scheduled backup
2007-07-22 01:54:41.8911 TrackStat: Its 3960 seconds left until next scheduled backup
2007-07-22 02:00:15.9747 TrackStat: Entering commandCallback65
2007-07-22 02:00:15.9754 TrackStat: Exiting commandCallback65
2007-07-22 02:00:16.0045 TrackStat: Entering commandCallback65
2007-07-22 02:00:16.0051 TrackStat: Exiting commandCallback65
2007-07-22 02:00:16.0934 TrackStat: Entering commandCallback65
2007-07-22 02:00:16.0940 TrackStat: Exiting commandCallback65
2007-07-22 02:09:41.9063 TrackStat: Checking if its time to do a scheduled backup
2007-07-22 02:09:41.9066 TrackStat: Its 3060 seconds left until next scheduled backup
2007-07-22 02:11:32.7861 TrackStat: Entering commandCallback65
2007-07-22 02:11:32.7870 TrackStat::Storage: Checking if additional indexes are needed for tracks
2007-07-22 02:11:32.9050 TrackStat::Storage: Starting to analyze indexes
2007-07-22 02:11:33.1214 TrackStat::Storage: Finished analyzing indexes : It took 0.334517 seconds
2007-07-22 02:11:33.1216 TrackStat::Storage: Starting to update urls in statistic data based on musicbrainz ids
2007-07-22 02:11:33.1243 TrackStat::Storage: Finished updating urls in statistic data based on musicbrainz ids, updated 0 items : It took 0.002609 seconds
2007-07-22 02:11:33.1245 TrackStat::Storage: Starting to update musicbrainz id's in statistic data based on urls
2007-07-22 02:11:33.3438 TrackStat::Storage: Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 0.219171 seconds
2007-07-22 02:11:33.3440 TrackStat::Storage: Starting to update ratings in standard slimserver database based on urls
2007-07-22 02:11:33.9844 TrackStat::Storage: Finished updating ratings in standard slimserver database based on urls, updated 0 items : It took 0.640332 seconds
2007-07-22 02:11:33.9846 TrackStat::Storage: Starting to update added times in statistic data based on urls
2007-07-22 02:11:34.4235 TrackStat::Storage: Finished updating added times in statistic data based on urls, updated 0 items : It took 0.438762 seconds
2007-07-22 02:11:34.4237 TrackStat::Storage: Starting to add tracks without added times in statistic data based on urls
2007-07-22 02:11:34.9688 TrackStat::Storage: Finished adding tracks without added times in statistic data based on urls, added 32 items : It took 0.545017 seconds
2007-07-22 02:11:34.9690 TrackStat::Storage: Starting to update ratings in statistic data based on urls
2007-07-22 02:11:34.9861 TrackStat::Storage: Finished updating ratings in statistic data based on urls, updated 0 items : It took 0.01701 seconds
2007-07-22 02:11:34.9863 TrackStat::Storage: Starting to update unrated ratings in statistic data based on null
2007-07-22 02:11:35.0211 TrackStat::Storage: Finished updating unrated ratings in statistic data based on null, updated 32 items : It took 0.034666 seconds
2007-07-22 02:11:35.0213 TrackStat::Storage: Starting to update urls in track_history based on musicbrainz ids
2007-07-22 02:11:35.0236 TrackStat::Storage: Finished updating urls in track_history based on musicbrainz ids, updated 0 items : It took 0.002268 seconds
2007-07-22 02:11:35.0239 TrackStat::Storage: Starting to update musicbrainz id's in track_history based on urls
2007-07-22 02:11:35.0565 TrackStat::Storage: Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 0.032577 seconds
2007-07-22 02:11:35.0567 TrackStat::Storage: Starting to add missing entries to history table
2007-07-22 02:11:35.4844 TrackStat::Storage: Finished adding missing entries to history table, adding 0 items : It took 0.427601 seconds
2007-07-22 02:11:35.4846 TrackStat::Storage: Starting to update unrated ratings in history table based on null
2007-07-22 02:11:35.4888 TrackStat::Storage: Finished updating unrated ratings in history table based on null, updated 0 items : It took 0.004126 seconds
2007-07-22 02:11:35.4891 TrackStat: Exiting commandCallback65
2007-07-22 02:13:51.4732 Retrieving artwork (cover) for: file:///E:/IVRIT/__ENGLISH/Oi%20Va%20Voi/Laughter%20Through%20Tears/01%20Refugee.FLAC
2007-07-22 02:13:51.4748 readCoverArtTags: Looking for a cover art image in the tags of: [E:\IVRIT\__ENGLISH\Oi Va Voi\Laughter Through Tears\01 Refugee.FLAC]
2007-07-22 02:13:51.4926 readCoverArtTags: Found image of length [27195] bytes with type: [image/jpeg]
2007-07-22 02:13:52.3437 Cover Art asking for trackid: 4393 - cover
2007-07-22 02:13:52.3439 artwork cache key: 4393-squash---2147483647
2007-07-22 02:13:52.3449 Retrieving artwork (cover) for: file:///E:/IVRIT/__ENGLISH/Oi%20Va%20Voi/Laughter%20Through%20Tears/01%20Refugee.FLAC
2007-07-22 02:13:52.3455 readCoverArtTags: Looking for a cover art image in the tags of: [E:\IVRIT\__ENGLISH\Oi Va Voi\Laughter Through Tears\01 Refugee.FLAC]
2007-07-22 02:13:52.3485 readCoverArtTags: Found image of length [27195] bytes with type: [image/jpeg]
2007-07-22 02:13:52.3501 got cover art image image/jpeg of 27195 bytes
2007-07-22 02:13:52.3503 no need to process image for music/4393/cover.jpg
2007-07-22 02:13:52.3504 caching result key: 4393-squash---2147483647

erland
2007-07-21, 20:32
Also tried restoring from my latest TrackStat backup but it shows no indication the old statistics are applied in any trackstat lists...
You will need to set the backup file setting in the TrackStat section of "Server Setttings/Plugins" to:
trackstat_scheduled_backup_20070721.xml
Instead of just:
trackstat_scheduled_backup_20070721

The .xml extension at the end is important.


2007-07-22 01:35:21.0052 Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8c4_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
This really looks like some sort of Antivirus conflict. Are you sure the Antivirus software had been disabled when you got this log message ?

If it was disabled, I think I would try to shutdown SlimServer and then remove the whole "Cache/MySQL" directory within the slimserver installation directory and then startup SlimServer and see if it works any better.

ganjastone
2007-07-22, 01:28
Hi Erland,

Somehow, I figured you would be the first to answer :).

You are correct, the log is with anti virus on. I did 2 things afterwards with the anti virus:
1. disabled scanning of *.MY* files
2. disabled scanning and monitoring of c:\program files\slimserver completely.

In addition tried TrackStat without .xml and with .xml, both dont work for me... (got over 5000 rated songs)

erland
2007-07-22, 01:38
In addition tried TrackStat without .xml and with .xml, both dont work for me... (got over 5000 rated songs)
These log messages indicates that TrackStat can't read the file:


2007-07-22 01:46:37.3345 TrackStat:Backup: Restore from: trackstat_scheduled_backup_20070721
2007-07-22 01:46:40.4772 Couldn't open backup file: trackstat_scheduled_backup_20070721 at C:\Program Files\SlimServer\server/Plugins/TrackStat/Backup/File.pm line 226.


I thought it was the missing .xml, but it can also be some other reason like:
- Wrong path (try entering the full path to the file unless you have already done so)
- The user that runs SlimServer may not have read access to the file, although shouldn't have changed if you just upgraded.

I think it should log the full path, so I suspect you have just entered the file name and if you enter the full path to the backup file it might work.

ganjastone
2007-07-22, 02:08
Erland, You're the man!!!

TrackStat picked all stats after I put full path + file name.xml

Thanks!

I'm still stuck with no artwork. Can anyone help?

erland
2007-07-22, 02:21
If I understand you correctly you are seeing the artwork when you have selected a single album, the problem is that you don't see any artwork when displaying the list of albums ?

I'm guessing that you have selected to view the albums as artwork by clicking on the artwork icon in the upper right corner of the left frame ?

Maybe it is a cache issue, have you tried to clear the web browser cache ?
If that doesn't work maybe it helps to clear the SlimServer artwork cache, I think it's stored in the "Cache/Artwork" directory under the SlimServer installation so you can just delete the "Cache/Artwork" directory. You probably needs to perform a rescan after this.

ganjastone
2007-07-22, 05:12
If I understand you correctly you are seeing the artwork when you have selected a single album, the problem is that you don't see any artwork when displaying the list of albums ?
Correct



I'm guessing that you have selected to view the albums as artwork by clicking on the artwork icon in the upper right corner of the left frame ?
Right on



Maybe it is a cache issue, have you tried to clear the web browser cache ?
If that doesn't work maybe it helps to clear the SlimServer artwork cache, I think it's stored in the "Cache/Artwork" directory under the SlimServer installation so you can just delete the "Cache/Artwork" directory. You probably needs to perform a rescan after this.

I cleared the web browser cache, checked from 4 different machines as well.
I cleared the artwork cache as you instructed with a full clean and rescan.
Still nothing in artwork. Please help.

ganjastone
2007-07-22, 15:42
Suddenly, after shutting down anti virus (NOD32) and after the 4rd clean and rescan all artwork is back!!! and ???

ganjastone
2007-07-25, 15:09
Again no artwork. Anti virus off, yet on every 'clean and rescan' I get this:

2007-07-26 00:50:28.8255 ERROR: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8d0_0.MYD' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-07-26 00:50:28.8264 ERROR: Backtrace follows:

2007-07-26 00:50:28.8270 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 118)
frame 3: DBIx::Class::Storage::DBI::Cursor::all (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 945)
frame 4: DBIx::Class::ResultSet::all (C:\Program Files\SlimServer\server/Slim/Schema/Album.pm line 166)
frame 5: Slim::Schema::Album::artistsForRoles (C:\Program Files\SlimServer\server/Slim/Schema/Album.pm line 176)
frame 6: Slim::Schema::Album::artists (C:\Program Files\SlimServer\server/Slim/Schema/Album.pm line 124)
frame 7: Slim::Schema::Album::displayAsHTML (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/Pages/BrowseDB.pm line 424)
frame 8: Slim::Web::Pages::BrowseDB::browsedb (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 837)
frame 9: Slim::Web::HTTP::generateHTTPResponse (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 703)
frame 10: Slim::Web::HTTP::processURL (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Web/HTTP.pm line 549)
frame 11: Slim::Web::HTTP::processHTTP (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Networking/Select.pm line 238)
frame 12: (eval) (/<C:\Program Files\SlimServer\server\slim.exe>Slim/Networking/Select.pm line 238)
frame 13: Slim::Networking::Select::select (slimserver.pl line 492)
frame 14: main::idle (slimserver.pl line 445)
frame 15: main::main (slimserver.pl line 58)
frame 16: PerlSvc::Interactive (perlsvc line 854)
frame 17: PerlSvc::_interactive (slimserver.pl line 0)
frame 18: (eval) (slimserver.pl line 0)

2007-07-26 00:50:28.8306 Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.album = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8d0_0.MYD' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-07-26 00:56:16.8482 Import: Wiped all in-memory caches.