[digikam] [Bug 374326] New: Tag view does not always show children

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

            Bug ID: 374326
           Summary: Tag view does not always show children
           Product: digikam
           Version: 4.14.0
          Platform: Ubuntu Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Tags
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

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.

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from [hidden email] ---
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

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

--- Comment #2 from [hidden email] ---
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

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

--- Comment #3 from [hidden email] ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INVALID
             Status|UNCONFIRMED                 |RESOLVED

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |5.4.0
         Resolution|INVALID                     |WORKSFORME

--
You are receiving this mail because:
You are the assignee for the bug.

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=374326

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WORKSFORME                  |FIXED

--
You are receiving this mail because:
You are the assignee for the bug.