using pathauto, with multilingual content url get too big...
e.g.
in my site's greek version

http://www.evia-guide.gr/el/places/παραλίες-της-εύβοιας.html
is translated to
http://www.evia-guide.gr/el/places/%CF%80%CE%B1%CF%81%CE%B1%CE%BB%CE%AF%...

because every utf8 letter in represented with 3letters (%XX)

so many of the urls cannot fit int the table and result in broken links...
http://www.evia-guide.gr/sitemap.xml

the solution for me is obvious...
increase 'loc' size
maybe double it from 128 to 256

i just wanted to know if this change affects something else...

thanks in advance

Comments

Anonymous’s picture

Anonymous (not verified) commented

Got the same problem. Changed the 'loc'-size in the database table sitemap to 256 and it works.

I think, the standard 128 is definetly too small.

Thanks!

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: Table xmlsitemap -> loc size is small » Table field is too small
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Component: xmlsitemap » Other
Assigned: Unassigned » avpaderno

The problem of the loc field size is present in more tables.
I will check about that.

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented

The 128-character size was based on the url_alias table. However, url_alias stores relative URLs while we store absolute URLs, so we need to increase the size.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Active » Fixed

The problem of the field size was present just in one table.
The issue has been fixed; the fix has been ported to 6.x-1.x-dev.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.