Dates missing from my digiKam database

[Randolph M. Fritz]

Unfortunately, no, that version does not fix the problem.
-- 
Randolph M. Fritz || rmfritz3 at gmail.com


On Thu, Jul 16, 2026 at 9:37 PM Maik Qualmann <metzpinguin at gmail.com> wrote:

> The issue with the date view should be fixed in the digiKam-9.2.0
> pre-release;
> please test it here:
>
> https://files.kde.org/digikam/
>
> Maik
>
> Am Freitag, 17. Juli 2026, 06:03:22 Mitteleuropäische Sommerzeit schrieb
> Randolph M. Fritz:
> > I should add at this point that I can see dates in the file properties,
> so
> > they're in the image metadata.
> >
> > > I tried creating a small collection like you suggested and did the
> > > metadata scan, and it doesn't seem to do anything. Still no dates in
> the
> > > display.
> > >
> > > How do I query the internal mysql database? I'm suspecting at this
> point
> > > that the dates are actually in the database, but not being displayed;
> can
> > > you send me some commands to run?
> > > --
> > > Randolph M. Fritz || rmfritz3 at gmail.com
> > >
> > >
> > > On Thu, Jul 16, 2026 at 1:52 AM Gilles Caulier <
> caulier.gilles at gmail.com>
> > >
> > > wrote:
> > >> In fact this depend of multiple parameters.
> > >>
> > >> What I don't understand is why the data is not populated in the
> > >> database. If date of shoot cannot be taken from the file metadata
> > >> there is a fail back to the file system date. So typically the date
> > >> must be populated in all cases in the database.
> > >>
> > >> I recommend creating a small collection for testing and to populate a
> > >> small database with it. You must reproduce the problem. If yes,
> > >> capture the debug trace from a terminal to see where the problem is.
> > >> Look instructions here :
> > >>
> > >> https://www.digikam.org/contribute/#freezes-and-other-run-time-issues
> > >>
> > >> Best regards
> > >>
> > >> Gilles Caulier
> > >>
> > >> Le jeu. 16 juil. 2026 à 03:31, Randolph M. Fritz <rmfritz3 at gmail.com>
> a
> > >>
> > >> écrit :
> > >> > I've got the "Write to item and XMP Sidecar" setting turned on—is
> that
> > >>
> > >> OK?
> > >>
> > >> > Dates don't seem to be mentioned in the Advanced Metadata panel; do
> I
> > >>
> > >> need to add them?
> > >>
> > >> > --
> > >> > Randolph M. Fritz || rmfritz3 at gmail.com
> > >> >
> > >> >
> > >> > On Wed, Jul 15, 2026 at 11:16 AM Gilles Caulier <
> > >>
> > >> caulier.gilles at gmail.com> wrote:
> > >> >> Yes the metadata sync to repopulate the date in the database.
> > >> >>
> > >> >> But the most important point is to know where to take the date in
> > >> >> metadata in your case. There is a advanced metadata panel in
> digiKam
> > >> >> where you can customize that. Another point is to know if the XMP
> > >> >> sidecar option need to be turned on.
> > >> >>
> > >> >> Best regards
> > >> >>
> > >> >> Gilles Caulier
> > >> >>
> > >> >> Le mer. 15 juil. 2026 à 17:46, Randolph M. Fritz <
> rmfritz3 at gmail.com>
> > >>
> > >> a écrit :
> > >> >> > Thanks. I've been using mySQL internal which, at least on the
> Mac,
> > >>
> > >> is in fact Maria.
> > >>
> > >> >> > Which option of the maintenance tool should I use? The metadata
> > >>
> > >> synchronizer? Or some other option?
> > >>
> > >> >> > --
> > >> >> > Randolph M. Fritz || rmfritz3 at gmail.com
> > >> >> >
> > >> >> > On Wed, Jul 15, 2026, 4:51 AM Gilles Caulier <
> > >>
> > >> caulier.gilles at gmail.com> wrote:
> > >> >> >> Migrating the databases without dates will not solve the
> problem.
> > >>
> > >> The
> > >>
> > >> >> >> items are not re-scanned.
> > >> >> >>
> > >> >> >> Try to run the maintenance tool and be forced to scan all items.
> > >> >> >>
> > >> >> >> Note: MySQL has diverged from MariaDB in terms of compatibility,
> > >> >> >> particularly with the latest versions of MySQL. We strongly
> > >>
> > >> recommend
> > >>
> > >> >> >> using MariaDB instead of MySQL.
> > >> >> >>
> > >> >> >> Best regards
> > >> >> >>
> > >> >> >> Gilles Caulier
> > >> >> >>
> > >> >> >> Le mer. 15 juil. 2026 à 07:20, Randolph M. Fritz <
> > >>
> > >> rmfritz3 at gmail.com> a écrit :
> > >> >> >> > Since no-one replied, I ran the migration and…nothing
> happened.
> > >>
> > >> It didn't change the database in settings, and the dates didn't
> reappear.
> > >> Do I have to rebuild the database from scratch? How do I even do that?
> > >>
> > >> >> >> > --
> > >> >> >> > Randolph M. Fritz || rmfritz3 at gmail.com
> > >> >> >> >
> > >> >> >> >
> > >> >> >> > On Sun, Jul 12, 2026 at 8:38 PM Randolph M. Fritz <
> > >>
> > >> rmfritz3 at gmail.com> wrote:
> > >> >> >> >> 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
> > >> >> >> >>
> > >> >> >> >> --
> > >> >> >> >> Randolph M. Fritz || rmfritz3 at gmail.com
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260717/bf4fcf2f/attachment.htm>