Key when trying to use MySQL was too long; max key length is 3072 bytes

querqy / smui

Search Management UI

Apache License 2.0

52 stars 24 forks source link

Key when trying to use MySQL was too long; max key length is 3072 bytes #130

Open OkkeKlein opened 1 year ago

OkkeKlein commented 1 year ago

p.a.d.e.DefaultEvolutionsApi - Specified key was too long; max key length is 3072 bytes [ERROR:1071, SQLSTATE:42000]

epugh commented 1 year ago

So, this I believe happens on Mysql8, but not on ancient mysql 5.6.. I discovered this when I updated Chorus, as Quepid wants mysql 8 these days.. Can you confirm you are using mysql 8?

epugh commented 4 months ago

For reference: https://poe.com/s/JaFBXbezjpckaVouHz9B