Updates Requested PR-5.3-dev Pending

User tests: Successful: 0 Unsuccessful: 0

avatar janschoenherr
janschoenherr
3 Dec 2024

Currently, when saving an article, the core_created_user_id and core_created_by_alias fields are not updated in the corresponding entry in the #__ucm_content table.

Summary of Changes

Add both fields to the fields_mapping column in the #__content_types table for articles.

Testing Instructions

Change the author (Created By) of an article. Take a look at the corresponding entry in the #__ucm_content table.

Actual result BEFORE applying this Pull Request

core_created_user_id and core_created_by_alias are not updated.

Expected result AFTER applying this Pull Request

core_created_user_id and core_created_by_alias are updated.

Link to documentations

Please select:

  • Documentation link for docs.joomla.org:

  • No documentation changes for docs.joomla.org needed

  • Pull Request link for manual.joomla.org:

  • No documentation changes for manual.joomla.org needed

avatar janschoenherr janschoenherr - open - 3 Dec 2024
avatar janschoenherr janschoenherr - change - 3 Dec 2024
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 3 Dec 2024
Category SQL Installation Postgresql
avatar brianteeman
brianteeman - comment - 3 Dec 2024

Does this also need an update sql? Otherwise the changes will only be for new installs

avatar janschoenherr
janschoenherr - comment - 3 Dec 2024

You are probably right. I will check it out.

avatar janschoenherr janschoenherr - change - 3 Dec 2024
Labels Added: PR-5.3-dev
avatar joomla-cms-bot joomla-cms-bot - change - 3 Dec 2024
Category SQL Installation Postgresql SQL Administration com_admin Postgresql Installation
avatar janschoenherr
janschoenherr - comment - 3 Dec 2024

I added the update sql files. I am not sure about the postgresql syntax. Can someone confirm, that it works?

avatar fgsw fgsw - test_item - 4 Dec 2024 - Tested successfully
avatar richard67
richard67 - comment - 23 Jan 2025

@janschoenherr Could you rename your update SQL script? Currently they are named "5.3.0-2024-12-03.sql", but meanwhile we have something newer with "5.3.0-2024-12-19.sql" in the 5.3-dev branch, so your scripts should have a newer date than that, at least "5.3.0-2024-12-20.sql", but maybe better take the date of today and use "5.3.0-2025-01-23.sql".

Thanks in advance.

avatar janschoenherr
janschoenherr - comment - 23 Jan 2025

@janschoenherr Could you rename your update SQL script? Currently they are named "5.3.0-2024-12-03.sql", but meanwhile we have something newer with "5.3.0-2024-12-19.sql" in the 5.3-dev branch, so your scripts should have a newer date than that, at least "5.3.0-2024-12-20.sql", but maybe better take the date of today and use "5.3.0-2025-01-23.sql".

Thanks in advance.

avatar janschoenherr janschoenherr - change - 27 Jan 2025
Labels Added: Updates Requested

Add a Comment

Login with GitHub to post a comment