File manager - Edit - /home/opticamezl/www/newok/administrator/components/com_admin/sql/updates/postgresql/4.0.0-2021-08-13.sql
Back
-- -- 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
|
.
| PHP 8.3.23 | Generation time: 0 |
proxy
|
phpinfo
|
Settings