Ошибка #1064 при создании триггера mysql

Запрос:

DELIMITER |
CREATE TRIGGER set_tourcount BEFORE UPDATE ON tournaments
FOR EACH ROW
  BEGIN
    DECLARE t_id int;
    DECLARE tour_count int;
    IF NEW.tournament_activetour > 0 THEN
      BEGIN
      SET t_id = OLD.tournament_id;
      SELECT COUNT (team_id) FROM active_tournaments WHERE tournament_id = t_id INTO tour_count;
      SET NEW.tournament_tourcount = tour_count;
    END;
END;
|
DELIMITER ;

Результат:

CREATE TRIGGER set_tourcount BEFORE UPDATE ON tournaments
FOR EACH ROW
  BEGIN
    DECLARE t_id int;
    DECLARE tour_count int;
    IF NEW.tournament_activetour > 0 THEN
      BEGIN
      SET t_id = OLD.tournament_id;
      SELECT COUNT (team_id) FROM active_tournaments WHERE tournament_id = t_id INTO tour_count;
      SET NEW.tournament_tourcount = tour_count;
    END;
END;

Ответ MySQL:

#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 12

Что ей надо??