MediaWiki-l,
The fixes on the bug report page do not seem to be working for me.
If I understand correctly, the file that needs to be altered is "tables.sql" in the maintenance directory.
Following the suggestions outlined on the bug report page, I have edited the code like so (some comments edited out fore brevity):
CREATE TABLE /*$wgDBprefix*/categorylinks ( cl_from int(8) unsigned NOT NULL default '0', cl_to varchar(78) character set utf8 collate utf8_bin NOT NULL default '', -- For MySQL 4.1+ with charset set to utf8, the sort key *index* -- needs cut to be smaller than 1024 bytes (at 3 bytes per char). -- To sort properly on the shorter key, this field needs to be -- the same shortness. cl_sortkey varchar(78) character set utf8 collate utf8_bin NOT NULL default '', cl_timestamp timestamp NOT NULL, UNIQUE KEY cl_from(cl_from,cl_to), KEY cl_sortkey (cl_to,cl_sortkey(78)), KEY cl_timestamp(cl_to,cl_timestamp) ) TYPE=InnoDB;
However, despite this, I still receive the following error: Please include all of the lines below when reporting installation problems.
* PHP 4.4.2-1build1 installed * Warning: PHP's register_globals option is enabled. Disable it if you can. MediaWiki will work, but your server is more exposed to PHP-based security vulnerabilities. * 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 8M. If this is too low, installation may fail! Attempting to raise limit to 20M... ok. * 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: /home/dave/web_sites/gutteridge.info/web * Script URI path: /web_sites/gutteridge.info/web * Environment checked. You can install MediaWiki.
Generating configuration file... * Database type: mysql * Attempting to connect to database server as root...success. * Connected to 4.1.15-Debian_1ubuntu5-log * Database gutteridge_wiki exists * There are already MediaWiki tables in this database. Checking if updates are needed... * DB user account ok
...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 `gw_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 (localhost)".
Have I not implemented the fixes correctly?
Thank you for any advice.
-- Dave M G