Feature PR-6.2-dev PR-6.3-dev Pending

User tests: Successful: Unsuccessful:

avatar MacJoom
MacJoom
10 Jul 2026

Summary of Changes

Change the Smart Search #__finder_links.route column from varchar(400) to ext for MySQL and PostgreSQL.

This prevents Smart Search indexing from failing when generated routes exceed the previous 400 character limit.

Supersedes #44414.

Testing Instructions

Use a site with article aliases close to 400 characters and run the Smart Search indexing process from Components, Smart Search, Index.

Actual result BEFORE applying this Pull Request

The indexing process can fail with a database error similar to Data too long for column 'route' at row 1.

Expected result AFTER applying this Pull Request

The index is built without failing because of long route values.

Link to documentations

No documentation changes needed.

avatar MacJoom MacJoom - open - 10 Jul 2026
avatar MacJoom MacJoom - change - 10 Jul 2026
Status New ⇒ Pending
avatar joomla-cms-bot joomla-cms-bot - change - 10 Jul 2026
Category ⇒ SQL Administration com_admin Postgresql Installation
avatar MacJoom MacJoom - change - 10 Jul 2026
The description was changed
avatar MacJoom MacJoom - edited - 10 Jul 2026
avatar brianteeman brianteeman - test_item - 13 Jul 2026 - Tested successfully
avatar brianteeman
brianteeman - comment - 13 Jul 2026

I have tested this item ✅ successfully on 07dca15


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48077.

avatar brianteeman
brianteeman - comment - 13 Jul 2026

I have tested this item ✅ successfully on 07dca15


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48077.

avatar Hackwar
Hackwar - comment - 17 Aug 2026

I'm not really happy with this change. The consensus is that the safe maximum number of characters in a URL is 2048. A normal non-SEF Joomla URL should not be more than maybe 100 characters and maybe there are situations where we could turn a blind eye to 200 or even 300 characters, but non-SEF URLs with more than 400 characters are simply a sign of a broken architecture. I don't want to support that to be honest.

avatar crimle crimle - test_item - 22 Aug 2026 - Tested unsuccessfully
avatar crimle
crimle - comment - 22 Aug 2026

I have tested this item 🔴 unsuccessfully on 07dca15

The length of an article alias was limited to 344 characters during my tests.
The indexing process would not fail even if the PR was not yet applied.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48077.

avatar crimle
crimle - comment - 22 Aug 2026

I have tested this item 🔴 unsuccessfully on 07dca15

The length of an article alias was limited to 344 characters during my tests.
The indexing process would not fail even if the PR was not yet applied.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/48077.

avatar HLeithner
HLeithner - comment - 23 Aug 2026

"Text" columns are saved physically on another location and makes the query slower, so I would extend the varchar in this case.

avatar HLeithner
HLeithner - comment - 23 Aug 2026

better change the field to 2048 and hope that nobody finds out that get requests doesn't have a length limit.

avatar Hackwar
Hackwar - comment - 23 Aug 2026

com_finder also has its install SQL in the component folder and thus that would have to be adapted as well. Again, I don't think changing this field is a good idea and instead the affected components should change their routing, but it isn't the hill I'm going to die on.

avatar HLeithner HLeithner - change - 6 Nov 2026
Labels Added: Feature PR-6.2-dev
avatar MacJoom MacJoom - close - 6 Nov 2026
avatar MacJoom MacJoom - change - 6 Nov 2026
Status Pending ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2026-11-06 10:23:57
Closed_By ⇒ MacJoom
Labels Added: PR-6.3-dev
avatar MacJoom MacJoom - change - 6 Nov 2026
Status Closed ⇒ New
Closed_Date 2026-11-06 10:23:57 ⇒
Closed_By MacJoom ⇒
avatar MacJoom MacJoom - change - 6 Nov 2026
Status New ⇒ Pending
avatar MacJoom MacJoom - reopen - 6 Nov 2026
avatar Hackwar
Hackwar - comment - 6 Nov 2026

I still think that it is a mistake to blow up this column. A text column would be way to much for something that shouldn't be more than 250 characters and in reality shouldn't be more than probably 50 or 80 characters. Lets not support broken architectures.

avatar brianteeman
brianteeman - comment - 6 Nov 2026

I still think that it is a mistake to blow up this column. A text column would be way to much for something that shouldn't be more than 250 characters and in reality shouldn't be more than probably 50 or 80 characters. Lets not support broken architectures.

its now varchar(2048)

avatar MacJoom MacJoom - change - 6 Nov 2026
Status Pending ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2026-11-06 11:37:26
Closed_By ⇒ MacJoom
avatar MacJoom MacJoom - close - 6 Nov 2026
avatar MacJoom
MacJoom - comment - 6 Nov 2026

I still think that it is a mistake to blow up this column. A text column would be way to much for something that shouldn't be more than 250 characters and in reality shouldn't be more than probably 50 or 80 characters. Lets not support broken architectures.

I still have a webseite with blown up aliases that fails the reindex because of the route field beeing too short. I changed this manually to text - with no issues. I don't need this PR for my website - but i can imagine other have this problem too.
So either fix the architecture or accept this bandaid.

avatar brianteeman
brianteeman - comment - 6 Nov 2026

i am in favour of varchar(2048)

Add a Comment

Login with GitHub to post a comment