create Trigger mysql

Question

I have two tables: the requested table and the logs table. Users can interact with the requested table, link a php script that runs a query update and update the status column. I need to create a Trigger that, when running this update query, saves the change in the log table.

I used this Rigger, but now does not update either the requested table or the log table:

        DELIMITER $$
        CREATE TRIGGER salva_status 
        BEFORE UPDATE ON pedidos
        FOR EACH ROW BEGIN
        INSERT INTO logs
        SET acao = 'update',
        nPedido = OLD.nPedido,
        status = OLD.status,
        modificadoem = NOW(); END$$
        DELIMITER ;

These are the query for table creation:

This table is the one that stores the order information

         CREATE TABLE `localhost`.`pedidos` ( `id` INT NOT NULL AUTO_INCREMENT , `emissaoPed` INT NOT NULL , 
        `nPed` INT NOT NULL , 
        `NrPedido` VARCHAR(20) NOT NULL ,
         `nomeAbrev` VARCHAR(50) NOT NULL , 
        `vlr` FLOAT NOT NULL , 
        `status` VARCHAR(20) NOT NULL , 
        UNIQUE (`id`)) ENGINE = InnoDB;

And this is the table that will store the logs:

        CREATE TABLE `root`.`logs` ( 
        `id` INT NOT NULL AUTO_INCREMENT , 
        `NrPedido` VARCHAR(20) NOT NULL , 
        `antigoStatus` VARCHAR(20) NOT NULL , 
        `novoStatus` VARCHAR(20) NOT NULL ,
         `modificadoem` DATE NOT NULL , 
        `vlr` FLOAT NOT NULL , 
        `status` VARCHAR(20) NOT NULL , 
        UNIQUE (`id`)) ENGINE = InnoDB;

Answer 1

Try changing the INSERT:

INSERT INTO logs
        SET acao = 'update',
        nPedido = OLD.nPedido,
        status = OLD.status,
        modificadoem = NOW();

for

 INSERT INTO logs
          (acao, nPedido, status, modificagem)
        VALUES
          ('update', OLD.nPedido, OLD.status, NOW());