[#44413] - Building Search index fails with Data too long for column 'route' at row 1
- New
- Medium
- Build: Medium
- # 44413
I updated a site with over 88000 articles. Some of them have very long aliases, close to 400
Steps to reproduce the issue
Go to Components, Smart Search, Index - click Index to run the indexing process
Expected result
Index is built completly
Actual result
Process fails with "Data too long for column 'route' at row 1" at some point
System information (as much as possible)
Joomla 5.2.0
PHP 8.2
MariaDB i guess it fail with postgresql too
Additional comments
A PR from me is on the way.
| Labels |
Removed:
?
|
||
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
|
||
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2024-11-05 15:19:29 |
| Closed_By | ⇒ | Quy |
| Status | Closed | ⇒ | New |
| Closed_Date | 2024-11-05 15:19:29 | ⇒ | |
| Closed_By | Quy | ⇒ |
I've the same error of original post.
I'm on:
- joomla 5.2.4
- php 8.3.17
- mysql 8.0.41
Running "php -d memory_limit=512M joomla.php finder:index" i've got "[ERROR] Data too long for column 'route' at row 1"
The only table that conatins "route" field is <db_name>_finder_links
Exectuting
"SELECT link_id, LENGTH(route) FROM zdb_name>_finder_links order by 2 DESC;"
i obtain:
'3216', '354'
This means that the greatest "route" content is 354 char while the maximum admitted is 400.
I'm confused.
Where i'm wrong?
See #43545 for the suggested fix.