Cocktail Audio™ UK Support Forum

HI

i have added some files and requsted a rescan this fails every tome as below - any ideas to fix ?

if i delete and rescan all it works ok

[22-04-27 14:09:55.2573] main::main (206) Starting Logitech Media Server scanner (v8.3.0, 0.1.20220215git1644768372, Tue Feb 15 14:06:42 EST 2022) perl 5.028002
[22-04-27 14:09:55.5634] Carp::Clan::__ANON__ (216) Warning: DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/lib64/perl5/vendor_perl/Slim/Schema.pm line 1905
[22-04-27 14:09:56.7846] Slim::Music::Import::runImporter (578) Starting Slim::Media::MediaFolderScan scan
[22-04-27 14:09:56.7854] Slim::Utils::Scanner::Local::rescan (179) Discovering audio files in /storage/music/flac
[22-04-27 14:10:01.4258] Slim::Utils::Scanner::Local::__ANON__ (191) Start processing found tracks
[22-04-27 14:10:01.4264] Slim::Utils::Scanner::Local::__ANON__ (199) Connect do DB
[22-04-27 14:10:01.4267] Slim::Utils::Scanner::Local::__ANON__ (202) Get latest ID
[22-04-27 14:10:01.4273] Slim::Utils::Scanner::Local::__ANON__ (225) Build temporary table for new tracks
[22-04-27 14:10:01.5709] Slim::Utils::Scanner::Local::__ANON__ (245) Build temporary table for new tracks
[22-04-27 14:10:01.7165] Slim::Utils::Scanner::Local::__ANON__ (282) Get deleted tracks count
[22-04-27 14:10:01.8790] Slim::Utils::Scanner::Local::__ANON__ (289) Get new tracks count
[22-04-27 14:10:01.8799] Slim::Utils::Scanner::Local::__ANON__ (294) Get changed tracks count
[22-04-27 14:10:01.8805] Slim::Schema::Storage::throw_exception (121) Error: DBI Exception: DBD::SQLite::db selectrow_array failed: no such column: url [for Statement "
SELECT COUNT(*) FROM (
SELECT url
FROM changed
) AS t1
"]
[22-04-27 14:10:01.8809] Slim::Schema::Storage::throw_exception (121) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/Slim/Schema/Storage.pm line 121)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/lib64/perl5/vendor_perl/Slim/Utils/Scanner/Local.pm line 296)
frame 3: Slim::Utils::Scanner::Local::__ANON__ (/usr/lib64/perl5/vendor_perl/Slim/Utils/Scanner/Local/Async.pm line 86)
frame 4: Slim::Utils::Scanner::Local::Async::__ANON__ (/usr/lib64/perl5/vendor_perl/Slim/Utils/Scanner/Local/Async.pm line 169)
frame 5: Slim::Utils::Scanner::Local::Async::find (/usr/lib64/perl5/vendor_perl/Slim/Utils/Scanner/Local.pm line 104)
frame 6: Slim::Utils::Scanner::Local::find (/usr/lib64/perl5/vendor_perl/Slim/Utils/Scanner/Local.pm line 341)
frame 7: Slim::Utils::Scanner::Local::rescan (/usr/lib64/perl5/vendor_perl/Slim/Media/MediaFolderScan.pm line 65)
frame 8: Slim::Media::MediaFolderScan::startScan (/usr/lib64/perl5/vendor_perl/Slim/Music/Import.pm line 580)
frame 9: Slim::Music::Import::runImporter (/usr/lib64/perl5/vendor_perl/Slim/Music/Import.pm line 402)
frame 10: Slim::Music::Import::runScan (/usr/libexec/squeezeboxserver-scanner line 333)
frame 11: (eval) (/usr/libexec/squeezeboxserver-scanner line 327)
frame 12: main::main (/usr/libexec/squeezeboxserver-scanner line 499)

[22-04-27 14:10:01.8815] main::main (338) Error: Failed when running main scan: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectrow_array failed: no such column: url [for Statement "
SELECT COUNT(*) FROM (
SELECT url
FROM changed
) AS t1
"] at /usr/lib64/perl5/vendor_perl/Slim/Schema/Storage.pm line 125
]
[22-04-27 14:10:01.8819] main::main (339) Error: Skipping post-process & Not updating lastRescanTime!

Strange, have you tried removing LMS & adding it again?
You may have an update error...what is your FW version?

Cheers

thanks for the reply

firmware 2.8 will remove and reinstall LMS later on

john