[Bug 280678] New: Cannot migrate from sqlite to mysql

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

Thomas Bleher <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]-muenc
                   |                            |hen.de

--- Comment #17 from Thomas Bleher <[hidden email]> ---
I got the error message "Error while creating the database schema", because I
had accidentally installed mysql 4.1 instead of mysql 5 on my NAS. It would be
nice to detect this, or at least give more information in the error message.
Proposed error message:

Error while creating the database schema. The following SQL command returned an
error: CREATE TRIGGER privcheck_trigger AFTER DELETE ON PrivCheck FOR EACH ROW
BEGIN END. Possible reasons:
-Your mysql server is too old. Triggers are supported only from mysql version
5.0 onwards.
-Your mysql account does not have the required privileges. On mysql version
5.0, the account needs the SUPER privilege during migrations. On mysql version
5.1 and above, the mysql account needs the CREATE TRIGGER right on the digikam
database.

I think such an error message would greatly ease the search for the cause of
this error.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|MYSQL : cannot migrate from |MySQL : cannot migrate from
                   |sqlite database             |sqlite database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|MySQL : cannot migrate from |MIGRATION : cannot migrate
                   |sqlite database             |from sqlite database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |DUPLICATE
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #18 from Gilles Caulier <[hidden email]> ---


*** This bug has been marked as a duplicate of bug 262321 ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Migration

--
You are receiving this mail because:
You are the assignee for the bug.