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

[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

[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

[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

[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