[#46395] - [5.4] Update NULLs in Smart Search links
- Fixed in Code Base
- 6 Nov 2025
- Medium
- Build: 5.4-dev
- # 46395
- Diff
- Denitz:patch-26
User tests: Successful: Unsuccessful:
Pull Request for Issue #46260 .
Summary of Changes
Indexed link columns are no updated with NULLs, hence i.e. publish_end_date is not updated to NULL once it's cleared in article.
Testing Instructions
- Create an article, add a unique word and let Smart Search index it.
- Use the smart search and check the article is being found
- Add a finish publish date to the article which is before today
- Use the smart search again and confirm the article is not shown in the results anymore
- Edit the article and clear the finish publish date, article is published in frontend again
- Use the smart search again, the article is still not shown in the results
Actual result BEFORE applying this Pull Request
Step 6) Smart search does not update the finish publish date
Expected result AFTER applying this Pull Request
Step 6) Smart search should update the finish publish date and show the result again
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
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration com_finder |
Hi @Denitz, I appreciate that Smart Search works great. However, what can I be doing wrong?
I create an article with 3-4 paragraphs, I go to Smart Search and press Index, it shows the article being indexed. Then I go to the front end and type in one of the 4 words I included and none of them appear... (and I had checked that all of the SmartSearch plugins are enabled) - on a Nightly 5.4.1-dev with just Joomla Patch Tester and Blog Sample Data installed on it... then noticing it didn't show any search results, I deleted the entire Index and asked it to re-index everything and searched again with no results?
Sorry, it just means that smart search is not working, it's another issue. If you see article in index, try to search by article title.
OK, I searched by Article title and then by those specific words and it's finding them :/ weird but good that's its working again. Thanks. I'll go test your PR now.
I have tested this item ✅ successfully on 685b0bf
I was able to test this PR successfully - thanks @Denitz for your help and the PR/code.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/46395.
I have tested this item ✅ successfully on 685b0bf
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/46395.
| Status | Pending | ⇒ | Ready to Commit |
| Labels |
Added:
bug
PR-5.4-dev
|
||
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/46395.
thank you <3
✅ Final test before merge with JBT, seen the problem before, graft this PR's full package and deleted-finish-date article is now found
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2025-11-06 04:52:13 |
| Closed_By | ⇒ | muhme | |
| Labels |
Added:
RTC
|
||
@Denitz Testing your PR on currently installed Joomla! version is "5.4.1-dev" and I am unable to find the unique word in Step 2 above in Smart Search -- actuator and acquiesce even though they are indeed in the article in the Frontend... so I can't test your PR :/