[digiKam-users] MySQL Issues with dk6, beta 1 DATETIME(3) problem

Maik Qualmann metzpinguin at gmail.com
Mon Sep 10 22:27:50 BST 2018

Which version do you use? MySQL or MariaDB? The support for fractional seconds 
is available at MySQL e.g. only from version 5.6. The creation of tables with 
fractional seconds is only created for a new DB, not for an update to remain 
compatible. Since SQLite also stores fractional seconds, I do not think we'll 
change that. You have to update your SQL server.


Am Montag, 10. September 2018, 22:16:43 CEST schrieb Tac Tacelosky:
> I created a free MySQL database on https://www.freemysqlhosting.net/ to
> test DigiKam with the external MySQL database.  Creating the database
> fails, the issue is with
>  modificationDate DATETIME(3)
> when creating the Images table.  It works without the (3).
> On a related note, my installation is "stuck" now.  The database
> information is stored, when I try to start the application, it failed when
> trying to create the database and aborts.  I'd like to switch it back to
> SQLIte until I can figure out a solution.  But the app dies before I can
> get the opportunity to change it.
> I see there's a --config option, but I can't find any documentation on it.
> I'm restarting it by pointing to a sqlite directory, but it's a bit
> awkward.  Where is the --config option documented?
> Thanks
> Tac

More information about the Digikam-users mailing list