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.

Reply via email to