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

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.