PR-6.3-dev Pending

User tests: Successful: Unsuccessful:

avatar MacJoom
MacJoom
6 Nov 2026

Replaces #48077.

  • 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

Changes #__finder_links.route to varchar(2048) so long SEF routes are no longer cut off when Smart Search indexes them.

  • Schema update 6.3.0-2026-11-06.sql for MySQL and PostgreSQL
  • installation/sql/{mysql,postgresql}/extensions.sql
  • administrator/components/com_finder/sql/install.{mysql,postgresql}.sql: these were still varchar(255) and are now aligned with the installation SQL

Testing Instructions

  1. On an existing 6.3 site, apply the patch and run System → Database → Fix. Check that #__finder_links.route is varchar(2048).
  2. Do a fresh install on MySQL and on PostgreSQL and check the column type.
  3. Index content with a route longer than 400 characters and check that it's stored in full.

Actual result BEFORE applying this Pull Request

Routes longer than the column size are truncated or fail to insert.

Expected result AFTER applying this Pull Request

Routes up to 2048 characters are stored correctly.

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

avatar MacJoom MacJoom - open - 6 Nov 2026
avatar MacJoom MacJoom - change - 6 Nov 2026
Status New ⇒ Pending
avatar joomla-cms-bot joomla-cms-bot - change - 6 Nov 2026
Category ⇒ SQL Administration com_admin Postgresql com_finder Installation
avatar HLeithner HLeithner - change - 6 Nov 2026
Status Pending ⇒ Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 ⇒ 2026-11-06 13:04:21
Closed_By ⇒ HLeithner
Labels Added: PR-6.3-dev
avatar HLeithner HLeithner - close - 6 Nov 2026
avatar HLeithner HLeithner - merge - 6 Nov 2026
avatar HLeithner
HLeithner - comment - 6 Nov 2026

Thanks, since this makes only the columns bigger, I don't expect problems and since the last prs aren't tested till now, I merge this without independent tests by code review.

Add a Comment

Login with GitHub to post a comment