I have a DB error during scanning.
Code:
[16-02-01 23:03:22.6530] Slim::Schema::Storage::throw_exception (122) Error:
DBI Exception: DBD::SQLite::st fetch failed: not an error
database disk image is malformed [for Statement "
SELECT
tracks.url,
tracks.cover,
tracks.coverid,
albums.id AS albumid,
albums.title AS album_title,
albums.artwork AS album_artwork
FROM tracks
JOIN albums ON (tracks.album = albums.id)
WHERE tracks.cover != '0'
ANDtracks.coverid IS NOT NULL
ANDtracks.cover_cached IS NULL
GROUP BY tracks.cover
"]
[16-02-01 23:03:22.6564] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 122)
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/share/perl5/Slim/Music/Artwork.pm line 663)
frame 3: Slim::Music::Artwork::__ANON__
(/usr/share/perl5/Slim/Music/Artwork.pm line 752)
frame 4: Slim::Music::Artwork::precacheAllArtwork
(/usr/share/perl5/Slim/Music/Import.pm line 432)
frame 5: Slim::Music::Import::runScanPostProcessing
(/usr/sbin/squeezeboxserver-scanner line 340)
frame 6: (eval) (/usr/sbin/squeezeboxserver-scanner line 340)
frame 7: main::main (/usr/sbin/squeezeboxserver-scanner line 498)
[16-02-01 23:03:22.6599] main::main (344) Error: Failed when running scan
post-process: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::st fetch
failed: not an error
database disk image is malformed [for Statement "
SELECT
tracks.url,
tracks.cover,
tracks.coverid,
albums.id AS albumid,
albums.title AS album_title,
albums.artwork AS album_artwork
FROM tracks
JOIN albums ON (tracks.album = albums.id)
WHERE tracks.cover != '0'
ANDtracks.coverid IS NOT NULL
ANDtracks.cover_cached IS NULL
GROUP BY tracks.cover
"] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
]
[16-02-01 23:03:22.6616] main::main (345) Error: Not updating lastRescanTime!
How can I repair the database ?
Thanks
minscof's Profile: http://forums.slimdevices.com/member.php?userid=52139
View this thread: http://forums.slimdevices.com/showthread.php?t=105128
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter