MySQL bug

Jonathan Daugherty cygnus at janrain.com
Wed Aug 22 09:48:33 PDT 2007


# On my MySQL5 the indexes cannot be longer than 1000 bytes, than
# using utf8 I've modified in storage.php the init function, forcing
# indexing by UNIQUE (account(25), url(300)))

Hello,

Unfortunately this problem affects quite a few versions of MySQL and
the index size limit varies, so the workaround varies, too.  It would
be better to upgrade to a version of MySQL with a fix; it's important
that the unique index cover the entire (account, url) value.

Thanks!

-- 
  Jonathan Daugherty
  JanRain, Inc.
  irc.freenode.net: cygnus in #openid
  cygnus.myopenid.com



More information about the Dev mailing list