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

[Alexander Meshcheryakov]

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

Alexander Meshcheryakov <alexander.s.m at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |alexander.s.m at gmail.com

--- Comment #60 from Alexander Meshcheryakov <alexander.s.m at gmail.com> ---
Occured for me with digiKam 3.3.0.

While tagging faces I got tag _Digikam_root_tag_ in tag list.

MariaDB [digikam4]> SELECT * FROM Tags WHERE name like '%Digikam%';
+----+------+-------------------------+------+---------+-----+-----+
| id | pid  | name                    | icon | iconkde | lft | rgt |
+----+------+-------------------------+------+---------+-----+-----+
|  0 |   -1 | _Digikam_root_tag_      |    0 | NULL    |   1 | 136 |
|  1 |    0 | _Digikam_Internal_Tags_ |    0 | NULL    |  90 | 135 |
| 87 |    0 | _Digikam_root_tag_      |    0 | NULL    |   2 |   5 |
+----+------+-------------------------+------+---------+-----+-----+

After removing _Digikam_root_tag_  from digiKam UI and restarting of digiKam I
do not see any tags in digiKam, but

MariaDB [digikam4]> SELECT COUNT(*) FROM Tags;
+----------+
| COUNT(*) |
+----------+
|       63 |
+----------+

MariaDB [digikam4]> SELECT COUNT(*) FROM Tags WHERE name like '%People%';
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+

Looks like my DB is messed up and I have to recreate it.

MySQL binlogs indicate that extra _Digikam_root_tag_ were created by following
queries

#130831 23:12:15 server id 1  end_log_pos 65360732      Intvar
SET INSERT_ID=87/*!*/;
# at 65360732
#130831 23:12:15 server id 1  end_log_pos 65360780      User_var
SET @`myLeft`:=1/*!*/;
# at 65360780
#130831 23:12:15 server id 1  end_log_pos 65360942      Query   thread_id=8340 
exec_time=0     error_code=0
SET TIMESTAMP=1377976335/*!*/;
INSERT INTO Tags(name, pid, lft, rgt) VALUES('_Digikam_root_tag_', 0, @myLeft +
1, @myLeft + 2)

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