[#48144] - [5.4] smart search indexer with posgresql
- Fixed in Code Base
- 30 Aug 2026
- Medium
- Build: 5.4-dev
- # 48144
- Diff
- alikon:patch-4
User tests: Successful: Unsuccessful:
Pull Request resolves # .
- 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
fix the update for postgres
While MySQL passively accepts table aliases in SET clauses (SET t.links = ...), PostgreSQL follows strict ANSI SQL syntax, requiring the column name in SET to be unqualified.
Testing Instructions
index some content with postgresql
Actual result BEFORE applying this Pull Request
error
Expected result AFTER applying this Pull Request
index complete successfully
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
Note for Release Managers
if this pr will be merged for 5.4 pay attention before to upmerge to 6.x cause the Index button has been changed meanwhile, so this line
should be changed with something like
cy.get('#toolbar-indexing-group > button').click();
// Click the "Index" button
cy.get('#indexing-group-children-index > button', { force: true }).click();| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration com_finder |
| Labels |
Added:
PR-5.4-dev
|
||
| Category | Administration com_finder | ⇒ | Administration com_finder JavaScript Unit Tests |
| Labels |
Added:
Unit/System Tests
|
||
I have tested this item ✅ successfully on e04a257
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
Confirmed the bug when indexing using Joomla with postgres
Verified that the PR resolves the bug with postgres
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
Confirmed the bug when indexing using Joomla with postgres
Verified that the PR resolves the bug with postgres
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
I have tested this item ✅ successfully on e04a257
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
I have tested this item ✅ successfully on e04a257
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
| Labels |
Added:
RTC
bug
|
||
I have tested this item ✅ successfully on 2ec922d
Final test before merging: I've verified the issue and tested the fix on PostgreSQL, and I've also verified that nothing changes for MySQL.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
I have tested this item ✅ successfully on 2ec922d
Final test before merging: I've verified the issue and tested the fix on PostgreSQL, and I've also verified that nothing changes for MySQL.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2026-08-30 15:13:29 |
| Closed_By | ⇒ | richard67 |
Thanks @alikon for this PR, @laoneo for review, @brianteeman and @CSGoat0 for testing.
I have tested this item ✅ successfully on e04a257
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48144.