Está mal escrito.
Te faltan varias partes:
Código sql:
Ver originalDROP TRIGGER IF EXISTS projectes;
DELIMITER $$
CREATE TRIGGER `projectes` AFTER INSERT OR UPDATE ON projects
FOR EACH ROW
BEGIN
INSERT INTO projects_log
SET projects_log.project_id = NEW.project_id,
projects_log.project_short_name = NEW.project_short_name,
projects_log.project_creation = TIMESTAMP( )
END$$
DELIMITER ;