Category system, SQLite DB, table "Tags"

[nji9]

In the table there are items that are not shown in XnViewMP.

EDIT:
It' worse:
Some files are assoziated with the "invisible" categories,
not shown anywhere (except in the db of course).

[xnview]

Perhaps files removed outside

[nji9]

No, you do misunderstand.

It's NOT about files, but about categories.

In Xnview.db there are entries in the "Tags" table
that are not seen in XnViewMP anywhere.
Long time ago I removed them.
And even worse:
Due to the "TagsTree" table in Xnview.db
some files are associated with that "no existing" labels!

There is a bug in XnViewMP:
Not showing all category entries that are in the db's table "Tag".

Confirm?

[xnview]

houps sorry. Strange, which column values do you have? Is it possible to have your .db?

[nji9]

Sent as PM...

[user0]

just experienced similar issue

A
while working with categories via the UI (creating, renaming, and moving them), I noticed that one of them disappeared (c2).
Record still exists in db, but somehow has ParentID = TagID
Unfortunately, I have not been able to reproduce this issue so far and do not have this db anymore.

B
if there is a record in Tags with ParentID = TagID and 'Update files from catalog is pressed - app stuck with updating dialog

db_categories_parentID_equals_TagID.png

[xnview]

A
while working with categories via the UI (creating, renaming, and moving them), I noticed that one of them disappeared (c2).
Record still exists in db, but somehow has ParentID = TagID
Unfortunately, I have not been able to reproduce this issue so far and do not have this db anymore.

c2 had which parent?

B
if there is a record in Tags with ParentID = TagID and 'Update files from catalog is pressed - app stuck with updating dialog

yes, it's a problem

[user0]

c2 had which parent?

unfortunately, I do not remember

btw, what is the purpose of ID field in Tags table?

[xnview]

btw, what is the purpose of ID field in Tags table?

currently not used