I just tried to do a clean install on a new server and got the following error:
Quote: MediaWiki 1.5.2 installation Please include all of the lines below when reporting installation problems.
Checking environment... PHP 5.0.5: ok Warning: PHP's register_globals option is enabled. MediaWiki will work correctly, but this setting increases your exposure to potential security vulnerabilities in PHP-based software running on your server. You should disable it if you are able. 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 128M. If this is too low, installation may fail! 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/data/www/willem/mediawiki Script URI path: /willem/mediawiki Trying to connect to MySQL on localhost as root... MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO) Trying regular user... ok. Connected to 4.1.14; enabling MySQL 4 enhancements Database wikitest exists Creating tables... using MySQL 3/4 table defs...Query "CREATE TABLE 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".
any idea what is wrong ?
Regards,
Seems InnoDB has some sort of limit on key lengths established which is preventing MediaWiki from creating part of a table.
Rob Church
On 21/11/05, Willem W.Koster@rug.nl wrote:
I just tried to do a clean install on a new server and got the following error:
Quote: MediaWiki 1.5.2 installation Please include all of the lines below when reporting installation problems.
Checking environment... PHP 5.0.5: ok Warning: PHP's register_globals option is enabled. MediaWiki will work correctly, but this setting increases your exposure to potential security vulnerabilities in PHP-based software running on your server. You should disable it if you are able. 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 128M. If this is too low, installation may fail! 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/data/www/willem/mediawiki Script URI path: /willem/mediawiki Trying to connect to MySQL on localhost as root... MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO) Trying regular user... ok. Connected to 4.1.14; enabling MySQL 4 enhancements Database wikitest exists Creating tables... using MySQL 3/4 table defs...Query "CREATE TABLE 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".
any idea what is wrong ?
Regards, _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Wel yes, but since I'm doing nothing specific, just installing the software as per the book, why am I getting this error whilest all other installations seem to be going as planned.
Could it be a MySQL-5 thing ? (I think we have 5 running on that system, I just thought of it).
Willem.
----- Original Message ----- From: "Rob Church" robchur@gmail.com
Seems InnoDB has some sort of limit on key lengths established which is preventing MediaWiki from creating part of a table.
Rob Church
On 21/11/05, Willem W.Koster@rug.nl wrote:
I just tried to do a clean install on a new server and got the following error:
Quote: MediaWiki 1.5.2 installation Please include all of the lines below when reporting installation problems.
Checking environment... PHP 5.0.5: ok Warning: PHP's register_globals option is enabled. MediaWiki will work correctly, but this setting increases your exposure to potential security vulnerabilities in PHP-based software running on your server. You should disable it if you are able. 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 128M. If this is too low, installation may fail! 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/data/www/willem/mediawiki Script URI path: /willem/mediawiki Trying to connect to MySQL on localhost as root... MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO) Trying regular user... ok. Connected to 4.1.14; enabling MySQL 4 enhancements Database wikitest exists Creating tables... using MySQL 3/4 table defs...Query "CREATE TABLE 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".
any idea what is wrong ?
Regards, _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
On 11/21/05, Willem Koster W.Koster@rug.nl wrote:
Wel yes, but since I'm doing nothing specific, just installing the software as per the book, why am I getting this error whilest all other installations seem to be going as planned.
Could it be a MySQL-5 thing ? (I think we have 5 running on that system, I just thought of it).
Willem.
See this message: http://mail.wikipedia.org/pipermail/mediawiki-l/2005-August/006195.html
Using utf-8 instead of Latin1 for the default character set for MySql led to similar problems, from Brion's note 1.5 should have circumvented this. But...
-- Rick DeNatale
Visit the Project Mercury Wiki Site http://www.mercuryspacecraft.com/
mediawiki-l@lists.wikimedia.org