Why do I get error 1054 using trigger on INSERT saying that column isn't on the field list? I am trying to write a Trigger to register every new inserted genre into a news table. 

Here are the tables definitions. They are only two, GENEROS &amp; NOVEDADES.

This is the trigger:

CREATE TRIGGER insertarNovedades AFTER INSERT ON GENEROS
FOR EACH ROW 
    INSERT INTO NOVEDADES (novedad) VALUES (CONCAT('Nuevo genero: ', genero));
$$


But MySQL don't let me use it:

mysql&gt; INSERT INTO GENEROS (genero)VALUES('f');
ERROR 1054 (42S22): Unknown column 'genero' in 'field list'


What is wrong on the trigger code?
This works:

CREATE TRIGGER insertarNovedades AFTER INSERT ON GENEROS
FOR EACH ROW
    INSERT INTO NOVEDADES (novedad) VALUES (CONCAT('Nuevo genero: ', new.genero));




Manual has this example and the following explanation:

mysql&gt; CREATE TRIGGER ins_sum BEFORE INSERT ON account
     -&gt; FOR EACH ROW SET @sum = @sum + NEW.amount; Query OK, 0 rows affected (0.06 sec)



  The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by the triggering event. In the example, the trigger body is a simple SET that accumulates into a user variable the values inserted into the amount column. The statement refers to the column as NEW.amount which means “the value of the amount column to be inserted into the new row.”