I'm trying to create a trigger on a mysql 5 database. Here follows the
script:

CREATE TRIGGER awbparposinsert AFTER INSERT ON awbparzialipos
FOR EACH ROW BEGIN
INSERT INTO tabdogins(awbparzialeId, house, colli, peso, data,
posmag, origId, origtipo) values( new.awbparzialeId, new.house,
new.colli, new.peso, CURDATE(), new.codPosMagazzino, new.id, 'P');
INSERT INTO tabdoggia(awbparzialeId, house, colli, peso, data,
posmag) values(new.awbparzialeId, new.house, new.colli, new.peso,
CURDATE(), new.codPosMagazzino);
END;

I get this error message:

Unknown column 'new.awbparzialeId' in 'field list'

Anyone has a solution? Thanks in advance