Dates missing from my digiKam database

Software digiKam
1

Or at least, the dates don’t show up in the “Dates” view.

It’s an internal mySQL database. Is there any easy way to repair this? Or would it be better just to migrate to SQLite? (I have 653 GB of image files.)

digiKam: 9.1.0
KDE Frameworks: 6.26.0
Qt: Using 6.11.0 and built against 6.11.0
macOS Sequoia (15.7.7)
Build ABI: arm64-little_endian-lp64
Kernel: darwin 24.6.0

2

Ran the migration and…nothing happened. It didn’t even change the database setting, so I’ve no idea even where the database is.

WtF?

3

Erm, if the dates are missing from the initial database, why would they magically appear after the migration?

As for database locations:

  • for internal MySQL, the location is given in the same dialog where you configure the mySQL database
  • for the SQlite database, the files are stored in the root direction of your image collection.

But if nothing happened, there’s nothing we can do here based on the information you provide.

4

It turns out that on macOS (and probably Linux) the internal mySQL database is stored a hidden directory, “.mysql”, under the named directory. I couldn’t see it with “ls” and wondered why.

Over on the Digikam mailing list I’ve gotten the suggestion to use “sync metadata” under the “maintenance” panel; I’m waiting for a few more details and I’ll try that next.

Randolph

5

This, it turns out, is a problem due to a compatibility issue with MariaDB. It is written up here. It is not clear if the MariaDB developers will be resolving the issue, or if the various apps that depend on it will have to make changes.