UpdateSchemaFromV7ToV8 fails on rename

[Andy Kirch]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170105/0a04fd48/attachment.html>