[digiKam-users] MySQL Issues with dk6, beta 1 DATETIME(3) problem
metzpinguin at gmail.com
Tue Sep 11 07:00:13 BST 2018
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 Name Face=/path/to/the/db/
Database Name Similarity=/path/to/the/db/
Database Name Thumbnails=/path/to/the/db/
Internal Database Server=false
Internal Database Server Mysql Init Command=
Internal Database Server Mysql Server Command=
Internal Database Server Path=
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.
> 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