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 vdanj...@debian.org 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 pkg-kde-extras@alioth-lists.debian.net https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-kde-extras