MediaWiki installed just fine, and I went through the setup without issue. It connected to the database, and eveything returned success messages except when it was creating the tables. I got the following error:
Creating tables… using MySQL 4 table defs…Query "CREATE TABLE
mwiki_categorylinks ( cl_from int(8) unsigned NOT NULL default ‘0’, cl_to varchar(255) binary NOT NULL default ‘’, cl_sortkey varchar(86) binary NOT NULL default ‘’, cl_timestamp timestamp NOT NULL, UNIQUE KEY cl_from(cl_from,cl_to), KEY cl_sortkey(cl_to,cl_sortkey), KEY cl_timestamp(cl_to,cl_timestamp) ) TYPE=InnoDB " failed with error code “Specified key was too long; max key length is 1000 bytes (USERNAME.DOMAIN.com)”.
This seems to come up a lot. Any suggestions as to how to corerct this so that the tables get created successfully?