| Summary: | Error on new install Failed to update the database schema from version 9 to version 10 | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | tami mize <tglatz> |
| Component: | Database-Schema | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | caulier.gilles, dave.j.irwin, metzpinguin |
| Priority: | NOR | ||
| Version First Reported In: | 6.4.0 | ||
| Target Milestone: | --- | ||
| Platform: | Microsoft Windows | ||
| OS: | Microsoft Windows | ||
| Latest Commit: | Version Fixed/Implemented In: | 7.0.0 | |
| Sentry Crash Report: | |||
| Attachments: |
attachment-12583-0.html
dbconfig.zip debug file when trying to open DigiKam (windows 10) |
||
|
Description
tami mize
2020-05-04 03:12:00 UTC
Start digiKam in the console and post the messages that are output. Maik Created attachment 128124 [details] attachment-12583-0.html I dont understand what "start in the console" means. When I try to run the program, it gives me the error and will not open the Digikam program at all. tami On 5/4/2020 12:30:07 AM, Maik Qualmann <bugzilla_noreply@kde.org> wrote: https://bugs.kde.org/show_bug.cgi?id=420978 Maik Qualmann changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |metzpinguin@gmail.com --- Comment #1 from Maik Qualmann --- Start digiKam in the console and post the messages that are output. Maik -- You are receiving this mail because: You reported the bug. Open a Linux terminal ( a text console) and start digiKam from the command line interface: https://www.howtogeek.com/140679/beginner-geek-how-to-start-using-the-linux-terminal/ If I read through your description with "Install" and ends normally, I assume you are on Windows and not on Linux. On Windows, download and start DebugView from Microsoft. Start digiKam and post the messages from DebugView. Maik Not sure if I'm allowed to append to this issue but I have exactly the same symptoms since since loading v 6.4 today to Windows 10. So, on the assumption that the fault is the same I've started the program under Debugview. There is no crash log in the location mentioned. Please advise if you want me to open a seperate issue. Error log appended here: [9564] digikam.general: Loading DrMinGw run-time... [9564] digikam.general: DrMinGw run-time loaded. [9564] digikam.general: DrMinGw crash-file will be located at: "C:\\Users\\davej\\AppData\\Local\\digikam_crash.log" [9564] digikam.widgets: Breeze icons resource file found [9564] digikam.widgets: Breeze-dark icons resource file found [9564] digikam.general: Switch to widget style: "Windows" [9564] digikam.general: AlbumWatch is disabled [9564] digikam.general: Database Parameters: [9564] Type: "QSQLITE" [9564] DB Core Name: "C:/Users/davej/Pictures/digikam4.db" [9564] DB Thumbs Name: "C:/Users/davej/Pictures/thumbnails-digikam.db" [9564] DB Face Name: "C:/Users/davej/Pictures/recognition.db" [9564] DB Similarity Name: "C:/Users/davej/Pictures/similarity.db" [9564] Connect Options: "" [9564] Host Name: "" [9564] Host port: -1 [9564] Internal Server: false [9564] Internal Server Path: "" [9564] Internal Server Serv Cmd: "" [9564] Internal Server Init Cmd: "" [9564] Username: "" [9564] Password: "" [9564] [9564] digikam.dbengine: Loading SQL code from config file "C:/Program Files/digiKam/data/digikam/database/dbconfig.xml" [9564] digikam.dbengine: Checking XML version ID => expected: 3 found: 3 [9564] digikam.coredb: Core database: running schema update [9564] digikam.coredb: Core database: have a structure version 9 [9564] digikam.coredb: Core database: makeUpdates 9 to 10 [9564] digikam.dbengine: Failure executing query: [9564] "" [9564] Error messages: "Unable to execute statement" "duplicate column name: manualOrder" "1" 2 [9564] Bound values: () [9564] digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV9ToV10" ] Statement [ "ALTER TABLE Images ADD manualOrder INTEGER;" ] [9564] digikam.coredb: Core database: schema update to V 10 failed! [9564] digikam.coredb: Core database: cannot process schema initialization [9564] KMemoryInfo: Platform identified : "WINDOWS" [9564] KMemoryInfo: TotalRam: 8534626304 [9564] digikam.general: Allowing a cache size of 200 MB [9564] QThreadStorage: Thread 0x26ba7d1bfb0 exited after QThreadStorage 7 destroyed [9564] QWaitCondition: Destroyed while threads are still waiting [30864] 19360 0000000000000000 ENTER: DllCanUnloadNow [30864] 35576 0000000000000000 ENTER: DllCanUnloadNow [30864] 4028 0000000000000000 ENTER: DllCanUnloadNow [30864] 29340 0000000000000000 ENTER: DllCanUnloadNow [30864] 26384 0000000000000000 ENTER: DllCanUnloadNow [30864] 35576 0000000000000000 ENTER: DllCanUnloadNow Created attachment 128142 [details]
dbconfig.zip
The reason is clear, you started with a beta version with digiKam and the database. Now the update fails. Unzip the attached file and replace the existing dbconfig.xml with this file:
In Windows mostly here:
C:\Program Files\digiKam\data\digikam\database
On Linux mostly here:
/usr/share/digikam/database/
Maik
Perfect solution Maik, now works perfectly. Hope this fixes Tami's issue as well. Many thanks for the speedy response. Dave Created attachment 128150 [details]
debug file when trying to open DigiKam (windows 10)
thanks for your help.
|