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

[e.longuemare at laposte.net]

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

e.longuemare at laposte.net changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |e.longuemare at laposte.net

--- Comment #29 from e.longuemare at laposte.net ---
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

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