Hi,
Le 06/02/2020 à 13:35, Agustin Martin a écrit :
> Triaging old bug reports. Is this still a problem with current digikam
> (6.4.0 in sid)? I tried some simple renamings with 6.4.0 and seems to work.
I think that this particular bug can be closed. However, from times to
times, the digikam database become corrupted. But I do not know what
triggers this (renames or other things). I see the corruption when I
remark some images on disk but not displayed in Digikam.
I keep on my disk these notes to help me to fix the database:
use digikamdb;
Cleanup Comments :
SELECT * FROM ImageComments i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
DELETE i FROM ImageComments i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
Cleanup Copyright :
SELECT * FROM ImageCopyright i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
DELETE i FROM ImageCopyright i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
Cleanup Information :
SELECT * FROM ImageInformation i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
DELETE i FROM ImageInformation i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
Cleanup Metadata :
SELECT * FROM ImageMetadata i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
DELETE i FROM ImageMetadata i LEFT OUTER JOIN Images ON Images.id=i.imageid
WHERE Images.name IS NULL;
Cleanup Tags :
SELECT * FROM ImageTags i LEFT OUTER JOIN Images ON Images.id=i.imageid WHERE
Images.name IS NULL;
DELETE i FROM ImageTags i LEFT OUTER JOIN Images ON Images.id=i.imageid WHERE
Images.name IS NULL;
Images without information :
select CONCAT(relativePath, '/', name) from Images LEFT OUTER JOIN
ImageInformation on Images.id=ImageInformation.imageid LEFT OUTER JOIN Albums
on Images.album=Albums.id where ImageInformation.imageid is NULL INTO OUTFILE
'/var/lib/mysql-files/digikam.log' ;
RESTART:
sudo cat /var/lib/mysql-files/digikam.log | while read file ; do
f="$HOME/photos/albums/$file"; if [ -f "$f" ] ; then touch "$f" ; else echo
"Missing $f" ; fi ; done
sudo cat /var/lib/mysql-files/digikam.log | sed -e 's,/[^/]*$,,' | sort -u
**** In digikam, reload metadata from files in these albums
Check that all info is loaded with
select CONCAT(relativePath, '/', name) from Images LEFT OUTER JOIN
ImageInformation on Images.id=ImageInformation.imageid LEFT OUTER JOIN Albums
on Images.album=Albums.id where ImageInformation.creationDate is NULL AND
status != 3 ;
GOTO RESTART
And, to force film thumbnails regeneration in an album:
delete from UniqueHashes where thumbId in (select thumbId from FilePaths where
path like "%17_Irlande/%.avi" );
describe Thumbnails ;
delete from Thumbnails where id in (select thumbId as id from FilePaths where
path like "%17_Irlande/%.avi" );
delete from FilePaths where path like "%17_Irlande/%.avi" ;
That said, I just checked now. No rows have been reported at all
(and I do not run these commands since a long time), so the bugs
can have been fixed.
Regards,
Vincent
> Regards,
>
--
Vincent Danjean GPG key ID 0xD17897FA [email protected]
GPG key fingerprint: 621E 3509 654D D77C 43F5 CA4A F6AE F2AF D178 97FA
Unofficial pkgs: http://moais.imag.fr/membres/vincent.danjean/deb.html
APT repo: deb http://people.debian.org/~vdanjean/debian unstable main
_______________________________________________
pkg-kde-extras mailing list
[email protected]
https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-kde-extras
