Bug 374326 - Tag view does not always show children
Summary: Tag view does not always show children
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Tags-Engine (show other bugs)
Version: 4.14.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-30 11:39 UTC by kde
Modified: 2017-01-02 09:01 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 5.4.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description kde 2016-12-30 11:39:26 UTC
The Digikam Tags View does not always show all images with tags in the tag tree.

I have a tag tree as follows:
people
|
--Last name 1
  |
  -- First Name
--Last name 2
  |
  -- First Name
etc

My images are tagged on the "First Name" level, so Images are not tagged with "Last Name" or "People" tag.

When I select a "Last Name 1" in the Tags View I expect to be shown all images that have a Tag in the Tag Tree starting with "Last Name 1", including its children. This usually works, but not always.

I have found out that when a child tag (e.g. "First Name") is older than the parent tag (e.g. "Last Name 1"), the Images with the hild tags are not shown. When I create a new child tag and retag the images with the new tag, the images are found.

The reason the child tag is older than the parent tag is that I created the name hierarchy later than some of the First Name tags.

Expected behaviour:
When selecting a Tag in the Tags View, all images with the Tag and its child tags should be shown, regardless of age of the tags.
Comment 1 caulier.gilles 2016-12-30 12:07:41 UTC
As bug #374327, It's not reproducible here...

Please check with current universal AppImage Linux bundle available here :

https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM

Gilles Caulier
Comment 2 kde 2016-12-30 20:10:23 UTC
I tried digikam-5.4.0-01-x86-64.appimage

When executing it, it complains about not being able to convert to version 8 of the database. (see below).

On further investigation, I also seem to be missing many tags that I made in the past. That leads me to believing I'm dealing with a corrupt database, not a bug. I guess the best way ahead would be to close this bug and start with a new digikam database :(
Any pointers regarding salvaging my tag database would be appreciated. I put a lot of work into organizing this collection, and I would hate to have to start over.

digikam.coredb: Core database: running schema update
digikam.geoiface: ----
digikam.coredb: Core database: have a structure version  7
digikam.coredb: Core database: makeUpdates  7  to  8
digikam.dbengine: Failure executing query:
 "" 
Error messages: "QMYSQL: Unable to execute query" "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS identifier' at line 2" 1064 2 
Bound values:  ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ] Statement [ "ALTER TABLE AlbumRoots\n                                        DROP INDEX IF EXISTS identifier;" ]
digikam.coredb: Core database: schema update to V 8 failed!
digikam.coredb: Core database: cannot process schema initialization
Comment 3 kde 2017-01-02 08:44:41 UTC
I have now version 5.3 running with a fresh database. I think I managed to rescue most of the tags that I had.

I cannot reproduce the behaviour I was seeing so I'll close this one. Apologies for the noise.