1 May 2012 01:42
[Bug 298929] cannot assign tags anymore
https://bugs.kde.org/show_bug.cgi?id=298929 --- Comment #3 from Kusi <kusi@...> --- 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(Continue reading)
RSS Feed