[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-bugs-dist
Subject: [digikam] [Bug 283323] a new label _Digikam_root_tag_ is created every time
From: Alexander Meshcheryakov <alexander.s.m () gmail ! com>
Date: 2013-08-31 22:45:52
Message-ID: bug-283323-17878-mhj6jYL6rG () http ! bugs ! kde ! org/
[Download RAW message or body]
https://bugs.kde.org/show_bug.cgi?id=283323
Alexander Meshcheryakov <alexander.s.m@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |alexander.s.m@gmail.com
--- Comment #60 from Alexander Meshcheryakov <alexander.s.m@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 watching all bug changes.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic