[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[Maik Qualmann]

https://bugs.kde.org/show_bug.cgi?id=286492

Maik Qualmann  changed:

   What|Removed |Added

 CC||metzping...@gmail.com
  Latest Commit||https://commits.kde.org/dig
   ||ikam/9a17c743ea9a41c1ef050b
   ||08517343813ef6a9f4
 Status|UNCONFIRMED |RESOLVED
   Version Fixed In||5.8.0
 Resolution|--- |FIXED

--- Comment #8 from Maik Qualmann  ---
Git commit 9a17c743ea9a41c1ef050b08517343813ef6a9f4 by Maik Qualmann.
Committed on 25/11/2017 at 22:02.
Pushed by mqualmann into branch 'master'.

update DB to v9 and fix migration from SQLite to MySQL
Related: bug 378838, bug 369083, bug 350574
FIXED-IN: 5.8.0

M  +5-1NEWS
M  +129  -97   data/database/dbconfig.xml.cmake.in
M  +1-1data/database/mysql-global.conf
M  +1-20   libs/database/coredb/coredbcopymanager.cpp
M  +5-2libs/database/coredb/coredbschemaupdater.cpp

https://commits.kde.org/digikam/9a17c743ea9a41c1ef050b08517343813ef6a9f4

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=286492

--- Comment #7 from caulier.gil...@gmail.com ---
Swati,

What about this file ? It still valid ? If yes, the schema must be patched to
fix this problem.

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[Mattia via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=286492

--- Comment #6 from Mattia  ---
(In reply to caulier.gilles from comment #5)
> To setup a Mariadb/Mysql database on a remote server, you must follow the
> requirements listed in DK/Setup/Database tab. It's very important.
> 
> Following this rules, i can setup a DB in a Linux host computer and use it
> in digiKam client from Linux, OSX, or Windows.
> 
> The migration is another subject, but it depend of a correct remote DB init.
> 
> Gilles Caulier

I tried with another server running MariaDB 10.1.14 and it's working. I think
MariaDB 5.5.44 running on my Qnap NAS it's just too old...

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=286492

--- Comment #5 from caulier.gil...@gmail.com ---
To setup a Mariadb/Mysql database on a remote server, you must follow the
requirements listed in DK/Setup/Database tab. It's very important.

Following this rules, i can setup a DB in a Linux host computer and use it in
digiKam client from Linux, OSX, or Windows.

The migration is another subject, but it depend of a correct remote DB init.

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[Mattia via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=286492

Mattia  changed:

   What|Removed |Added

 CC||mattia.ve...@tiscali.it

--- Comment #4 from Mattia  ---
I don't know if I hit the same problem, but I get an error trying to migrate
SQLite to an external MySQL database (no details are showed). So, yes, I think
this file is still valid.

Additionally, I can't even set up a new empty database, I think for the same
problem. Creation and migration both errors out in the middle of the task.

Using Digikam 5.0.0 and MariaDB 5.5.44

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=286492

caulier.gil...@gmail.com changed:

   What|Removed |Added

   Severity|minor   |normal

-- 
You are receiving this mail because:
You are watching all bug changes.

[digikam] [Bug 286492] MIGRATION : two SQLITE triggers applied for the same table is not supported by MySQL database

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=286492

caulier.gil...@gmail.com changed:

   What|Removed |Added

 CC||swatilodh...@gmail.com

--- Comment #3 from caulier.gil...@gmail.com ---
Swati,

What about this file ? It still valid ? If yes, the schema must be patched to
fix this problem.

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.