[Pkg-kde-extras] Bug#842610: digikam lost track of photos when renaming an album

[Vincent Danjean]

  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         vdanjean at 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