https://bugs.kde.org/show_bug.cgi?id=388824
Bug ID: 388824
Summary: UpdateSchemaFromV7ToV9 fails due to foreign key
contraint in 5.8.0-01
Product: digikam
Version: 5.8.0
Platform: Appimage
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Schema
Assignee: digikam-bugs-n...@kde.org
Reporter: jyrki.so...@iki.fi
Target Milestone: ---
> digikam-5.8.0-01-x86-64.appimage
-- digiKam AppImage Bundle
-- Use 'help' as CLI argument to know all available options
digikam.widgets: Breeze icons ressource file found
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
Connect Options: "UNIX_SOCKET=/run/mysql/mysql.sock"
Host Name: "localhost"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "digikam"
Password: "XXXXXXXXXXXXXXXXXXXX"
digikam.dbengine: Loading SQL code from config file
"/tmp/.mount_digika5P5naf/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 add or update a child
row: a foreign key constraint fails (`digikam`.`#sql-875_d`, CONSTRAINT
`Images_Albums` FOREIGN KEY (`album`) REFERENCES `Albums` (`id`) ON DELETE
CASCADE ON UPDATE CASCADE)" 1452 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ]
Statement [ "ALTER IGNORE TABLE Images\n
ADD CONSTRAINT Images_Albums FOREIGN KEY (album) REFERENCES Albums (id) ON
DELETE CASCADE ON UPDATE CASCADE,\n ADD
UNIQUE (album, name(255)),\n ENGINE
InnoDB;" ]
digikam.coredb: Core database: schema update to V 9 failed!
digikam.coredb: Core database: cannot process schema initialization
KMemoryInfo: Platform identified : "LINUX"
KMemoryInfo: TotalRam: 16762318848
digikam.general: Allowing a cache size of 200 MB
QThreadStorage: Thread 0x7fa94574dc80 exited after QThreadStorage 11 destroyed
--
You are receiving this mail because:
You are watching all bug changes.
