search

cubecart / v6

CubeCart Version 6
https://cubecart.com
71 stars 59 forks source link

utf8mb4 failing on varchar(255) on `CubeCart_seo_urls` `path` column #3549

Closed abrookbanks closed 2 months ago

abrookbanks commented 3 months ago

Max length for index is 1000 which having a character length of 4 means its max size is 250.

4 x 250 = 1000

abrookbanks commented 3 months ago

This may be related to MySQL configuration because my development store (Server version: 8.0.34 / Database client version: libmysql - mysqlnd 7.4.33) doesn't complain with varchar(255).

abrookbanks commented 3 months ago

This begs the question if path should be primary key or the id column.