phiro Posted June 26, 2017 Share Posted June 26, 2017 Hi, it seems that processwire creates two table-indexes for each used multilanguage field. I am building a small website in 37 langues. In this case there are more then 64 indexes, which ist the default limit of mysql (ERROR 1069 (42000): Too many keys specified; max 64 keys allowed). Any idea how to solve this on site of processwire (without recompiling mysql)? Many thanks, Philipp Link to comment Share on other sites More sharing options...
BitPoet Posted June 29, 2017 Share Posted June 29, 2017 To my knowledge, recompiling is the only way, since the index count limit depends on the storage engine itself, not the row format used (unlike index length / column count). Even then it's only possible to double the number of languages - though 64 languages is quite a lot. There might be a MySQL compatible database system without that limitation. I haven't found a list of limitations of Amazon Aurora yet, but it might be worth checking out where its limitations are. 1 Link to comment Share on other sites More sharing options...
Kemal Posted July 22, 2017 Share Posted July 22, 2017 Any solution for this i am also getting same error SQLSTATE[42000]: Syntax error or access violation: 1069 Too many keys specified; max 64 keys allowed my web site have 32 language. I contact with host about upgrade the limit but i still waiting. Is there any thing i can do? What is the limitation of the language number for this? Link to comment Share on other sites More sharing options...
psy Posted December 13, 2022 Share Posted December 13, 2022 Bump My site has 17 languages and I'm getting this error too when adding a new language Link to comment Share on other sites More sharing options...
bernhard Posted December 13, 2022 Share Posted December 13, 2022 https://github.com/processwire/processwire-issues/issues/1633 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now