Cocktail Audio™ UK Support Forum

|| www.facebook.com/CocktailAudioUK || www.cocktailaudio.co.uk || www.trustpilot.com/review/cocktailaudio.co.uk ||
It is currently Mon Aug 08, 2022 10:25 am

All times are UTC


Untitled Document

Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Wed Apr 27, 2022 2:12 pm 
Offline

Joined: Tue Dec 22, 2015 2:27 pm
Posts: 30
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!


Top
 Profile  
Reply with quote  
PostPosted: Thu Apr 28, 2022 1:17 pm 
Offline

Joined: Sun Jun 24, 2012 6:12 am
Posts: 397
Strange, have you tried removing LMS & adding it again?
You may have an update error...what is your FW version?

Cheers


Top
 Profile  
Reply with quote  
PostPosted: Thu Apr 28, 2022 1:20 pm 
Offline

Joined: Tue Dec 22, 2015 2:27 pm
Posts: 30
thanks for the reply

firmware 2.8 will remove and reinstall LMS later on

john


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron