[Digikam-devel] [Bug 306371] Rename with sequence number

[valar]

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

--- Comment #17 from valar <ivarness76 at gmail.com> ---
The Tags table is empty but the tagstree has 23 entries? suppose it is the 
insert trigger that fails (19,1 already exist) .

Thining of backing up the .db file and attempt deleting the tagtree table?? 
Alternatively rename it and relaunch digikam and reimport the album folder
(maintance mode)
Any advices here?

CREATE TABLE Tags
                            (id INTEGER PRIMARY KEY,
                            pid INTEGER,
                            name TEXT NOT NULL,
                            icon INTEGER,
                            iconkde TEXT,
                            UNIQUE (name, pid));
...
CREATE TRIGGER insert_tagstree AFTER INSERT ON Tags
                BEGIN
                INSERT INTO TagsTree
                    SELECT NEW.id, NEW.pid
                    UNION
                    SELECT NEW.id, pid FROM TagsTree WHERE id=NEW.pid;
                END;

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