https://bugs.kde.org/show_bug.cgi?id=387364
Bug ID: 387364
Summary: makeUpdates 8 to 9 Failure executing query
Product: digikam
Version: 5.8.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: kikouca...@gmail.com
Target Milestone: ---
Schema update to v9 failled
Version du serveur : 10.2.10-MariaDB-10.2.10
./digikam-5.8.0-20171126T055526-x86-64.appimage
...
digikam.dbengine: Loading SQL code from config file
"/tmp/.mount_yEHrA3/usr/share/digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected: 3 found: 3
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: have a structure version 8
digikam.coredb: Core database: makeUpdates 8 to 9
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Unable to execute query" "Cannot delete rows from
table which is parent in a foreign key constraint 'ImageTagProperties_Tags' of
table 'ImageTagProperties'" 1834 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV8ToV9" ]
Statement [ "ALTER TABLE Tags MODIFY COLUMN name LONGTEXT CHARACTER SET utf8
COLLATE utf8_general_ci NOT NULL;" ]
digikam.coredb: Core database: schema update to V 9 failed!
digikam.coredb: Core database: cannot process schema initialization
--
You are receiving this mail because:
You are watching all bug changes.
