Error executing trigger after insert

0

Trigger:

  

INSERT INTO payments SET identrada = NEW.id, idusuario = NEW.idusuario,   idcuenta = NEW.idcuenta, payment = 0, description = 'Entrada', sinpagar =   0, form = 'S / P', time = NEW.hour, date = NEW.date, postdate = NEW.date

My entry table:

My payments table:

My mistake:

  

Can not add or update a child row: a foreign key constraint fails   ( munici27_proHASS . pagos , CONSTRAINT pagos_ibfk_1 FOREIGN KEY   ( identrada ) REFERENCES entrada ( id ) ON UPDATE CASCADE)

    
asked by DoubleM 21.04.2018 в 20:43
source

0 answers