Re: Syntax error in trigger

[Gabriella Pepe]

Sorry for the previous post, this is the entire code (see comment):

DELIMITER //

CREATE TRIGGER onNewRow

AFTER INSERT
ON wp_postmeta FOR EACH ROW

BEGIN

DECLARE current_id bigint(20);
DECLARE mail_address varchar(100);
DECLARE user_id bigint(20);

-- here I'm hoping post_id is the post_id related to the new inserted row
-- I don't know if this is wrong
SET current_id = post_id;

SET mail_address = (SELECT meta_value FROM wp_postmeta WHERE post_id = current_id AND meta_key = "_from_email");

SET user_id = (SELECT ID FROM wp_users WHERE user_email = mail_address);

-- I don't know if this query could be assigned to a variable too
-- I don't know how to assign its type (*)
IF(exists(SELECT * FROM wp_posts WHERE ID = current_id AND post_type = "inbound" AND post_title IN ("Website feedback","General contact form")) THEN UPDATE wp_posts SET post_author = user_id WHERE ID = current_id;

END IF;

END; //

DELIMITER ;