[digiKam-users] Fwd: Re: More fighting with DigiKam

[James Orr]

Responding to the observation that the DK database might be invalid or corrupt, I noted that it seems to include new photos as I add them. After reading a bit more about SQLite, it seemed to me that the next database step might be to VACUUM the dust and detritus. I looked in TOOLS|MAINTENANCE |PERFORM DATABASE CLEANING. I left SCAN FOR NEW ITEMS checked and unchecked all the other boxes except for PERFORM DATABASE CLEANING. The cleaning process was slow, so I worked on a CADD project for several hours. At some time during the interval, I noticed that DK no longer showed in the Task Bar.--OK, it's done.

When I finished the CADD project, I clicked on the DK destop icon and got an error message. When I searched for the DK exe program, it was missing. I had to reinstall DK.

Looking at database statistics, the database had been reduced in size by about half. Tags, Pick List, and Colors still do not function. The next step, I guess, is to rename the existing database (I also make a disk image of my system nightly). This would force DK to create a new database, I expect. I think this is a drastic step. Any better ideas before I actually do it?

-------- Forwarded Message --------

Subject:	Re: [digiKam-users] More fighting with DigiKam
Date:	Thu, 25 Apr 2019 22:38:13 +0200
From:	Gilles Caulier [hidden email]
To:	James Orr [hidden email]

In digikam log, i see also these :

00001207 700.09667969 [13528] SkypeBridge.exe Information: 0 :

00001208 700.09771729 [13528] 2019-04-25 11:57:08.514-07:00 [13528:001] [INFO] Keeping user active

00001209 700.59759521 [9772] PPLE [Informational] LIFECYCLE: OnResuming

00001210 700.60040283 [13528] SkypeBridge.exe Information: 0 :

00001211 700.60357666 [13528] 2019-04-25 11:57:08.659-07:00 [13528:079] [INFO] IdleStateTracker - SendSystemIdleStatusUpdateAsync sent isIdle = False 

SkypeBridge perturb digiKam while running. This is the magic world of Windows and anti spyware / anti virus mess... 

Gilles Caulier

Le jeu. 25 avr. 2019 à 22:34, Gilles Caulier <[hidden email]> a écrit :

00000942 460.23703003 [9544] digikam.general: Tag 0x16068973e40 do not have a valid parent

...

00001065 461.62533569 [9544]  "INSERT INTO Tags (pid, name) VALUES( :a, :bb);"

00001066 461.62533569 [9544] Error messages: "Unable to fetch row" "UNIQUE constraint failed: TagsTree.id, TagsTree.pid" 19 1

00001067 461.62533569 [9544] Bound values:  (QVariant(int, 1), QVariant(QString, "Color Label None"))

00001068 461.62533569 [9544] digikam.dbengine: Error while executing DBAction [ "InsertTag" ] Statement [ "INSERT INTO Tags (pid, name) VALUES( :tagPID, :tagname);" ]

00001069 461.62542725 [9544] digikam.database: Attempt to create tag properties for tag id 0

00001070 461.62728882 [9544] digikam.dbengine: Failure executing query:

00001071 461.62728882 [9544]  "INSERT INTO Tags (pid, name) VALUES( :a, :bb);" 

this error appear multiple time. It's abnormal. Sound like the database contents is invalid or corrupted.

Gilles Caulier

Le jeu. 25 avr. 2019 à 21:03, James Orr <[hidden email]> a écrit :

I attached a DebugView log to this message.
I use Zone Alarm for antivirus.

ZoneAlarm Extreme Security version: 15.4.062.17802
ZoneAlarm license key: *****
Vsmon version: 15.4.52.17711
Driver version: 15.1.29.17237
Antivirus engine version: 8.8.1.110
Antivirus signature DAT file version: 1318666784

I also use Malware bytes version 3.7.1.2839, component package 1.0.563, update package 1.0.10340

On 4/24/2019 9:31 PM, Gilles Caulier wrote:

Hi, 

To understand where is the problem under your Windows 10 computer, please install the DebugView program from Microsoft as explained here :

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

DebugView will catch all low level debug messages generated by digiKam while running (under Linuc these kind of traces are printed on the console)

Just report the debug statements here to investiguate.

Q : did you use an Anti-Virus of your Windows 10 computer ?

Best 

Gilles Caulier 

Le jeu. 25 avr. 2019 à 02:01, James Orr <[hidden email]> a écrit :

