https://bugs.kde.org/show_bug.cgi?id=388867
--- Comment #12 from dajomu <dajo...@gmail.com> ---
(In reply to dajomu from comment #11)
> This bug is not fixed in digikam 5.9. "Failed to update the database schema
> from version 8 to version 9." Also running MariaDB 10.2.13
This is the output from DebugView;
[1788] digikam.widgets: Breeze icons ressource file found
[1788] digikam.general: AlbumWatch use QFileSystemWatcher
[1788] Failed to query
"\\\\?\\acpi#pnp0c0a#1#{72631e54-78a4-11d0-bcf7-00aa00b7b32a}" reason: "The
system cannot find the file specified. 2"
[1788] digikam.general: Database Parameters:
[1788] Type: "QMYSQL"
[1788] DB Core Name: "digikam"
[1788] DB Thumbs Name: "digikam"
[1788] DB Face Name: "digikam"
[1788] Connect Options: ""
[1788] Host Name: "localhost"
[1788] Host port: 3307
[1788] Internal Server: true
[1788] Internal Server Path: "C:/Users/beda/Pictures/Digikam"
[1788] Internal Server Serv Cmd: "C:/Program Files/MariaDB
10.2/bin/mysqld.exe"
[1788] Internal Server Init Cmd: "C:/Program Files/MariaDB
10.2/bin/mysql_install_db.exe"
[1788] Username: "root"
[1788] Password: ""
[1788]
[1788] digikam.databaseserver: Database Parameters:
[1788] Type: "QMYSQL"
[1788] DB Core Name: "digikam"
[1788] DB Thumbs Name: "digikam"
[1788] DB Face Name: "digikam"
[1788] Connect Options: ""
[1788] Host Name: "localhost"
[1788] Host port: 3307
[1788] Internal Server: true
[1788] Internal Server Path: "C:/Users/beda/Pictures/Digikam"
[1788] Internal Server Serv Cmd: "C:/Program Files/MariaDB
10.2/bin/mysqld.exe"
[1788] Internal Server Init Cmd: "C:/Program Files/MariaDB
10.2/bin/mysql_install_db.exe"
[1788] Username: "root"
[1788] Password: ""
[1788]
[1788] digikam.databaseserver: Internal Server data path:
"C:/Users/beda/Pictures/Digikam/.mysql.digikam/db_data"
[1788] digikam.databaseserver: The mysql configuration was already up-to-date:
"C:/Users/beda/AppData/Local/digikam/mysql.conf"
[7396] Suspending
[1788] digikam.databaseserver: Database server: "C:/Program Files/MariaDB
10.2/bin/mysqld.exe"
("--defaults-file=C:\\Users\\beda\\AppData\\Local\\digikam\\mysql.conf",
"--datadir=C:\\Users\\beda\\Pictures\\Digikam\\.mysql.digikam\\db_data",
"--skip-networking=0", "--port=3307")
[1788] digikam.databaseserver: Internal database server started
[1788] digikam.databaseserver: Running 0 seconds...
[1788] digikam.dbengine: Loading SQL code from config file "C:/Program
Files/digiKam/data/digikam/database/dbconfig.xml"
[1788] digikam.dbengine: Checking XML version ID => expected: 3 found: 3
[1788] digikam.coredb: Core database: running schema update
[1788] digikam.coredb: Core database: have a structure version 8
[1788] digikam.coredb: Core database: makeUpdates 8 to 9
[1788] digikam.dbengine: Failure executing query:
[1788] ""
[1788] Error messages: "QMYSQL: Unable to execute query" "Cannot delete rows
from table which is parent in a foreign key constraint 'Images_Albums' of table
'images'" 1834 2
[1788] Bound values: ()
[1788] digikam.dbengine: Error while executing DBAction [
"UpdateSchemaFromV7ToV9" ] Statement [ "ALTER TABLE Albums MODIFY COLUMN
relativePath LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;" ]
[1788] digikam.coredb: Core database: schema update to V 9 failed!
[1788] digikam.coredb: Core database: cannot process schema initialization
[1788] KMemoryInfo: Platform identified : "WINDOWS"
[1788] KMemoryInfo: TotalRam: 8465080320
[1788] digikam.general: Allowing a cache size of 200 MB
[1788] QThreadStorage: Thread 0x23ebb750 exited after QThreadStorage 7
destroyed
[1788] QWaitCondition: Destroyed while threads are still waiting
[1788] QThread: Destroyed while thread is still running
[6900] [kpdf2wordshellext]DllCanUnloadNow,
module=C:\Users\beda\AppData\Local\Kingsoft\WPS
Office\10.2.0.5996\office6\addons\kpdf2wordshellext\kpdf2wordshellext64.dll
[6900] [kpdf2wordshellext]DllCanUnloadNow,
module=C:\Users\beda\AppData\Local\Kingsoft\WPS
Office\10.2.0.5996\office6\addons\kpdf2wordshellext\kpdf2wordshellext64.dll
[6900] [kpdf2wordshellext]DllCanUnloadNow,
module=C:\Users\beda\AppData\Local\Kingsoft\WPS
Office\10.2.0.5996\office6\addons\kpdf2wordshellext\kpdf2wordshellext64.dll
--
You are receiving this mail because:
You are watching all bug changes.
