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

You are probably right. I will check it out.

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

@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.

@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.

✅

Prebuilt packages are not available for download.

Something wrong in prebuilt packages:

As a user I'd like to leave a small comment: this feature is needed for correct using Tags layout in Yootheme Pro page builder. E.g. there is a menu item 'Compact list of tagged items' and it would be very useful to display a name of a user assigned to the article as the author despite the fact the original content was created by admin.

Here is what we can get on blog category page using user fields (avatar):

There are different authors assigned to the articles and their avatars.

And here is what we get on tagged items page:

There is the only original author who created the articles.

This PR could help in such situation for many users and I hope this PR will be noticed someday and accepted.
Thanks for attention.

@Sulpher I've updated this PR so it is ready for testing again. If you want to bring it forward, please test it and submit the test result in the issue tracker here by using the blue "Text this" button at the top-left corner.

A test should be to make a new installation with this PR to see if the changes in the base.sql are right, and another test should be made to update an existing 5.3.x to the patched package created by Drone for this PR to see if the update SQL script is run and has no errors.

Thanks in advance.

P.S. It might come too late for the upcoming 5.3.3 as this is already in preparation, but it still makes sense to bring it forward so it can go into 5.3.4.

@janschoenherr I've allowed myself to update the branch of this PR so new packages are created by Drone for testers, rename the update SQL scripts so that they run when updating from a current 5.3.x, and add instructions for new installation and update to the testing instructions. So the PR is ready for testing. Let's hope we find testers. Thanks a lot for your patience.

I have tested this item ✅ successfully on 83b58e4

i've got this working!

thank you @janschoenherr and everyone progressing the advancement of this!

Can somebody tell me how can I download the patched files (or an installable package with the patched files) so that I can test it on a fresh install ? Would like to help test on this, but did not try this on the pbf.

Can somebody tell me how can I download the patched files (or an installable package with the patched files) so that I can test it on a fresh install ? Would like to help test on this, but did not try this on the pbf.

@rbuelund https://artifacts.joomla.org/drone/joomla/joomla-cms/5.3-dev/44571/downloads/87384/

Hmmm - what am I doing wron here. I installed the Joomla_5.3.4-dev+pr.44571-Development-Full_Package.zip - created another user, and created an article. looked in the ucm_content table - empty ? Changed "Created by" of the article - ucm_content still empty ? Is there missing something in the test instructions ?

@richard67 This needs to be adjusted again so that we use the correct SQL file, then I would also like to have it in 5.3. Thanks for your help.

@richard67 This needs to be adjusted again so that we use the correct SQL file, then I would also like to have it in 5.3. Thanks for your help.

@tecpromotion The date part would be ok, but the version part is of course wrong. Will fix it in a minute or two.

@richard67, thank you very much for your fix. You made this and asked me to test, but I do not know how to test these changes.
You mentioned a link: https://artifacts.joomla.org/drone/joomla/joomla-cms/5.3-dev/44571/downloads/87384/
but it gives 404 error.

@tecpromotion Done.

@richard67, thank you very much for your fix. You made this and asked me to test, but I do not know how to test these changes. You mentioned a link: https://artifacts.joomla.org/drone/joomla/joomla-cms/5.3-dev/44571/downloads/87384/ but it gives 404 error.

@Sulpher The download link can be found at the bottom of the PR in the CI checks. It changes with every new build (branch update). After some time old downloads are deleted that's why you got the 404. The current link now after I have triggered a new build is https://artifacts.joomla.org/drone/joomla/joomla-cms/5.3-dev/44571/downloads/88090/ .

There you can find a download links to installation and update zip packages and a custom URL for using as custom update source in the Joomla Update component.

You can either make a new installation with the installation package, or (better because this would also test the SQL update) update a 5.3.3 (testing site) to this PR by either using the custom update URL for live update or the update package for upload & update and then test the PR.

@richard67 thank you very much for the explanation and link. I've downloaded version 5.3.4-dev+pr.44571 you've gave a link to and reproduced the task. All works fine now!

Apart from Admin (Joomla alias) there are Venus and Earth - names of other users whom the articles were assigned to while the article was created by Admin.

I'm confirming the patch works now. Thank you!

@Sulpher Please go to the issue tracker here https://issues.joomla.org/tracker/joomla-cms/44571 and mark your test result by using the blue "Test this" button at the top left corner, selecting your test result (success) and finally using the submit button. Thanks in advance.

I have tested this item ✅ successfully on fee6cfa

@Sulpher Please go to the issue tracker here https://issues.joomla.org/tracker/joomla-cms/44571 and mark your test result by using the blue "Test this" button at the top left corner, selecting your test result (success) and finally using the submit button. Thanks in advance.

Done.
@richard67, thank you for giving a hand with the issue testing.

@Sulpher Please go to the issue tracker here https://issues.joomla.org/tracker/joomla-cms/44571 and mark your test result by using the blue "Test this" button at the top left corner, selecting your test result (success) and finally using the submit button. Thanks in advance.

Done.
Richard, thank you for giving a hand with the issue testing.

RTC

Thank you @janschoenherr for the fix and also for testing and and the great support @richard67 @Sulpher @SumCompanyInc @tecpromotion @rbuelund @brianteeman