When I went through the process of adding the tag "Turkey" I tried both options in the initial window (with and without the initial "/". Neither was accepted.

On 4/24/2019 12:46 PM, Rob Dueckman wrote:

James, do you have the slash "/" in the tag you are trying to add? If so, maybe try it without the slash. Like others, I have tagged thousands of photos with no issues. I even live dangerously and write all metadata back to the original files (not .xmp's) without any issues (so far).

Rob

On Wed, 2019-04-24 at 09:48 -0700, James Orr wrote:

Re-sending from my normal account.

-------- Forwarded Message --------

Subject:	More fighting with DigiKam
Date:	Tue, 23 Apr 2019 10:15:06 -0700
From:	James Orr [hidden email]
To:	digikam-users-group--kde.org [hidden email]

I really do want to like and use DigiKam. It is getting harder to succeed.

Several weeks ago, I asked about what to do when DigiKam would not record and use Pick Labels and Color Labels. I use Windows 10 on a very capable machine. I've upgraded to a couple of git versions, and now to 6.1.0. I still cannot get these features to work.

I'm now preparing to copy several thousand images (prints and slides) I made in Turkey in 1985-1986. A pick list would be very useful. I also want to tag images with keywords to help me find the images I want after they are all digitized. So, I tried simply to add the word "Turkey" to no avail. I get a dialogue box that tells me "An error occurred during tag creation" and" /Turkey failed to add tag to database".
I think these are all related to database management.

I looking in my D:\Pictures folder and found this file name: .~lock.digikam4.db# (dated in 02-2019) I renamed it to .~lock.digikam4.db#.old. Nothing changed in my attempt to add a tag.

So, I wonder what is next for me to do.

[Gilles Caulier-4]

Le sam. 27 avr. 2019 à 17:51, James Orr <[hidden email]> a écrit :

Responding to the observation that the DK database might be invalid or corrupt, I noted that it seems to include new photos as I add them. After reading a bit more about SQLite, it seemed to me that the next database step might be to VACUUM the dust and detritus. I looked in TOOLS|MAINTENANCE |PERFORM DATABASE CLEANING. I left SCAN FOR NEW ITEMS checked and unchecked all the other boxes except for PERFORM DATABASE CLEANING. The cleaning process was slow, so I worked on a CADD project for several hours. At some time during the interval, I noticed that DK no longer showed in the Task Bar.--OK, it's done.

When I finished the CADD project, I clicked on the DK destop icon and got an error message. When I searched for the DK exe program, it was missing. I had to reinstall DK.

This is typically abnormal. Can you imagine that we will release a program for windows without to check is installer work properly.

I suspect highly a side effect from an antivirus. DigiKam is not a spyware/malware. We voluntary cross compile ALL codes under Linux for Windows, to prevent any contamination with these kind of mess. All is clean at end, as Linux is safe.

Looking at database statistics, the database had been reduced in size by about half. Tags, Pick List, and Colors still do not function. The next step, I guess, is to rename the existing database (I also make a disk image of my system nightly). This would force DK to create a new database, I expect. I think this is a drastic step. Any better ideas before I actually do it?

If you want to be sure, and test the program without to break anything, create a virtual machine (with VirtualBox is enough), install your Windows without any other extra program, and install digiKam. Import some collections of images for testing and look how it work and if is stable enough.

We your tests pass well, Install your spyware/malware stuff and look the side effects. If i insist on this point, It's because we already see this kind of report in the past. 

Typically, i suspect that commercial programs pay to be white listed on this "security" stuff... As we working for open source, this will never come with digiKam.

My best

Gilles Caulier

[James Orr]

I determined that MalwareBytes had quarantined DigiKam on three different dates. That moved the exe and the desktop shortcut out of site. MalwareBytes did not notify me when it acted, so I was uninformed.

I did create a virtual machine with Oracle's VM Virtual Box. This turned out to be more of a challenge than I had expected. However, I installed DK in the new Win 10 pro environment and I copied some CR2 files to the new environment. I was able to add new tags. I was able to add labels for color, pick list, and star. The filter worked for each of these attributes. Clearly my main system is blocking DigiKam from performing its function.

I have modified Malwarebytes exclusion list for the DigiKam folder and the SQLite Browser, and for the digikam.exe and SQLite.exe files. I also excluded the gdb.exe, kbuildsycocoa5.exe, and the showfoto.exe files. However, this has not opened the environment for DigiKam to function properly. I am waiting the hear from Malwarebytes.

Any ideas for my next steps?

-------- Forwarded Message --------

Subject:	Re: [digiKam-users] More fighting with DigiKam
Date:	Sat, 27 Apr 2019 18:12:41 +0200
From:	Gilles Caulier [hidden email]
Reply-To:	digiKam - Home Manage your photographs as a professional with the power of open source [hidden email]
To:	digikam-users-group--kde.org [hidden email]

Le sam. 27 avr. 2019 à 17:51, James Orr <[hidden email]> a écrit :

Responding to the observation that the DK database might be invalid or corrupt, I noted that it seems to include new photos as I add them. After reading a bit more about SQLite, it seemed to me that the next database step might be to VACUUM the dust and detritus. I looked in TOOLS|MAINTENANCE |PERFORM DATABASE CLEANING. I left SCAN FOR NEW ITEMS checked and unchecked all the other boxes except for PERFORM DATABASE CLEANING. The cleaning process was slow, so I worked on a CADD project for several hours. At some time during the interval, I noticed that DK no longer showed in the Task Bar.--OK, it's done.

When I finished the CADD project, I clicked on the DK destop icon and got an error message. When I searched for the DK exe program, it was missing. I had to reinstall DK.

This is typically abnormal. Can you imagine that we will release a program for windows without to check is installer work properly.

I suspect highly a side effect from an antivirus. DigiKam is not a spyware/malware. We voluntary cross compile ALL codes under Linux for Windows, to prevent any contamination with these kind of mess. All is clean at end, as Linux is safe.

Looking at database statistics, the database had been reduced in size by about half. Tags, Pick List, and Colors still do not function. The next step, I guess, is to rename the existing database (I also make a disk image of my system nightly). This would force DK to create a new database, I expect. I think this is a drastic step. Any better ideas before I actually do it?

If you want to be sure, and test the program without to break anything, create a virtual machine (with VirtualBox is enough), install your Windows without any other extra program, and install digiKam. Import some collections of images for testing and look how it work and if is stable enough.

We your tests pass well, Install your spyware/malware stuff and look the side effects. If i insist on this point, It's because we already see this kind of report in the past. 

Typically, i suspect that commercial programs pay to be white listed on this "security" stuff... As we working for open source, this will never come with digiKam.

My best

Gilles Caulier

[Gilles Caulier-4]

Hi,

Great tto hear that you found the origin of the problem. As i suspect, the malware extra program make a mess on computer instead to secure well the operating system.

If digiKam refuse to run even your tune in malware application, remember that digiKam.exe use plenty of shared libraries (.dll) which will be certainly also blocked from malware stuff...

My tip : secure your host computer differently and do not use this "waste of time" malware stuff...

Best

Gilles Caulier  

Le mer. 1 mai 2019 à 06:46, James Orr <[hidden email]> a écrit :

I determined that MalwareBytes had quarantined DigiKam on three different dates. That moved the exe and the desktop shortcut out of site. MalwareBytes did not notify me when it acted, so I was uninformed.

I did create a virtual machine with Oracle's VM Virtual Box. This turned out to be more of a challenge than I had expected. However, I installed DK in the new Win 10 pro environment and I copied some CR2 files to the new environment. I was able to add new tags. I was able to add labels for color, pick list, and star. The filter worked for each of these attributes. Clearly my main system is blocking DigiKam from performing its function.

I have modified Malwarebytes exclusion list for the DigiKam folder and the SQLite Browser, and for the digikam.exe and SQLite.exe files. I also excluded the gdb.exe, kbuildsycocoa5.exe, and the showfoto.exe files. However, this has not opened the environment for DigiKam to function properly. I am waiting the hear from Malwarebytes.

Any ideas for my next steps?

-------- Forwarded Message --------

Subject:	Re: [digiKam-users] More fighting with DigiKam
Date:	Sat, 27 Apr 2019 18:12:41 +0200
From:	Gilles Caulier [hidden email]
Reply-To:	digiKam - Home Manage your photographs as a professional with the power of open source [hidden email]
To:	digikam-users-group--kde.org [hidden email]

Le sam. 27 avr. 2019 à 17:51, James Orr <[hidden email]> a écrit :

Responding to the observation that the DK database might be invalid or corrupt, I noted that it seems to include new photos as I add them. After reading a bit more about SQLite, it seemed to me that the next database step might be to VACUUM the dust and detritus. I looked in TOOLS|MAINTENANCE |PERFORM DATABASE CLEANING. I left SCAN FOR NEW ITEMS checked and unchecked all the other boxes except for PERFORM DATABASE CLEANING. The cleaning process was slow, so I worked on a CADD project for several hours. At some time during the interval, I noticed that DK no longer showed in the Task Bar.--OK, it's done.

When I finished the CADD project, I clicked on the DK destop icon and got an error message. When I searched for the DK exe program, it was missing. I had to reinstall DK.

This is typically abnormal. Can you imagine that we will release a program for windows without to check is installer work properly.

I suspect highly a side effect from an antivirus. DigiKam is not a spyware/malware. We voluntary cross compile ALL codes under Linux for Windows, to prevent any contamination with these kind of mess. All is clean at end, as Linux is safe.

Looking at database statistics, the database had been reduced in size by about half. Tags, Pick List, and Colors still do not function. The next step, I guess, is to rename the existing database (I also make a disk image of my system nightly). This would force DK to create a new database, I expect. I think this is a drastic step. Any better ideas before I actually do it?

If you want to be sure, and test the program without to break anything, create a virtual machine (with VirtualBox is enough), install your Windows without any other extra program, and install digiKam. Import some collections of images for testing and look how it work and if is stable enough.

We your tests pass well, Install your spyware/malware stuff and look the side effects. If i insist on this point, It's because we already see this kind of report in the past. 

Typically, i suspect that commercial programs pay to be white listed on this "security" stuff... As we working for open source, this will never come with digiKam.

My best

Gilles Caulier