CoreFiles by mySites.guru
4.0.0-2021-08-13.sql16 lines, 914 bytes, from Joomla_4.4.13-Stable-Full_Package.zip
Raw History Compare with 4.4.12
md5
413cabf01e73bb129fc0d43fd18c735c
sha1
a7b0228a66c2c6f5d70e774d9fa75593fc0380d4
sha256
287c99aeccdc838cbaafcab76ae98aeafe7c86fec767516bea96287e2222e3b2
--
-- 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';

The same content is in 118 releases, Joomla 4.0.0 to 4.4.14. See them all, or every version of this file.