Joomla! Issue Tracker | Joomla! CMS #48144 - [5.4] smart search indexer with posgresql

Unit/System Tests PR-5.4-dev

Pending
Medium
Build: 5.4-dev
# 48144
Diff
alikon:patch-4

Pending

User tests: Successful: Unsuccessful:

alikon
24 Jul 2026

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

joomla-cms/tests/System/integration/administrator/components/com_finder/Index.cy.js

Line 27 in 042670b

cy.get('#toolbar-index > button').click();

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();