search

joomla / joomla-cms

Home of the Joomla! Content Management System
https://www.joomla.org
GNU General Public License v2.0
4.77k stars 3.65k forks source link

Building Search index fails with Data too long for column 'route' at row 1 #44413

Open MacJoom opened 2 weeks ago

MacJoom commented 2 weeks ago

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.

Quy commented 2 weeks ago

See #43545 for the suggested fix.

Quy commented 2 weeks ago

Closing as duplicate of #43545