https://bugs.kde.org/show_bug.cgi?id=486755
Bug ID: 486755 Summary: images.album = NULL without reason (disappearing images in DK) Classification: Applications Product: digikam Version: 8.3.0 Platform: openSUSE OS: Linux Status: REPORTED Severity: critical Priority: NOR Component: Database-Mysql Assignee: digikam-bugs-n...@kde.org Reporter: k...@forum.titlis.org Target Milestone: --- SUMMARY I'm using mariadb SQL with over 100k images. It seems like Digikam looses images and albums over time, the images however are still present in the file system What I've figured out so far: - The column "album" of the table "Images" contains sometimes NULL. These images are not visible anymore in DK (since they don't belong to an album anymore), however the image still exists on the file system - Over time, the amount of images with album=NULL increases. In 2021, none of my images had album=NULL, now in 2024, I count ~1800 rows with images.album=NULL STEPS TO REPRODUCE Unfortunately, I don't know what triggered this issue. However, I have a setup where I commit an sql dump to git before each launch of DK, so I am (in theory) helpful to nail down the issue. I just don't know where to start. Happy to provide my db to devs EXPECTED RESULTS - Don't nullify images.album in SQL without a reason - Have a sanity check in DK to notify user if there is an inconsistency with regards to images.album SOFTWARE/OS VERSIONS Linux/KDE Plasma: recent OpenSuse and DK versions since 2021 -- You are receiving this mail because: You are watching all bug changes.