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

nmset <nm...@netcourrier.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nm...@netcourrier.com

--- Comment #3 from nmset <nm...@netcourrier.com> ---
An ugly workaround to remove the duplicates : 

mysql -D akonadi -S $HOME/.local/share/akonadi/socket-$(hostname)/mysql.socket
-e "delete from tagtable where typeId = 2"

For unknown reasons, every time a tagged event (i.e, with category) is edited,
an entry is added in tagtable in this form :

 id | gid                                  | parentId | typeId
 43 | c8b4e689-be91-4127-85d6-db12602279b3 |     NULL |      2

and another linked entry is added in tagattributetable :

id | tagId | type | value
41 |    43 | TAG  | ("TestCategory" "" "" "" "0" () () "-1")

Those duplicates in tagtable always have a value 2 in typeId column. Deleting
those entries cascade in related tables.

Let's hope the devs fix this longstanding bug.

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to