https://bugs.kde.org/show_bug.cgi?id=352645
--- Comment #4 from nmset <nm...@netcourrier.com> ---
This workaround restores normal expected use of categories and colours.
First, clean tagtable as per my above post.
Next, log in MariaDB :
mysql -D akonadi -S $HOME/.local/share/akonadi/socket-$(hostname)/mysql.socket
Create this trigger :
DELIMITER $$
CREATE TRIGGER tagtable_before_insert BEFORE INSERT ON tagtable
FOR EACH ROW
BEGIN
IF NEW.typeId > 1 THEN
SET NEW.gid = NULL;
END IF;
END
$$ DELIMITER ;
It prevents annoying and disrupting inserts in tagtable whenever an event with
a category is edited. I'm using New.typeId > 1 for a default KDEPIM
installation and usecase. Look in tagtypetable where tagtable.typeId is
explained.
If you need to delete the trigger, when the bug is hopefully addressed :
DROP TRIGGER tagtable_before_insert;
In case it helps.
--
You are receiving this mail because:
You are watching all bug changes.
