-----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(a)turnstep.com
PGP Key: 0x14964AC8 200703211008
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFGATynvJuQZxSWSsgRA0bnAJ9FpMAV+VED+EccARlLy+AJuGAElQCbBtZp
lpDX8MR3hajKwceaqBEmx+w=
=KUGG
-----END PGP SIGNATURE-----