-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160
... Specified key was too long. Max key length is 500
This is a MySQL bug related to the way indexes counts bytes and not characters. This in turn is because MySQL has a limitation on the number of total bytes one can use in an index. For more information, see:
http://bugzilla.wikimedia.org/show_bug.cgi?id=1322
Any suggestions?
There are four things you can do, in order of ease:
1) Change the index definitions (see the bug above for examples) 2) Don't use UTF-8. 3) Use Postgres 4) Recompile a custom MySQL with a larger limit
- -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200703211008 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8