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

[Maik Qualmann]

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.

Maik

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