See http://bugzilla.wikimedia.org/show_bug.cgi?id=1322.
On 6/26/07, thomas Armstrong tarmstrong@gmail.com wrote:
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.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l