I have some problems with "unnecessary" informations in the tables 'years' and 'genre'. This entries was initially scanned from "wrong" id3tag values.
After cleaning/fixing all this "wrong" id3tags I made a Re-Scan of the tracks. But if I click on the still visible (wrong) year or (wrong) genre-selection I get a: 0 albums with 0 titels from 0 artists. I thought that a scanner.exe --cleanup (under windows) could help to organize this. But this is what I get: C:\Programme\SlimServer\server>scanner.exe --cleanup --progress e:\mp3 2007-01-07 17:28:23.7968 scanPathOrURL: Finding valid files in: e:\mp3 2007-01-07 17:28:23.7977 About to look for files in E:\mp3 2007-01-07 17:28:23.8007 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf |wax|asx|lnk|wpl|shn|wav|wave|mp3|mp2|m3u|pls|xspf|flc|flac|m4a|mov|m4b|mp4|cue| mp+|mpc|ogg|aif|aiff|lnk)$)] 2007-01-07 17:30:46.3593 Found XXXX files in E:\mp3 0% [= ] 110.82 tracks/sec YmZZs LEFT Use of uninitialized value in string eq at /PerlApp/Slim/Schema.pm line 1883. 1% [= ] 12.61 tracks/sec YmZZs LEFT 2007-01-07 17:33:19.8750 ERROR: Error executing 'UPDATE tracks SET audio_offset = ?, audio_size = ?, bitrate = ?, filesize = ?, secs = ?, timestamp = ?, tracknum = ?, vbr_scale = ?, year = ? WHERE ( id = ? )' : DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at C:\Programme\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. 2007-01-07 17:33:19.8750 ERROR: Backtrace follows: 2007-01-07 17:33:19.8754 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (C:\Programme\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (C:\Programme\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 797) frame 2: DBIx::Class::Storage::DBI::update (C:\Programme\SlimServer\server\CPAN/DBIx/Class/Row.pm line 115) frame 3: DBIx::Class::Row::update (C:\Programme\SlimServer\server\CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30) frame 4: DBIx::Class::Relationship::CascadeActions::update (C:\Programme\SlimServer\server\CPAN/DBIx/Class/InflateColumn.pm line 222) frame 5: DBIx::Class::InflateColumn::update (C:\Programme\SlimServer\server/Slim/Schema/DBI.pm line 35) frame 6: Slim::Schema::DBI::update (/PerlApp/Slim/Schema.pm line 2217) frame 7: Slim::Schema::_postCheckAttributes (/PerlApp/Slim/Schema.pm line 980) frame 8: Slim::Schema::updateOrCreate (/PerlApp/Slim/Utils/Scanner.pm line 322) frame 9: Slim::Utils::Scanner::scanDirectory (/PerlApp/Slim/Utils/Scanner.pm line 90) frame 10: Slim::Utils::Scanner::scanPathOrURL (scanner.pl line 168) frame 11: (eval) (scanner.pl line 168) frame 12: main::main (scanner.pl line 312) 2007-01-07 17:33:20.0119 ERROR: Scanner: Failed when running main scan: [Carp::C lan::__ANON__(): Error executing 'UPDATE tracks SET audio_offset = ?, audio_size = ?, bitrate = ?, filesize = ?, secs = ?, timestamp = ?, tracknum = ?, vbr_scal e = ?, year = ? WHERE ( id = ? )' : DBD::mysql::st execute failed: Lock wait time out exceeded; try restarting transaction at C:\Programme\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.] 2007-01-07 17:33:20.0402 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime! C:\Programme\SlimServer\server> Could this be the reason, why I never see a time-entry in the 'rescans'-table? What can I do to prevent this "Lock wait time out"? Should I change a my.ini-entry? -- PatPowerMan ------------------------------------------------------------------------ PatPowerMan's Profile: http://forums.slimdevices.com/member.php?userid=9254 View this thread: http://forums.slimdevices.com/showthread.php?t=31393 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
