Биллинговая система Nodeny

The target table v_fair_services of the UPDATE is not updatable 
{
  'param' => [
    'off',
    14
  ],
  'sql' => 'UPDATE users SET state=?, modify_time=UNIX_TIMESTAMP() WHERE id=? LIMIT 1'
};
 UPDATE users SET state='off', modify_time=UNIX_TIMESTAMP() WHERE id='14' LIMIT 1

mysql  Ver 14.14 Distrib 5.7.30, for FreeBSD12.1 (amd64) using  EditLine wrapper

DROP TRIGGER IF EXISTS `tr_fair_service`;

DELIMITER $$
CREATE TRIGGER tr_fair_service AFTER UPDATE ON users
    FOR EACH ROW
    IF OLD.state='on' AND NEW.state='off' THEN
            UPDATE
                users_services u LEFT JOIN services s ON u.service_id = s.service_id
            SET fair_stop=UNIX_TIMESTAMP(), fair_end=tm_end-UNIX_TIMESTAMP(), tm_end=0
                WHERE s.fair=1 AND uid=OLD.id AND tm_end > (UNIX_TIMESTAMP() + 5);
    ELSE
        IF OLD.state='off' AND NEW.state='on' THEN
            UPDATE
                users_services u LEFT JOIN services s ON u.service_id = s.service_id
            SET tm_end=UNIX_TIMESTAMP()+fair_end, fair_end=0
                WHERE s.fair=1 AND uid=OLD.id AND fair_end > 0;
        END IF;
    END IF;
$$
DELIMITER ;


DROP TRIGGER IF EXISTS `tr_fair_service_insert`;

DELIMITER $$
CREATE TRIGGER tr_fair_service_insert AFTER INSERT ON users_services
    FOR EACH ROW
    IF (SELECT 1 FROM services WHERE service_id=NEW.service_id AND fair=1) AND
       (SELECT 1 FROM users WHERE id=NEW.uid AND state='off')
    THEN
        UPDATE
            users_services u LEFT JOIN services s ON u.service_id = s.service_id
        SET fair_stop=UNIX_TIMESTAMP(), fair_end=tm_end-UNIX_TIMESTAMP(), tm_end=0
            WHERE id=NEW.id AND tm_end > 0 AND (tm_end - UNIX_TIMESTAMP()) > 5;
    END IF;
$$
DELIMITER ;