Re: Dates missing from my digiKam database
"Randolph M. Fritz" <[email protected]> Fri, 24 Jul 2026 06:50:43 -0700
| Newsgroups | gmane.comp.kde.digikam.user |
|---|---|
| Message-ID | <CANeAMo+92hfGkPn-XOt9iLdBNQm0SOdt=-azx2+v2+qgFMQfsw@mail.gmail.com> |
--00000000000058479d06575ba9e7 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I just tried creating a new database on a small set of images, and I was asked if I wanted to delete digikamrc. No! I don't! I don't want to throw away my existing database of, literally, decades of images. How do I run this test without losing all my data? --=20 Randolph M. Fritz || [email protected] On Thu, Jul 23, 2026 at 12:03=E2=80=AFPM Randolph M. Fritz <rmfritz3@gmail.= com> wrote: > Tried this with 9.2.0; same error, fell back to 9.1.0 again. > > I'm just relieved I didn't have to roll my database all the way back. > -- > Randolph M. Fritz || [email protected] > > > On Mon, Jul 20, 2026 at 9:56=E2=80=AFPM Randolph M. Fritz <rmfritz3@gmail= .com> > wrote: > >> No, I just tried 9.2.0. I fell back to 9.1.0. I have now attempted to >> create a new database on a small collection, and the attempt drew the >> following error: (I have a screenshot, too, but it's too big for the >> mailing list) >> >> An error occurred during the internal server start. >>> Details: >>> Could not start database initializer. >>> Executable: /Applications/digiKam.org/digikam.app/Contents/lib/mariadb/ >>> bin/mariadb-install-db >>> Arguments: --defaults-file=3D/Applications/digiKam.org/digikam.app/ >>> Contents/Resources/digikam/database/mysql-global.conf, --basedir=3D/ >>> Applications/digiKam.org/digikam.app/Contents/lib/mariadb/, --datadir= =3D/ >>> Users/randolph/Documents/dktest/.mysql.digikam/db_data >>> Process error: Unknown error >>> Please check the database settings in this dialog. >> >> >> A bit of poking at the command line suggests a missing symlink in the >> application bundle, but I really don't know for certain. >> -- >> Randolph M. Fritz || [email protected] >> >> >> On Fri, Jul 17, 2026 at 11:27=E2=80=AFPM Gilles Caulier <caulier.gilles@= gmail.com> >> wrote: >> >>> How did you double check that. Did you start a new database from >>> scratch on a small collection to see if the datetime field is >>> populated ? >>> >>> Best regards >>> >>> Gilles Caulier >>> >>> Le sam. 18 juil. 2026 =C3=A0 06:29, Randolph M. Fritz <[email protected]= om> a >>> =C3=A9crit : >>> > >>> > Unfortunately, no, that version does not fix the problem. >>> > -- >>> > Randolph M. Fritz || [email protected] >>> > >>> > >>> > On Thu, Jul 16, 2026 at 9:37=E2=80=AFPM Maik Qualmann <metzpinguin@gm= ail.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=C3=A4ische Sommerzei= t >>> 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 t= he >>> >> > > metadata scan, and it doesn't seem to do anything. Still no date= s >>> 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 || [email protected] >>> >> > > >>> >> > > >>> >> > > On Thu, Jul 16, 2026 at 1:52=E2=80=AFAM Gilles Caulier < >>> [email protected]> >>> >> > > >>> >> > > 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 metada= ta >>> >> > >> 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 proble= m >>> is. >>> >> > >> Look instructions here : >>> >> > >> >>> >> > >> >>> https://www.digikam.org/contribute/#freezes-and-other-run-time-issues >>> >> > >> >>> >> > >> Best regards >>> >> > >> >>> >> > >> Gilles Caulier >>> >> > >> >>> >> > >> Le jeu. 16 juil. 2026 =C3=A0 03:31, Randolph M. Fritz < >>> [email protected]> a >>> >> > >> >>> >> > >> =C3=A9crit : >>> >> > >> > I've got the "Write to item and XMP Sidecar" setting turned >>> on=E2=80=94is that >>> >> > >> >>> >> > >> OK? >>> >> > >> >>> >> > >> > Dates don't seem to be mentioned in the Advanced Metadata >>> panel; do I >>> >> > >> >>> >> > >> need to add them? >>> >> > >> >>> >> > >> > -- >>> >> > >> > Randolph M. Fritz || [email protected] >>> >> > >> > >>> >> > >> > >>> >> > >> > On Wed, Jul 15, 2026 at 11:16=E2=80=AFAM Gilles Caulier < >>> >> > >> >>> >> > >> [email protected]> 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 th= e >>> XMP >>> >> > >> >> sidecar option need to be turned on. >>> >> > >> >> >>> >> > >> >> Best regards >>> >> > >> >> >>> >> > >> >> Gilles Caulier >>> >> > >> >> >>> >> > >> >> Le mer. 15 juil. 2026 =C3=A0 17:46, Randolph M. Fritz < >>> [email protected]> >>> >> > >> >>> >> > >> a =C3=A9crit : >>> >> > >> >> > 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 || [email protected] >>> >> > >> >> > >>> >> > >> >> > On Wed, Jul 15, 2026, 4:51=E2=80=AFAM Gilles Caulier < >>> >> > >> >>> >> > >> [email protected]> 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 strong= ly >>> >> > >> >>> >> > >> 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=A6n= othing >>> 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 d= o >>> that? >>> >> > >> >>> >> > >> >> >> > -- >>> >> > >> >> >> > Randolph M. Fritz || [email protected] >>> >> > >> >> >> > >>> >> > >> >> >> > >>> >> > >> >> >> > On Sun, Jul 12, 2026 at 8:38=E2=80=AFPM Randolph M. Fri= tz < >>> >> > >> >>> >> > >> [email protected]> 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 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 || [email protected] >>> >> >>> >> >>> >> >>> >> >>> >> --00000000000058479d06575ba9e7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div>I just tried creating a new database on a small set o= f images, and I was asked if I wanted to delete digikamrc. No! I don't!= I don't want to throw away my existing database=C2=A0of, literally, de= cades of images.</div><div><br></div><div>How do I run this test without lo= sing all my data?</div><div><div dir=3D"ltr" class=3D"gmail_signature" data= -smartmail=3D"gmail_signature"><div dir=3D"ltr"><div>-- <br>Randolph M. Fri= tz=C2=A0<span>|| </span><a href=3D"mailto:[email protected]" target=3D"_bl= ank">[email protected]</a></div></div></div></div><br></div><br><div class= =3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr= ">On Thu, Jul 23, 2026 at 12:03=E2=80=AFPM Randolph M. Fritz <<a href=3D= "mailto:[email protected]">[email protected]</a>> wrote:<br></div><blo= ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left= :1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Tried t= his with 9.2.0; same error, fell back to 9.1.0 again.</div><div><br></div><= div>I'm just relieved I didn't have to roll my database all the way= back.</div><div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr= "><div>-- <br>Randolph M. Fritz=C2=A0<span>|| </span><a href=3D"mailto:rmfr= [email protected]" target=3D"_blank">[email protected]</a></div></div></div><= /div><br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gma= il_attr">On Mon, Jul 20, 2026 at 9:56=E2=80=AFPM Randolph M. Fritz <<a h= ref=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a>&= gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0= px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div = dir=3D"ltr"><div>No, I just tried 9.2.0. I fell back to 9.1.0. I have now a= ttempted to=20 create a new database on a small collection, and the attempt drew the=20 following error: (I have a screenshot, too, but it's too big for the ma= iling list)<br><br><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p= x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">An err= or occurred during the internal server start.<br>Details:<br>Could not star= t database initializer.<br>Executable: /Applications/digiKam.org/<a href=3D= "http://digikam.app/Contents/lib/mariadb/" target=3D"_blank">digikam.app/Co= ntents/lib/mariadb/</a><br>bin/mariadb-install-db<br>Arguments: --defaults-= file=3D/Applications/digiKam.org/<a href=3D"http://digikam.app/" target=3D"= _blank">digikam.app/</a> Contents/Resources/digikam/database/mysql-global.c= onf, --basedir=3D/ Applications/digiKam.org/<a href=3D"http://digikam.app/C= ontents/lib/mariadb/" target=3D"_blank">digikam.app/Contents/lib/mariadb/</= a>, --datadir=3D/<br>Users/randolph/Documents/dktest/.mysql.digikam/db_data= <br>Process error: Unknown error<br>Please check the database settings in t= his dialog.</blockquote></div><div><br></div><div>A bit of poking at the co= mmand line suggests a missing symlink in the application bundle, but I real= ly don't know for certain.</div><div><div dir=3D"ltr" class=3D"gmail_si= gnature"><div dir=3D"ltr"><div>-- <br>Randolph M. Fritz=C2=A0<span>|| </spa= n><a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]= m</a></div></div></div></div><br></div><br><div class=3D"gmail_quote"><div = dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 17, 2026 at 11:27=E2=80=AFPM G= illes Caulier <<a href=3D"mailto:[email protected]" target=3D"_bl= ank">[email protected]</a>> wrote:<br></div><blockquote class=3D"= gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20= 4,204,204);padding-left:1ex">How did you double check that. Did you start a= new database from<br> scratch on a small collection to see if the datetime field is<br> populated ?<br> <br> Best regards<br> <br> Gilles Caulier<br> <br> Le sam. 18 juil. 2026 =C3=A0 06:29, Randolph M. Fritz <<a href=3D"mailto= :[email protected]" target=3D"_blank">[email protected]</a>> a =C3=A9c= rit :<br> ><br> > Unfortunately, no, that version does not fix the problem.<br> > --<br> > Randolph M. Fritz || <a href=3D"mailto:[email protected]" target=3D"_= blank">[email protected]</a><br> ><br> ><br> > On Thu, Jul 16, 2026 at 9:37=E2=80=AFPM Maik Qualmann <<a href=3D"m= ailto:[email protected]" target=3D"_blank">[email protected]</a>>= ; wrote:<br> >><br> >> The issue with the date view should be fixed in the digiKam-9.2.0 = pre-release;<br> >> please test it here:<br> >><br> >> <a href=3D"https://files.kde.org/digikam/" rel=3D"noreferrer" targ= et=3D"_blank">https://files.kde.org/digikam/</a><br> >><br> >> Maik<br> >><br> >> Am Freitag, 17. Juli 2026, 06:03:22 Mitteleurop=C3=A4ische Sommerz= eit schrieb<br> >> Randolph M. Fritz:<br> >> > I should add at this point that I can see dates in the file p= roperties, so<br> >> > they're in the image metadata.<br> >> ><br> >> > > I tried creating a small collection like you suggested a= nd did the<br> >> > > metadata scan, and it doesn't seem to do anything. S= till no dates in the<br> >> > > display.<br> >> > ><br> >> > > How do I query the internal mysql database? I'm susp= ecting at this point<br> >> > > that the dates are actually in the database, but not bei= ng displayed; can<br> >> > > you send me some commands to run?<br> >> > > --<br> >> > > Randolph M. Fritz || <a href=3D"mailto:[email protected]= m" target=3D"_blank">[email protected]</a><br> >> > ><br> >> > ><br> >> > > On Thu, Jul 16, 2026 at 1:52=E2=80=AFAM Gilles Caulier &= lt;<a href=3D"mailto:[email protected]" target=3D"_blank">caulier.gi= [email protected]</a>><br> >> > ><br> >> > > wrote:<br> >> > >> In fact this depend of multiple parameters.<br> >> > >><br> >> > >> What I don't understand is why the data is not p= opulated in the<br> >> > >> database. If date of shoot cannot be taken from the = file metadata<br> >> > >> there is a fail back to the file system date. So typ= ically the date<br> >> > >> must be populated in all cases in the database.<br> >> > >><br> >> > >> I recommend creating a small collection for testing = and to populate a<br> >> > >> small database with it. You must reproduce the probl= em. If yes,<br> >> > >> capture the debug trace from a terminal to see where= the problem is.<br> >> > >> Look instructions here :<br> >> > >><br> >> > >> <a href=3D"https://www.digikam.org/contribute/#freez= es-and-other-run-time-issues" rel=3D"noreferrer" target=3D"_blank">https://= www.digikam.org/contribute/#freezes-and-other-run-time-issues</a><br> >> > >><br> >> > >> Best regards<br> >> > >><br> >> > >> Gilles Caulier<br> >> > >><br> >> > >> Le jeu. 16 juil. 2026 =C3=A0 03:31, Randolph M. Frit= z <<a href=3D"mailto:[email protected]" target=3D"_blank">rmfritz3@gmai= l.com</a>> a<br> >> > >><br> >> > >> =C3=A9crit :<br> >> > >> > I've got the "Write to item and XMP Si= decar" setting turned on=E2=80=94is that<br> >> > >><br> >> > >> OK?<br> >> > >><br> >> > >> > Dates don't seem to be mentioned in the Adv= anced Metadata panel; do I<br> >> > >><br> >> > >> need to add them?<br> >> > >><br> >> > >> > --<br> >> > >> > Randolph M. Fritz || <a href=3D"mailto:rmfritz3= @gmail.com" target=3D"_blank">[email protected]</a><br> >> > >> ><br> >> > >> ><br> >> > >> > On Wed, Jul 15, 2026 at 11:16=E2=80=AFAM Gilles= Caulier <<br> >> > >><br> >> > >> <a href=3D"mailto:[email protected]" target= =3D"_blank">[email protected]</a>> wrote:<br> >> > >> >> Yes the metadata sync to repopulate the dat= e in the database.<br> >> > >> >><br> >> > >> >> But the most important point is to know whe= re to take the date in<br> >> > >> >> metadata in your case. There is a advanced = metadata panel in digiKam<br> >> > >> >> where you can customize that. Another point= is to know if the XMP<br> >> > >> >> sidecar option need to be turned on.<br> >> > >> >><br> >> > >> >> Best regards<br> >> > >> >><br> >> > >> >> Gilles Caulier<br> >> > >> >><br> >> > >> >> Le mer. 15 juil. 2026 =C3=A0 17:46, Randolp= h M. Fritz <<a href=3D"mailto:[email protected]" target=3D"_blank">rmfr= [email protected]</a>><br> >> > >><br> >> > >> a =C3=A9crit :<br> >> > >> >> > Thanks. I've been using mySQL inte= rnal which, at least on the Mac,<br> >> > >><br> >> > >> is in fact Maria.<br> >> > >><br> >> > >> >> > Which option of the maintenance tool s= hould I use? The metadata<br> >> > >><br> >> > >> synchronizer? Or some other option?<br> >> > >><br> >> > >> >> > --<br> >> > >> >> > Randolph M. Fritz || <a href=3D"mailto= :[email protected]" target=3D"_blank">[email protected]</a><br> >> > >> >> ><br> >> > >> >> > On Wed, Jul 15, 2026, 4:51=E2=80=AFAM = Gilles Caulier <<br> >> > >><br> >> > >> <a href=3D"mailto:[email protected]" target= =3D"_blank">[email protected]</a>> wrote:<br> >> > >> >> >> Migrating the databases without da= tes will not solve the problem.<br> >> > >><br> >> > >> The<br> >> > >><br> >> > >> >> >> items are not re-scanned.<br> >> > >> >> >><br> >> > >> >> >> Try to run the maintenance tool an= d be forced to scan all items.<br> >> > >> >> >><br> >> > >> >> >> Note: MySQL has diverged from Mari= aDB in terms of compatibility,<br> >> > >> >> >> particularly with the latest versi= ons of MySQL. We strongly<br> >> > >><br> >> > >> recommend<br> >> > >><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 <<br> >> > >><br> >> > >> <a href=3D"mailto:[email protected]" target=3D"_bla= nk">[email protected]</a>> a =C3=A9crit :<br> >> > >> >> >> > Since no-one replied, I ran t= he migration and=E2=80=A6nothing happened.<br> >> > >><br> >> > >> It didn't change the database in settings, and t= he dates didn't reappear.<br> >> > >> Do I have to rebuild the database from scratch? How = do I even do that?<br> >> > >><br> >> > >> >> >> > --<br> >> > >> >> >> > Randolph M. Fritz || <a href= =3D"mailto:[email protected]" target=3D"_blank">[email protected]</a><br> >> > >> >> >> ><br> >> > >> >> >> ><br> >> > >> >> >> > On Sun, Jul 12, 2026 at 8:38= =E2=80=AFPM Randolph M. Fritz <<br> >> > >><br> >> > >> <a href=3D"mailto:[email protected]" target=3D"_bla= nk">[email protected]</a>> wrote:<br> >> > >> >> >> >> Or at least, the dates do= n=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<br> >> > >><br> >> > >> this? Or would it be better just to migrate to SQLit= e? (I have 653 GB of<br> >> > >> 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-litt= le_endian-lp64<br> >> > >> >> >> >>> Kernel: darwin 24.6.0= <br> >> > >> >> >> >><br> >> > >> >> >> >> --<br> >> > >> >> >> >> Randolph M. Fritz || <a h= ref=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a><= br> >><br> >><br> >><br> >><br> </blockquote></div> </blockquote></div> </blockquote></div> --00000000000058479d06575ba9e7--