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

[Maik Qualmann]

The parameter --config expects the direct path to a digikamrc file. Replace 
the [Database Settings] in your $HOME/.config/digikamrc with this one and 
replace "/path/to/the/db/" (only the dir).

[Database Settings]
Database Connectoptions=
Database Hostname=
Database Name=/path/to/the/db/
Database Name Face=/path/to/the/db/
Database Name Similarity=/path/to/the/db/
Database Name Thumbnails=/path/to/the/db/
Database Password=
Database Port=-1
Database Type=QSQLITE
Database Username=
Ignored Directories=
Internal Database Server=false
Internal Database Server Mysql Init Command=
Internal Database Server Mysql Server Command=
Internal Database Server Path=

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