Why is mysql throwing error?

Question

MySQL

CREATE TRIGGER marketing_list_update
AFTER UPDATE
ON cms_offers
FOR EACH ROW
begin
if NEW.status = 'active' 
then UPDATE marketing_credits_requests SET sum_s=NEW.ammount, statut=NEW.status WHERE id_req=old.id;
else then UPDATE marketing_credits_requests SET  statut=NEW.status WHERE id_req=old.id;
end;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

Did everything on mysql docks, version 5.5.25

Answer 1

24.3.1 Trigger Syntax and Examples
don't forget about DELIMITER

Answer 2

The syntax for an IF block is:

IF search_condition THEN statement_list
    [ELSEIF search_condition THEN statement_list] ...
    [ELSE statement_list]
END IF

You have then after else and no end if.