Installing error: "Specified key was too long; max key length is 1024 bytes" - Wikitech-l

26 Jun 2007

Hi.

I'm trying to install MediaWiki 1.10.0 on my server (PHP 5.2.2 + MySQL 4.1.22).

When creating tables I get this error message:

------------------
Generating configuration file...
# Database type: MySQL
# Loading class: DatabaseMysql
# Attempting to connect to database server as remoteuser...success.
# Connected to 4.1.22
# Database test_mediawiki_1_10 exists
# Creating tables...Query "CREATE TABLE `mediawiki_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, 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 1024 bytes
(mydbserver)".
------------------

I also tried with MediaWiki 1.6.10 and got the same error message:
-----------
# Database type: mysql
# Attempting to connect to database server as remoteuser...success.
# Connected to 4.1.22
# Database test_mediawiki_1_6 exists
# Creating tables... using MySQL 4 table defs...Query "CREATE TABLE
`mediawiki_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 1024 bytes (mydbserver)".
------------

'localhost' (Apache+PHP) is not the same server as 'mydbserver' (mySQL).
Any suggestion? Thank you very much.