wiki问题解决途径

奶奶的..累死了...老问题仍在继续..
但是google的结果却在刷新...
再一次感谢google...

说下偶的情况：

安装错误信息：
” failed with error code “Specified key was too long; max key length is 1024 bytes (localhost)”.

官网的修改方法不管用...尤其是一个job文件，根本找不到要修改的数字。

所以开始google...

尝试了：

Fix

[edit]

open file: tables.sql

Search for:

CODE

CREATE TABLE /*$wgDBprefix*/job (
job_id int(9) unsigned NOT NULL auto_increment,

-- Command name, currently only refreshLinks is defined
job_cmd varchar(255) NOT NULL default '',

-- Namespace and title to act on
-- Should be 0 and '' if the command does not operate on a title
job_namespace int NOT NULL,
job_title varchar(255) binary NOT NULL,

-- Any other parameters to the command
-- Presently unused, format undefined
job_params blob NOT NULL default '',

PRIMARY KEY job_id (job_id),
KEY (job_cmd, job_namespace, job_title)
) TYPE=InnoDB;

Replace with:

CODE

CREATE TABLE /*$wgDBprefix*/job (
job_id int(9) unsigned NOT NULL auto_increment,

-- Command name, currently only refreshLinks is defined
job_cmd varchar(255) NOT NULL default '',

-- Namespace and title to act on
-- Should be 0 and '' if the command does not operate on a title
job_namespace int NOT NULL,
job_title varchar(255) binary NOT NULL,

-- Any other parameters to the command
-- Presently unused, format undefined
job_params blob NOT NULL default '',

PRIMARY KEY job_id (job_id),
KEY (job_cmd (160), job_namespace, job_title (160))
) TYPE=InnoDB;

原地址：http://www.ipbwiki.com/Media_Wiki:Specified_key_was_too_long%3B_max_key_length_is_1024_bytes
的方法，失败

继续找..其他失败的暂时就不说了..又找到..
his is a known bug, as we can see in bug 2907, so I modified maintenance/archives/patch-job.sql, added the following lines:

DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

after the “) TYPE=xxxxDB” line.
solved

原地址：http://blog.dragon2.net/2006/04/27/322.php

尝试了下..好使了...

可见....
会英语和搜索引擎的重要性...
又发现提供解决方法的是个blog..
可见....
web2.0
......
....