No Code Attached Yet
avatar Serge-45
Serge-45
19 Sep 2025

Steps to reproduce the issue

  1. create an article with no publish down date => index in SmartSearch is OK
  2. add a publish down date in the article => index in SmartSearch is updated with this date
  3. remove the publish down date in the article => index in SmartSearch still considers the previous publish down date

Expected result

The article should be indexed with no end date, and it should appear in the search requests.

Actual result

The index still has the previous end date, when this date is in the past, the article is not displayed in the search requests.

System information (as much as possible)

Currently running Joomla 5.3.3 with PHP 8.3.25, but this issue may have appeared before.
In #_finder_links, the publish_end_date contains the previous end date instead of NULL.

Additional comments

Rebuilding the index does not solve, I had to first clear the index (Maintenance > Clear Index) and then launch the indexing.

avatar Serge-45 Serge-45 - open - 19 Sep 2025
avatar joomla-cms-bot joomla-cms-bot - change - 19 Sep 2025
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 19 Sep 2025
avatar kartikeyg0104
kartikeyg0104 - comment - 19 Sep 2025

Sir, I am really interested to work on this issue, could you please assign me this issue?

avatar alikon
alikon - comment - 19 Sep 2025

we don't assign issue you can simply submit a pull request

avatar kartikeyg0104
kartikeyg0104 - comment - 19 Sep 2025

Okay sir

avatar kartikeyg0104
kartikeyg0104 - comment - 19 Sep 2025

Sir, I have raised the pull request(#46129), Can you plz once review it?

avatar Serge-45
Serge-45 - comment - 19 Sep 2025

If I may try to help : there is an optional parameter to $db->updateObject() related to update of Null fields. This parameter is not set in the call made in administrator/components/com_finder/src/Indexer/Indexer.php. This could maybe explain what happens ?

avatar kartikeyg0104
kartikeyg0104 - comment - 19 Sep 2025

Thank you for pointing this out! I will try to fix it out.

avatar kartikeyg0104
kartikeyg0104 - comment - 19 Sep 2025

I have raised the pull request(#46130) again. Plz once go through it.

avatar alikon alikon - change - 20 Sep 2025
Status New Closed
Closed_Date 0000-00-00 00:00:00 2025-09-20 06:14:07
Closed_By alikon
avatar alikon alikon - close - 20 Sep 2025
avatar alikon
alikon - comment - 20 Sep 2025

please test #46130

Add a Comment

Login with GitHub to post a comment