[Digikam-devel] [Bug 283323] a new label _Digikam_root_tag_ is created every time

[eldk]

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






--
View this message in context: http://digikam.1695700.n4.nabble.com/Bug-283323-New-a-new-label-Digikam-root-tag-is-created-every-time-tp3871432p4660413.html
Sent from the digikam-devel mailing list archive at Nabble.com.