Bug 180280 – www-apps/mediawiki - max key length is 1000 bytes w/ mysql

• Product: Gentoo Linux
• Status: RESOLVED DUPLICATE

[Description Alex Wait 2007-05-29 21:08:45 UTC]

A mysql build of:
---
www mediawiki # equery u mysql
[ Searching for packages matching mysql... ]
[ Colour Code : set unset ]
[ Legend : Left column  (U) - USE flags from make.conf              ]
[        : Right column (I) - USE flags packages was installed with ]
[ Found these USE variables for dev-db/mysql-5.0.40 ]
 U I
 + + berkdb      : Adds support for sys-libs/db (Berkeley DB for MySQL)
 - - big-tables  : Make tables contain up to 1.844E+19 rows
 - - cluster     : Add support for NDB clustering.
 - - debug       : Enable extra debug codepaths, like asserts and extra output. If you want to get meaningful backtraces see http://www.gentoo.org/proj/en/qa/backtraces.xml .
 - - embedded    : Build embedded server (libmysqld)
 - - extraengine : Add support for alternative storage engines.
 - - latin1      : Use LATIN1 encoding instead of UTF8.
 - - max-idx-128 : Raise the max index per table limit from 64 to 128
 - - minimal     : Install a very minimal build (disables, for example, plugins, fonts, most drivers, non-critical features)
 + + perl        : Adds support/bindings for the Perl language.
 - - selinux     : !!internal use only!! Security Enhanced Linux support, this must be set by the selinux profile or breakage will occur
 + + ssl         : Adds support for Secure Socket Layer connections
 - - static      : !!do not set this during bootstrap!! Causes binaries to be statically linked instead of dynamically
---
(result from equery) does not allow MediaWiki to install. I have talked with some mediawiki developers and they highly suspect it is a mysql configuraton error, probably from when it was "built". 

This is where my know-how (lol) ends. Any advice or testing on this would be super.
Error is below!

****
****
****
    *   Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list.

Checking environment...

Please include all of the lines below when reporting installation problems.

    * PHP 5.2.2-pl1-gentoo installed
    * Found database drivers for: MySQL
    * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
    * Have XML / Latin1-UTF-8 conversion support.
    * PHP's memory_limit is 128M. If this is too low, installation may fail!
    * Have zlib support; enabling output compression.
    * Couldn't find Turck MMCache, eAccelerator or APC. Object caching functions cannot be used.
    * Found GNU diff3: /usr/bin/diff3.
    * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
    * Found GD graphics library built-in.
    * Installation directory: /home/httpd/htdocs/mediawiki
    * Script URI path: /mediawiki
    * Environment checked. You can install MediaWiki.

      Generating configuration file...
    * Database type: MySQL
    * Loading class: DatabaseMysql
    * Attempting to connect to database server as root...success.
    * Connected to 5.0.38-log
    * Created database wiki
    * Creating tables... using MySQL 4 table defs...Query "CREATE TABLE `categorylinks` ( cl_from int(8) unsigned NOT NULL default '0', cl_to varchar(255) binary NOT NULL default '', cl_sortkey varchar(86) binary NOT NULL default '', cl_timestamp timestamp NOT NULL, UNIQUE KEY cl_from (cl_from,cl_to), KEY cl_sortkey (cl_to,cl_sortkey), KEY cl_timestamp (cl_to,cl_timestamp) ) TYPE=InnoDB " failed with error code "Specified key was too long; max key length is 1000 bytes (localhost)". 
****
****
****

Reproducible: Always

Steps to Reproduce:
1.Install mysql with USE flags above
2.Try to install mediawiki.
3. See Error.

[Comment 1 Jakub Moc (RETIRED) 2007-05-29 21:10:03 UTC]

This is _not_ a portage bug; read the descriptions please.

[Comment 2 Jakub Moc (RETIRED) 2007-05-29 21:10:57 UTC]

*** This bug has been marked as a duplicate of bug 109960 ***