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