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