[Digikam-devel] [Bug 280678] MYSQL : cannot migrate from sqlite database

[Thomas Bleher]

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

Thomas Bleher <bleher at informatik.uni-muenchen.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bleher at informatik.uni-muenc
                   |                            |hen.de

--- Comment #17 from Thomas Bleher <bleher at informatik.uni-muenchen.de> ---
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.