[Mediawiki-l] Specified key was too long. Max key length is 500 (localhost)

Fri Apr 28 15:30:54 UTC 2006

SUSE SLES 9 installation. Everything else went fine, but I am stopped here.

Any suggestions?

-- 
Terry Poperszky
Network Manager
SOS Staffing Services
801-257-5709

    * PHP 4.3.4 installed
    * 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.
    * Neither Turck MMCache nor eAccelerator are installed, can't use
object caching functions
    * Found GNU diff3: /usr/bin/diff3.
    * Found GD graphics library built-in, image thumbnailing will be
enabled if you enable uploads.
    * Installation directory: /srv/www/htdocs/mediawiki-1.6.3
    * Script URI path: /mediawiki-1.6.3
    * Environment checked. You can install MediaWiki.

      Generating configuration file...
    * Database type: mysql
    * PHP is linked with old MySQL client libraries. If you are using a
MySQL 4.1 server and have problems connecting to the database, see
http://dev.mysql.com/doc/mysql/en/old-client.html for help.
    * Attempting to connect to database server as root...success.
    * Connected to 4.0.18
    * Database wikidb exists
    * There are already MediaWiki tables in this database. Checking if
updates are needed...
    * Granting user permissions...

      ...hitcounter table already exists.
      ...querycache table already exists.
      ...objectcache table already exists.
      ...categorylinks table already exists.
      ...logging table already exists.
      ...validate table already exists.
      ...user_newtalk table already exists.
      ...transcache table already exists.
      ...trackbacks table already exists.
      ...externallinks table already exists.
      Creating job table...Query "CREATE TABLE `job` (
       job_id int(9) unsigned NOT NULL auto_increment,
       job_cmd varchar(255) NOT NULL default '',
       job_namespace int NOT NULL,
       job_title varchar(255) binary NOT NULL,
       job_params blob NOT NULL default '',
       PRIMARY KEY job_id (job_id),
       KEY (job_cmd, job_namespace, job_title)
       ) TYPE=InnoDB
      " failed with error code "Specified key was too long. Max key
length is 500 (localhost)".