Has anyone encountered this error when upgrading from DK4.14 (I think) to DK5.3? Based on some google searches for errno: 152, mysql is complaining about a foreign key constraint. Does anyone have some advice for tackling this issue? Thanks for any help!
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikamdb"
DB Thumbs Name: "digikamthumbdb"
DB Face Name: "digikamfacedb"
Connect Options: ""
Host Name: "basementserver"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "digikamuser"
Password: "XXXXXXXXX"
digikam.dbengine: Loading SQL code from config file "/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 7
digikam.coredb: Core database: makeUpdates 7 to 8
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Unable to execute query" "Error on rename of './digikamdb/Albums' to './digikamdb/#sql2-8d9-44e0' (errno: 152)" 1025 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ] Statement [ "ALTER TABLE Albums\n DROP
FOREIGN KEY Albums_Images;" ]
digikam.coredb: Core database: schema update to V 8 failed!
digikam.coredb: Core database: cannot process schema initialization
- Andy
Locked
