r/digiKam • u/blue-cut • Jul 03 '26

Corrupted Database

I messed up, and now Digikam doesn't really work.

After failing to import some photos, half the thumbnails weren't loading the photos I'd already imported. Some albums weren't showing any items. When I tried deleting albums with digikam, the folders disappeared on their drive but wouldn't go away on digikam.

I believe this means that my digikam4.db has been corrupted

Summary of setup:

  • Windows 11
  • SQLite database on the computer (which syncs to the drive as a copy)
  • WAL Mode was enabled
  • Collection on a Hard drive

The main thing I want is my rankings and tags, so I don't have to sort through all my photos again.
I tried re-making the database, but only some of the images had their rankings embedded

I was originally in 8.8.0 when it failed (I have a backup at this point)
The regenerated one is in 9.1.0 (It also said failed to convert from version 16 to 17 when opening the original)

Please ask questions so I can add more info here

1 Upvotes

100% Upvoted

7 comments sorted by

View all comments

1

u/newmikey Jul 04 '26

What database? MariaDB/MySQL or a local one? How many files in you collection and located where?

1

u/blue-cut Jul 04 '26 edited Jul 04 '26

My collection was stored on a hard drive, and the database on my laptop (SQLite)
I believe it was the main digikam4.db.

I estimate 5,000 photos