Re: Dates missing from my digiKam database
"Randolph M. Fritz" <[email protected]> Wed, 15 Jul 2026 08:45:57 -0700
| Newsgroups | gmane.comp.kde.digikam.user |
|---|---|
| Message-ID | <CANeAMo+dWH1JyS41tqZ8458DtFairWsEYiCm0gx8+kt43wee=A@mail.gmail.com> |
--000000000000b9cb320656a838c9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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? --=20 Randolph M. Fritz || [email protected] On Wed, Jul 15, 2026, 4:51=E2=80=AFAM Gilles Caulier <caulier.gilles@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 =C3=A0 07:20, Randolph M. Fritz <[email protected]= > a > =C3=A9crit : > > > > Since no-one replied, I ran the migration and=E2=80=A6nothing 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 || [email protected] > > > > > > On Sun, Jul 12, 2026 at 8:38=E2=80=AFPM Randolph M. Fritz <rmfritz3@gma= il.com> > wrote: > >> > >> Or at least, the dates don=E2=80=99t show up in the =E2=80=9CDates=E2= =80=9D view. > >> > >> It=E2=80=99s an internal mySQL database. Is there any easy way to repa= ir 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 || [email protected] > --000000000000b9cb320656a838c9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"auto"><div dir=3D"auto"><div dir=3D"auto"><div>Thanks. I've= been using mySQL internal which, at least on the Mac, is in fact Maria.</d= iv><div dir=3D"auto"><br></div><div dir=3D"auto">Which option of the mainte= nance tool should I use? The metadata synchronizer? Or some other option?</= div><div><br></div><div data-smartmail=3D"gmail_signature"><div dir=3D"ltr"= ><div>-- <br>Randolph M. Fritz=C2=A0<span>|| </span><a href=3D"mailto:rmfri= [email protected]" rel=3D"noreferrer noreferrer" target=3D"_blank">rmfritz3@gma= il.com</a></div></div></div></div><br><div class=3D"gmail_quote"><div dir= =3D"ltr" class=3D"gmail_attr">On Wed, Jul 15, 2026, 4:51=E2=80=AFAM Gilles = Caulier <<a href=3D"mailto:[email protected]" rel=3D"noreferrer n= oreferrer" target=3D"_blank">[email protected]</a>> wrote:<br></d= iv><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left= :1px #ccc solid;padding-left:1ex">Migrating the databases without dates wil= l not solve the problem. The<br> items are not re-scanned.<br> <br> Try to run the maintenance tool and be forced to scan all items.<br> <br> Note: MySQL has diverged from MariaDB in terms of compatibility,<br> particularly with the latest versions of MySQL. We strongly recommend<br> using MariaDB instead of MySQL.<br> <br> Best regards<br> <br> Gilles Caulier<br> <br> Le mer. 15 juil. 2026 =C3=A0 07:20, Randolph M. Fritz <<a href=3D"mailto= :[email protected]" rel=3D"noreferrer noreferrer noreferrer" target=3D"_bl= ank">[email protected]</a>> a =C3=A9crit :<br> ><br> > Since no-one replied, I ran the migration and=E2=80=A6nothing happened= . It didn't change the database in settings, and the dates didn't r= eappear. Do I have to rebuild the database from scratch? How do I even do t= hat?<br> > --<br> > Randolph M. Fritz || <a href=3D"mailto:[email protected]" rel=3D"nore= ferrer noreferrer noreferrer" target=3D"_blank">[email protected]</a><br> ><br> ><br> > On Sun, Jul 12, 2026 at 8:38=E2=80=AFPM Randolph M. Fritz <<a href= =3D"mailto:[email protected]" rel=3D"noreferrer noreferrer noreferrer" tar= get=3D"_blank">[email protected]</a>> wrote:<br> >><br> >> Or at least, the dates don=E2=80=99t show up in the =E2=80=9CDates= =E2=80=9D view.<br> >><br> >> It=E2=80=99s 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 G= B of image files.)<br> >>><br> >>> digiKam: 9.1.0<br> >>> KDE Frameworks: 6.26.0<br> >>> Qt: Using 6.11.0 and built against 6.11.0<br> >>> macOS Sequoia (15.7.7)<br> >>> Build ABI: arm64-little_endian-lp64<br> >>> Kernel: darwin 24.6.0<br> >><br> >> --<br> >> Randolph M. Fritz || <a href=3D"mailto:[email protected]" rel=3D"= noreferrer noreferrer noreferrer" target=3D"_blank">[email protected]</a><= br> </blockquote></div> <br><br></div> <br><br></div> --000000000000b9cb320656a838c9--