[5.2] com_finder: Duplicate Entries in #__finder_taxonomy After Update And Re-Index

[dautrich]

Steps to reproduce the issue

1. Set up a Joomla 5.1.4 site (preferably a copy of a site with many articles in quite a number of categories and subcategories).

2. Go to Smart Search and build (or re-build) the index.

3. Check Smart Search - Component Maps (preferably filtering only level 1).

4. Update to Joomla 5.2.0.

5. Check Smart Search - Component Maps (preferably filtering only level 1).

6. Go to Smart Search and re-build the index.

7. Check Smart Search - Component Maps.

Expected result

The components map should look like in the image above.

Actual result

There are duplicate entries on level 1:

The entries on level 2 are not duplicated, as can be seen here:

System information (as much as possible)

systeminfo-2024-10-17T08_53_00+00_00.txt systeminfo-2024-10-17T08_53_17+00_00.json SQL_Dumps_Before_And_After.zip

Additional comments

I have seen this issue on at least one additional site. Removing the duplicate (and unused) entries seems to have no negative impact.

[dautrich]

Additional Comment: After clearing the index and re-indexing, the result seems to be okay again. Content Maps look as expected.

[Hackwar]

The problem is the language column of the table. Starting with 5.2.0, the default value is * instead of being empty and that results in the current problem. PR responsible for this: https://github.com/joomla/joomla-cms/pull/43990

[Hackwar]

Sorry, didn't want to close the issue. Clicked by accident.