Error on translations:find

[PhilCCMG]

Whenever I run translations:find, I get a SQL error (w/ artisan)

https://i.imgur.com/S9CoeeS.png

[vsch]

@clyv, I suspect it is related to the local/group/key columns having case insensitive collation so the index is built and validated ignoring the case of these columns. If any one of them, most likely the key column has duplicates when ignoring case then this would happen.

I searched for an issue with a fix I saw but could not find it. All I found was a link to https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html

If you can change the collation to case sensitive on these columns I think it will fix the problem.