Bug 405799

Summary: Not possible to add collection
Product: [Applications] digikam Reporter: buz.scud
Component: Database-SqliteAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED NOT A BUG    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version First Reported In: 5.7.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed/Implemented In: 6.1.0
Sentry Crash Report:
Attachments: Unable to add collection
Debug view report

Description buz.scud 2019-03-24 06:14:14 UTC
Hi, 

I'm having trouble with this error for the past two moths. I'm using Windows 10 64x system, and still newbie at this programming things. Started to have this kind of error from the first time installing to my laptop. Starting with Digikam 5.7.0 then, been uninstalling and installing after that and the same error occurred. Database used at that time was SQLite. I'd appreciate it if the team can help me solving the error. Tq.
Comment 1 caulier.gilles 2019-03-24 06:58:35 UTC
where is stored the collection ? Local or remote ?

Gilles Caulier
Comment 2 buz.scud 2019-03-24 08:21:12 UTC
Local. Oh another thing I noticed, right after installing Digikam 5.7.0, command window popped up, ran something (could not catch up the command) and it said "Application menu () was not found".
Comment 3 caulier.gilles 2019-03-24 08:55:30 UTC
Hum. This popup windows is called by installer to register application icons to Windows menu entry.

You must never seen this kind of message. I suspect a broken Windows installation or a corrupted something in your system.

Here, i run Windows 7 and Windows 10 in virtual machine to test the Windows installer and the application. I never seen something like this.

I recommend : 
1/ to take another computer with a fresh Windows (7 | 8 |10).
2/ to install the last stable 6.0.0 as 5.x start to become really an older version. Take a care that 6.x come with a new database schema which will be migrated from 5.x at first run. You will be not able to go back to 5.x later. Make a database backup before.
3/ you can take also the 6.1.0 pre-release installer where we come with plenty of fix for Windows.

https://files.kde.org/digikam/

Gilles Caulier
Comment 4 buz.scud 2019-03-24 09:18:19 UTC
I see. Noted. I'll try my best and do as as per recommendation. I'll get back to you later. Tq very much :)
Comment 5 Maik Qualmann 2019-03-24 10:54:59 UTC
Which errors occur exactly when you try to add a collection? Maybe with screenshot. The DOS window after installation is normal and is an output of KSycoca and the error message is not a problem on Windows.

Maik
Comment 6 buz.scud 2019-03-24 12:47:32 UTC
Created attachment 118993 [details]
Unable to add collection

The error occurred when I tried to set root albums locations.

Buz
Comment 7 caulier.gilles 2019-03-24 13:50:33 UTC
Please, before to start digiKam, download debugview tool from Microsoft and run it. It will capture all debug trace from digiKam.

Start digiKam, reproduce the problem, and report here the text trace from debug view.

Look here for details :

https://www.digikam.org/contribute/

GilleS Caulier
Comment 8 buz.scud 2019-03-24 14:13:57 UTC
Created attachment 118995 [details]
Debug view report

Attached is the debug view report.

Buz
Comment 9 caulier.gilles 2019-03-24 14:24:42 UTC
It's clear : sound like your hard drive have a problem :

00000021	30.20469666	[4060] digikam.dbengine: Loading SQL code from config file "C:/Program Files/digiKam/data/digikam/database/dbconfig.xml"	
00000022	30.94044113	[4060] digikam.dbengine: Checking XML version ID => expected:  3  found:  3	
00000023	31.17895699	[4060] digikam.coredb: Core database: running schema update	
00000024	31.48474693	[4060] digikam.coredb: Core database: no database file available	
00000025	31.53408623	[4060] digikam.dbengine: Failure executing query:	
00000026	31.53408623	[4060]  "" 	
00000027	31.53408623	[4060] Error messages: "Unable to execute statement" "disk I/O error" 10 2 	
00000028	31.53408623	[4060] Bound values:  ()	
00000029	31.53421974	[4060] digikam.dbengine: Error while executing DBAction [ "CreateDB" ] Statement [ "CREATE TABLE AlbumRoots\n                            (id INTEGER PRIMARY KEY,\n                            label TEXT,\n                            status INTEGER NOT NULL,\n                            type INTEGER NOT NULL,\n                            identifier TEXT,\n                            specificPath TEXT,\n                            UNIQUE(identifier, specificPath))" ]	
00000030	31.57175064	[4060] digikam.coredb: Core database: cannot process schema initialization

It's time to call urgency service (:=)))...

Gilles Caulier
Comment 10 buz.scud 2019-03-25 00:01:57 UTC
Oh wow, looked at that. It has been hardware problem all this while. I'll thinking of the alternatives later. I have tried to get consultation from the Windows Team too. Come to worst, have to send it to professional for hardware services. Thank you Giller Caulier and Maik for the assistance :)

Recommend to close.