Feeling Lucky
[#48077] - [6.2] Use text column for finder routes
- Pending
- Medium
- Build: 6.2-dev
- # 48077
- Diff
- MacJoom:5.2-dev
User tests: Successful: Unsuccessful:
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.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | SQL Administration com_admin Postgresql Installation |
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.
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.