Re: [Bug 283323] a new label _Digikam_root_tag_ is created every time

Posted by eldk on Nov 09, 2012; 4:06pm
URL: http://digikam.185.s1.nabble.com/Bug-283323-New-a-new-label-Digikam-root-tag-is-created-every-time-tp3871432p4660413.html

Hello,

I've got the same problem with digikam 2.8.0 from Philips PPA (xubuntu 12.04).
I've tried from mysql 5.1.61 and mysql 5.5.28-0ubuntu0.12.04.2, always the same.
Cleaning the tags and rewrite it to image, the tag _Digikam_root_tag is always there.
+ this "bugs" :
so tagging is not usable.

Query Output:
> SELECT * FROM digikam.Tags ORDER BY id LIMIT 10

+ ------- + -------- + --------- + --------- + ------------ + -------- + -------- +
| id      | pid      | name      | icon      | iconkde      | lft      | rgt      |
+ ------- + -------- + --------- + --------- + ------------ + -------- + -------- +
| 0       | -1       | _Digikam_root_tag_ | 0         |              | 1        | 542      |
| 1       | 0        | _Digikam_root_tag_ | 0         |              | 246      | 541      |
| 2       | 1        | lieu      | 0         |              | 461      | 540      |
| 3       | 2        | capblancnez | 0         |              | 538      | 539      |
| 4       | 0        | _Digikam_Internal_Tags_ | 0         |              | 204      | 245      |
| 5       | 4        | Color Label None | 0         |              | 243      | 244      |
| 6       | 4        | Color Label Red | 0         |              | 241      | 242      |
| 7       | 4        | Color Label Orange | 0         |              | 239      | 240      |
| 8       | 4        | Color Label Yellow | 0         |              | 237      | 238      |
| 9       | 4        | Color Label Green | 0         |              | 235      | 236      |
| NULL    | NULL     | NULL      | NULL      | NULL         | NULL     | NULL     |
+ ------- + -------- + --------- + --------- + ------------ + -------- + -------- +
11 rows

Query Output:
> show create table digikam.TagsTree

+ --------- + ---------------- + ------------------------- + ------------------------- +
| View      | Create View      | character_set_client      | collation_connection      |
+ --------- + ---------------- + ------------------------- + ------------------------- +
| TagsTree  | CREATE ALGORITHM=UNDEFINED DEFINER=`sospcdk`@`192.168.1.10` SQL SECURITY DEFINER VIEW `digikam`.`TagsTree` AS select `digikam`.`Tags`.`id` AS `id`,`digikam`.`Tags`.`pid` AS `pid` from `digikam`.`Tags` | utf8                      | utf8_general_ci           |
+ --------- + ---------------- + ------------------------- + ------------------------- +
1 rows

Is there a solution ?

Greatings,

Eric