https://bugs.kde.org/show_bug.cgi?id=378838
Bug ID: 378838
Summary: Initializing MySQL/MariaDB database or migrating from
SQLite cancels with DB errors
Product: digikam
Version: 5.2.0
Platform: openSUSE RPMs
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Migration
Assignee: digikam-de...@kde.org
Reporter: jeri...@googlemail.com
Target Milestone: ---
Created attachment 105044
--> https://bugs.kde.org/attachment.cgi?id=105044&action=edit
SQL export of initialized Maria DB database up to the errors
Emptied MariaDB (10.0.28-MariaDB) database "digikam" (used with earlier version
of digikam) fully accessible by user "digikam" after scheme migration from v7
to v8 failed several times.
Even when trying to use this empty DB the following errors occur:
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.Albums'
doesn't exist" 1146 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "Migrate_Cleanup_Prepare" ]
Statement [ "\n ALTER TABLE Albums DROP FOREIGN KEY
Albums_Images;\n " ]
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: no database file available
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Unable to execute query" "Cannot load from mysql.proc.
The table is probably corrupted" 1728 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "CreateIndices" ] Statement
[ "\n DROP PROCEDURE IF EXISTS create_index_if_not_exists;\n
" ]
20 tables and one view are created (including "Albums" mentioned above as being
missing). See attachment for the content of the initialized database up to the
failure.
Tried to workaround by first creating a local SQLite DB and migrate it to the
DB server (with a re-emptied DB) => same errors.
--
You are receiving this mail because:
You are watching all bug changes.
