Bug 405799 - Not possible to add collection
Summary: Not possible to add collection
Status: RESOLVED NOT A BUG
Alias: None
Product: digikam
Classification: Applications
Component: Database-Sqlite (other bugs)
Version First Reported In: 5.7.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-24 06:14 UTC by buz.scud
Modified: 2019-03-25 04:34 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed/Implemented In: 6.1.0
Sentry Crash Report:


Attachments
Unable to add collection (141.78 KB, image/jpeg)
2019-03-24 12:47 UTC, buz.scud
Details
Debug view report (316.55 KB, text/plain)
2019-03-24 14:13 UTC, buz.scud
Details

Note You need to log in before you can comment on or make changes to this bug.
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.