[Mediawiki-l] max key length is 1000 bytes

Thu Aug 2 15:41:55 UTC 2007

Bump! anyone, please?

rek2GNU/Linux wrote:
> OK, I have media wiki in this server installed for 3 domains.. today
> I went to do it again and I get this below, I search around and I try
> most of the solutions from changing 250 to 180 the (values)
> but still getting the problem.. :-( also notes the error for them is before
> than were I am getting it.. so maybe my case is different so here is a 
> copy and paste:
>
>
>
>    Checking environment...
>
> /Please include all of the lines below when reporting installation 
> problems./
>
>    * PHP 5.2.2-pl1-gentoo installed
>    * Found database drivers for: MySQL
>    * PHP server API is apache2handler; ok, using pretty URLs
>      (index.php/Page_Title)
>    * Have XML / Latin1-UTF-8 conversion support.
>    * *Warning:* A value for session.save_path has not been set in
>      PHP.ini. If the default value causes problems with saving session
>      data, set it to a valid path which is read/write/execute for the
>      user your web server is running under.
>    * PHP's memory_limit is 128M.
>    * Couldn't find Turck MMCache
>      <http://turck-mmcache.sourceforge.net>, eAccelerator
>      <http://eaccelerator.sourceforge.net>, or APC
>      <http://www.php.net/apc>. Object caching functions cannot be used.
>    * Found GNU diff3: /usr/bin/diff3.
>    * Found GD graphics library built-in, image thumbnailing will be
>      enabled if you enable uploads.
>    * Installation directory: /var/www/studentwalkout.info/htdocs
>    * Script URI path:
>    * Environment checked. You can install MediaWiki.
>    *
>
>      *Generating configuration file...*
>
>    * Database type: MySQL
>    * Loading class: DatabaseMysql
>    * Attempting to connect to database server as root...success.
>    * Connected to 5.0.42-log; enabling MySQL 4.1/5.0 charset mode
>    * Database swout 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.
> ...user_newtalk table already exists.
> ...transcache table already exists.
> ...trackbacks table already exists.
> ...externallinks table already exists.
> ...job table already exists.
> ...langlinks table already exists.
> ...querycache_info table already exists.
> ...filearchive table already exists.
> ...querycachetwo table already exists.
> ...have ipb_id field in ipblocks table.
> ...have ipb_expiry field in ipblocks table.
> ...have rc_type field in recentchanges table.
> ...have rc_ip field in recentchanges table.
> ...have rc_id field in recentchanges table.
> ...have rc_patrolled field in recentchanges table.
> ...have rc_old_len field in recentchanges table.
> ...have user_real_name field in user table.
> ...have user_token field in user table.
> ...have user_email_token field in user table.
> ...have user_registration field in user table.
> ...have log_params field in logging table.
> ...have ar_rev_id field in archive table.
> ...have ar_text_id field in archive table.
> ...have page_len field in page table.
> ...have rev_deleted field in revision table.
> ...have img_width field in image table.
> ...have img_metadata field in image table.
> ...have img_media_type field in image table.
> ...have ss_total_pages field in site_stats table.
> ...have iw_trans field in interwiki table.
> ...have ipb_range_start field in ipblocks table.
> ...have ss_images field in site_stats table.
> ...have ipb_anon_only field in ipblocks table.
> ...have ipb_enable_autoblock field in ipblocks table.
> ...have user_newpass_time field in user table.
> ...have user_editcount field in user table.
> ...have rc_deleted field in recentchanges table.
> ...have log_id field in logging table.
> ...have log_deleted field in logging table.
> ...have ar_deleted field in archive table.
> ...have ipb_deleted field in ipblocks table.
> ...have fa_deleted field in filearchive table.
> ...have rev_len field in revision table.
> ...have ar_len field in archive table.
> ...have rev_parent_id field in revision table.
> ...page_restrictions table does not exist, skipping new field patch
> ...already have interwiki table
> ...indexes seem up to 20031107 standards
> Already have pagelinks; skipping old links table updates.
> ...image primary key already set.
> The watchlist table is already set up for email notification.
> ...watchlist talk page rows already present
> ...user table does not contain old email authentication field.
> Logging table has correct title encoding.
> ...page table already exists.
> revision timestamp indexes already up to 2005-03-13
> ...rev_text_id already in place.
> ...page_namespace is already a full int (int(11)).
> ...ar_namespace is already a full int (int(11)).
> ...rc_namespace is already a full int (int(11)).
> ...wl_namespace is already a full int (int(11)).
> ...qc_namespace is already a full int (int(11)).
> ...log_namespace is already a full int (int(11)).
> ...already have pagelinks table.
> ...templatelinks table already exists
> No img_type field in image table; Good.
> Already have unique user_name index.
> ...user_groups table already exists.
> ...user_groups is in current format.
> ...wl_notificationtimestamp is already nullable.
> ...timestamp key on logging already exists.
> Setting page_random to a random value on rows where it equals 0...changed 0 rows
> Checking for additional recent changes indices...
> ...index on ( rc_namespace, rc_user_text ) seems to be ok
> ...index on ( rc_user_text, rc_timestamp ) seems to be ok
> ...redirect table already exists.
> Checking for backlinking indices...
> Checking if pagelinks index pl_namespace includes field pl_from...
> ...index pl_namespace on table pagelinks seems to be ok
> Checking if templatelinks index tl_namespace includes field tl_from...
> ...index tl_namespace on table templatelinks seems to be ok
> Checking if imagelinks index il_to includes field il_from...
> ...index il_to on table imagelinks seems to be ok
> Creating page_restrictions table...Query "CREATE TABLE `page_restrictions` (
> pr_page int(8) NOT NULL,
> pr_type varchar(255) NOT NULL,
> pr_level varchar(255) NOT NULL,
> pr_cascade tinyint(4) NOT NULL,
> pr_user int(8) NULL,
> pr_expiry char(14) binary NULL,
> PRIMARY KEY pr_pagetype (pr_page,pr_type),
> KEY pr_page (pr_page),
> KEY pr_typelevel (pr_type,pr_level),
> KEY pr_level (pr_level),
> KEY pr_cascade (pr_cascade)
> ) ENGINE=InnoDB, DEFAULT CHARSET=utf8
> " failed with error code "Specified key was too long; max key length is 1000 bytes (localhost)".
>
>
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l en lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>   

-- 
FSF member #697
BinaryFreedom Founder
gNewSense Developer.
Digital Rights!
Free Speech!
Free Software!!!!!!
Take back the NET!