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

[Maik Qualmann]

I have read that you are using an external SQL Server. This is not a good idea 
for the database of thumbnails, unless you have a very, very fast internet 
connection.

Maik

Am Montag, 10. September 2018, 23:27:50 CEST schrieben Sie:
> 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