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

[Francesco Riosa]

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





--- Comment #5 from Francesco Riosa <francesco+kde pnpitalia it>  2011-10-10 17:42:52 ---
(In reply to comment #4)
> I have same problem.
> Here is my output
> mysql [localhost] {andor} (digikam) > SELECT * FROM Tags ORDER BY id LIMIT 10;
> +----+------+-------------------------+------+---------+-----+-----+
> | id | pid  | name                    | icon | iconkde | lft | rgt |
> +----+------+-------------------------+------+---------+-----+-----+
> |  0 |   -1 | _Digikam_root_tag_      |    0 | NULL    |   1 |  94 |
> |  1 |    0 | _Digikam_root_tag_      |    0 | NULL    |  44 |  93 |
> |  2 |    1 | _Digikam_root_tag_      |    0 | NULL    |  45 |  92 |
> |  3 |    2 | Zsani                   |    0 | NULL    |  90 |  91 |

Please could you provide also the output of:
show create table Tags;

if there is an unique index on the `id` coulumn the 3 "_Digikam_root_tag_"
should not be there, that, or the "no auto value on zero" statement failed

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.