problem z wyzwalaczem Opcje

[szypi1989]

[SQL] pobierz, plaintext 
otóż mam problem z wyzwalaczem.oto jest kod sql:
DELIMITER 
 
CREATE TRIGGER tgr_nazwy
AFTER INSERT OR UPDATE OR DELETE ON documentsPictures
FOR EACH ROW
BEGIN  
    IF (TG_OP = 'DELETE') THEN  
        UPDATE `documents` SET `picture` = (SELECT `file` FROM `documentsPictures` WHERE `documentId` = OLD.`documentId` ORDER BY weight LIMIT 1) WHERE `documentId` = OLD.`documentId`;  
    ELSE  
        UPDATE `documents` SET `picture` = (SELECT `file` FROM `documentsPictures` WHERE `documentId` = NEW.`documentId` ORDER BY weight LIMIT 1) WHERE `documentId` = NEW.`documentId`;  
    END IF;  
    RETURN NEW;  
END;  
[SQL] pobierz, plaintext 

proszę o pomoc,gdzie tu jest błąd

[szypi1989]

przy UPDATE OLD także nie chodzi.
oto kod:

[SQL] pobierz, plaintext 
delimiter
 
    CREATE TRIGGER tgr_nazwy
    AFTER UPDATE ON documentsPictures
    FOR EACH ROW
    BEGIN
    IF (TG_OP = 'DELETE') THEN
    UPDATE `documents` SET `picture` = (SELECT `file` FROM `documentsPictures` WHERE `documentId` = OLD.`documentId` ORDER BY weight LIMIT WHERE `documentId` = OLD.`documentId`;
    ELSE
    UPDATE `documents` SET `picture` = (SELECT `file` FROM `documentsPictures` WHERE `documentId` = NEW.`documentId` ORDER BY weight LIMIT WHERE `documentId` = NEW.`documentId`;
    END IF;
    RETURN NEW;
    END; 
[SQL] pobierz, plaintext