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

The target table v_services of the UPDATE is not updatable 

{
  'sql' => 'UPDATE v_services SET tags=CONCAT(tags,\',end_now,\') WHERE price>0 AND uid=?',
  'param' => [
    570
  ]
};
 
 UPDATE v_services SET tags=CONCAT(tags,',end_now,') WHERE price>0 AND uid='570'

DROP VIEW IF EXISTS v_services;
CREATE ALGORITHM= UNDEFINED VIEW v_services AS
    SELECT u.*, s.module, s.category, s.title, s.description, s.plain_description,
        s.grp_list, s.price, s.auto_renew, s.no_renew, s.param 
    FROM users_services u LEFT JOIN services s ON u.service_id = s.service_id;

SELECT `TABLE_SCHEMA`, `TABLE_NAME`, `IS_UPDATABLE` FROM `views` WHERE `TABLE_NAME` LIKE 'v_services';

UPDATE users_services u INNER JOIN services s ON (u.service_id = s.service_id) SET u.tags=CONCAT(u.tags,',end_now,') WHERE s.price>0 AND u.uid = ?

UPDATE users_services u INNER JOIN services s ON (u.service_id = s.service_id) SET u.tags=CONCAT(u.tags,',end_now,'), u.next_service_id=0 WHERE s.price>0 AND u.uid = ?