Файловый менеджер

Файловый менеджер - Редактировать - /home/harasnat/www/solequestre/administrator/components/com_admin/sql/updates/postgresql/4.0.0-2021-08-13.sql

Назад
-- -- Fix wrong asset name for com_content basic workflow stage if a new asset with the right -- name hasn't been created yet when saving the workflow stage in backend in past. -- UPDATE "#__assets" SET "name" = 'com_content.stage.1' WHERE "name" = 'com_content.state.1' AND (SELECT c."count" FROM (SELECT COUNT(b."id") AS "count" FROM "#__assets" b WHERE b."name" = 'com_content.stage.1') AS c) = 0; -- -- Fix wrong asset titles for workflow transitions -- UPDATE "#__assets" SET "title" = 'Unpublish' WHERE "name" = 'com_content.transition.1' AND "title" = 'Publish'; UPDATE "#__assets" SET "title" = 'Publish' WHERE "name" = 'com_content.transition.2' AND "title" = 'Unpublish'; UPDATE "#__assets" SET "title" = 'Trash' WHERE "name" = 'com_content.transition.3' AND "title" = 'Archive'; UPDATE "#__assets" SET "title" = 'Archive' WHERE "name" = 'com_content.transition.4' AND "title" = 'Trash';

| ver. 1.4 | Github | .