[Digikam-devel] [Bug 298929] New: cannot assign tags anymore

[Kusi]

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

            Bug ID: 298929
          Severity: grave
           Version: 2.5.0
          Priority: NOR
          Assignee: digikam-devel at kde.org
           Summary: cannot assign tags anymore
    Classification: Unclassified
                OS: Linux
          Reporter: kusi at forum.titlis.org
          Hardware: Ubuntu Packages
            Status: UNCONFIRMED
         Component: Database
           Product: digikam

I add tag T1 to pic1 and tag T2 to pic2. When I look for all pics with tag T1,
I get pic1 and pic2 -> bug

I did the following query on the database to figure out what's going on:
select * from ImageTags,Tags where ImageTags.imageid = '326480' and
ImageTags.tagid = Tags.id

+---------+-------+-----+------+------------------+------+-----------------+-----+-----+
| imageid | tagid | id  | pid  | name             | icon | iconkde         |
lft | rgt |
+---------+-------+-----+------+------------------+------+-----------------+-----+-----+
|  326480 |    16 |  16 |  490 | Ski              |    0 | NULL            |
943 | 944 |
|  326480 |    74 |  74 |   32 | Nathalie         |    0 | emblem-favorite |
873 | 874 |
|  326480 |   296 | 296 |   34 | Flumserberg      |    0 | NULL            |
257 | 258 |
|  326480 |   435 | 435 |  428 | Color Label None |    0 | NULL            | 
44 |  45 |
|  326480 |   445 | 445 |  428 | Pick Label None  |    0 | NULL            | 
24 |  25 |
|  326480 |   518 | 518 |    0 | T1            |    0 | NULL            |   1 |
  2 |
+---------+-------+-----+------+------------------+------+-----------------+-----+-----+

and for the second picture
mysql> select * from ImageTags,Tags where ImageTags.imageid = '326481' and
ImageTags.tagid = Tags.id ;
+---------+-------+-----+------+------------------+------+---------+-----+-----+
| imageid | tagid | id  | pid  | name             | icon | iconkde | lft | rgt
|
+---------+-------+-----+------+------------------+------+---------+-----+-----+
|  326481 |    16 |  16 |  490 | Ski              |    0 | NULL    | 943 | 944
|
|  326481 |   296 | 296 |   34 | Flumserberg      |    0 | NULL    | 257 | 258
|
|  326481 |   435 | 435 |  428 | Color Label None |    0 | NULL    |  44 |  45
|
|  326481 |   445 | 445 |  428 | Pick Label None  |    0 | NULL    |  24 |  25
|
|  326481 |   519 | 519 |    0 | T2            |    0 | NULL    |   1 |   2 |
+---------+-------+-----+------+------------------+------+---------+-----+-----+

then I was adding T3 to pic1

mysql> select * from ImageTags,Tags where ImageTags.imageid = '326480' and
ImageTags.tagid = Tags.id;
+---------+-------+-----+------+------------------+------+-----------------+-----+-----+
| imageid | tagid | id  | pid  | name             | icon | iconkde         |
lft | rgt |
+---------+-------+-----+------+------------------+------+-----------------+-----+-----+
|  326480 |    16 |  16 |  490 | Ski              |    0 | NULL            |
943 | 944 |
|  326480 |    74 |  74 |   32 | Nathalie         |    0 | emblem-favorite |
873 | 874 |
|  326480 |   296 | 296 |   34 | Flumserberg      |    0 | NULL            |
257 | 258 |
|  326480 |   435 | 435 |  428 | Color Label None |    0 | NULL            | 
44 |  45 |
|  326480 |   445 | 445 |  428 | Pick Label None  |    0 | NULL            | 
24 |  25 |
|  326480 |   518 | 518 |    0 | test3            |    0 | NULL            |  
1 |   2 |
|  326480 |   520 | 520 |    0 | test5            |    0 | NULL            |  
1 |   2 |
+---------+-------+-----+------+------------------+------+-----------------+-----+-----+

The corresponding colums in the Tags table looks like
mysql> select * from Tags where Tags.name like 'test%';
+-----+------+-------+------+---------+-----+-----+
| id  | pid  | name  | icon | iconkde | lft | rgt |
+-----+------+-------+------+---------+-----+-----+
| 519 |    0 | T2 |    0 | NULL    |   1 |   2 |
| 520 |    0 | T3 |    0 | NULL    |   1 |   2 |
| 518 |    0 | T1 |    0 | NULL    |   1 |   2 |
+-----+------+-------+------+---------+-----+-----+

it looks like lft,rgt are messed up, aren't they? What are they for? values of
lft and rgt for older photos/tags are much higher. Now they're always 1 and 2

what's going on here?

thanks! Kusi

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