Добрый день. При обновлении по инструкции на 7 шаге, обновлении скриптами, появляется ошибка при обновлении скриптом "patch-object-status_ru_RU.sql" из папки "2.4.2-2.4.3 georitm"
Текст ошибки:
Текст ошибки:
| Код |
|---|
| [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into tmp_roles (sel ect distinct auth_role_id fr om auth_roles_actions w' at line 1
[Err] insert into tmp_roles (sel ect distinct auth_role_id fr om auth_roles_actions where auth_action_id = (sel ect id fr om auth_actions where auth_action_code = 'objects.edit')); [Err] 1146 - Table 'georitm.tmp_roles' doesn't exist [Err] insert into auth_roles_actions (auth_role_id, auth_action_id) (select distinct tr.id, aa.id fr om auth_actions aa, tmp_roles tr wh ere aa.auth_action_code in ( 'objects.status.edit' )); dr op table tmp_roles; -- -- CRE ATE TABLE object_status ( object_id INT NOT NULL, status INT DEFAULT 0 NOT NULL, prev_status INT, service_ts DATETIME, PRIMARY KEY (object_id) ); -- -- insert into object_status (object_id, status, prev_status, service_ts) ( select id, 1, null, null fr om objects ) ; upd ate object_status inner join object_settings se t object_status.status = 0 wh ere ( object_settings.object_id = object_status.object_id and object_settings.settings_key = 'IS_ACTIVE' and object_settings.value = '0' ); [Msg] Finished - Unsuccessfully -------------------------------------------------- |