Pull Request resolves #47609.

• I read the Generative AI policy and my contribution is either not created with the help of AI or is compatible with the policy and GNU/GPL 2 or later.

Summary of Changes

This PR fixes storing UCM data when tags are assigned to articles.

When an article with tags is saved again, the existing #__ucm_content row is now updated instead of creating a duplicate row.

The PR also keeps #__ucm_base consistent with #__ucm_content. When tag data is removed and the related #__ucm_content row is deleted, the matching #__ucm_base row is removed too. This prevents a stale #__ucm_base row from pointing to a deleted #__ucm_content row and breaking tag assignment when the same tag is added again later.

Testing Instructions

1. Create a new article.
2. Assign a tag to the article.
3. Save the article.
4. Check the database tables #__ucm_content, #__ucm_base, and #__contentitem_tag_map.
5. Save the article again without changes.
6. Check that no duplicate row is created in #__ucm_content.
7. Edit the article and remove the tag.
8. Save the article.
9. Check that the tag mapping is removed and that no stale #__ucm_base row remains for the deleted #__ucm_content row.
10. Edit the article again and assign the same tag.
11. Save the article.
12. Check that the tag is saved correctly.

Actual result BEFORE applying this Pull Request

Saving an article with tags again creates duplicate rows in #__ucm_content.

After removing a tag, the #__ucm_content row is deleted but the related #__ucm_base row can remain. When assigning the same tag again, the article is saved but the tag assignment silently fails.

Expected result AFTER applying this Pull Request

Saving an article with tags again updates the existing #__ucm_content row and does not create duplicates.

When tags are removed, the related UCM rows remain consistent. Assigning the same tag again works correctly.

Link to documentations

Please select:

• Documentation link for guide.joomla.org:

• No documentation changes for guide.joomla.org needed

• Pull Request link for manual.joomla.org:

• No documentation changes for manual.joomla.org needed