[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-bugs-dist
Subject: [Bug 298929] cannot assign tags anymore
From: Kusi <kusi () forum ! titlis ! org>
Date: 2012-04-30 23:42:53
Message-ID: bug-298929-17878-0nHinm8719 () http ! bugs ! kde ! org/
[Download RAW message or body]
https://bugs.kde.org/show_bug.cgi?id=298929
--- Comment #3 from Kusi <kusi@forum.titlis.org> ---
I came across this link http://www.phplogs.com/the-user-specified-as-a-definer/
so I dropped all 3 triggers I could find and created two of them again,
according to what I've found in dbconfig.xml
delimiter //
CREATE TRIGGER delete_image AFTER DELETE ON Images
FOR EACH ROW BEGIN
DELETE FROM ImageTags WHERE imageid=OLD.id;
DELETE From ImageHaarMatrix WHERE imageid=OLD.id;
DELETE From ImageInformation WHERE imageid=OLD.id;
DELETE From ImageMetadata WHERE imageid=OLD.id;
DELETE From ImagePositions WHERE imageid=OLD.id;
DELETE From ImageComments WHERE imageid=OLD.id;
DELETE From ImageCopyright WHERE imageid=OLD.id;
DELETE From ImageProperties WHERE imageid=OLD.id;
DELETE From ImageHistory WHERE imageid=OLD.id;
DELETE FROM ImageRelations WHERE subject=OLD.id OR
object=OLD.id;
DELETE FROM ImageTagProperties WHERE imageid=OLD.id;
UPDATE Albums SET icon=null WHERE icon=OLD.id;
UPDATE Tags SET icon=null WHERE icon=OLD.id;
END; //
and
CREATE TRIGGER delete_tag AFTER DELETE ON Tags
FOR EACH ROW BEGIN
DELETE FROM ImageTags WHERE tagid=OLD.id;
DELETE FROM TagProperties WHERE tagid=OLD.id;
DELETE FROM ImageTagProperties WHERE tagid=OLD.id;
END; //
I couldn't find anything for move_tagtree, is that correct?
--
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