[Mediawiki-l] SQL error..

[debbie_kennedy at bellsouth.net]

PLEASE TAKE ME OFF YOUR MAILING LIST   debbie_kennedy at bellsouth.net
> 
> From: "Thomas, Arjun" <Arjun.Thomas at ps.net>
> Date: 2007/04/17 Tue AM 04:01:51 EST
> To: "MediaWiki announcements and site admin list"
> 	<mediawiki-l at lists.wikimedia.org>
> Subject: Re: [Mediawiki-l] SQL error..
> 
> Was planning on trying with 5.0 to see if this issue resolves itself..
> currently using 4.1 
> 
> - AJ
> 
> -----Original Message-----
> From: mediawiki-l-bounces at lists.wikimedia.org
> [mailto:mediawiki-l-bounces at lists.wikimedia.org] On Behalf Of Domas
> Mituzas
> Sent: Tuesday, April 17, 2007 2:22 PM
> To: MediaWiki announcements and site admin list
> Subject: Re: [Mediawiki-l] SQL error..
> 
> 
> > MySQL has a bug in which it counts bytes, not characters, when
> > calculating the key length.
> 
> Computers have a _bug_ too, where they count bytes, not characters,  
> well... everywhere.
> 
> > Thus, something that works fine in
> > a single-byte-per-character character set suddenly fails when you
> > switch to a multi-byte character set such as utf-8.
> 
> The limit doesn't exist with new MySQL versions in MyISAM and old  
> versions in InnoDB.
> If you're getting that error, there's huge chance you have InnoDB  
> disabled.
> 
> > One solution (besides abandoning utf-8 or MySQL) is to redefine the
> > index in question to use smaller values. A quick google search found
> > this example:
> 
> Or use InnoDB. Or use fresh MySQL version.
> 
> -- 
> Domas Mituzas -- http://dammit.lt/ -- [[user:midom]]
> 
> 
> 
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> 
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> 

DEBBIE KENNEDY-IH SERVICES #61