Page MenuHomePhabricator

error when updating database
Closed, ResolvedPublic

Description

when creating the /*prefix*/code_authors table, I'm the following error message

CREATE TABLE gdncode_authors (

  • Repository ID ca_repo_id int not null,
  • "Native" author name in the repo ca_author varchar(255) binary,
  • Local wiki username, if any, to tie the edits to instead
  • Using a username instead of ID so we don't have to worry
  • about SUL accounts which haven't been copied over. ca_user_text varchar(255) binary,

    primary key (ca_repo_id, ca_author),
  • Note that multiple authors on the same repo may point to
  • a single local user in some cases... unique key (ca_user_text, ca_repo_id, ca_author)

) /*$wgDBTableOptions*/;

#1071 - Specified key was too long; max key length is 1000 bytes


Version: unspecified
Severity: critical

Details

Reference
bz15931

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:21 PM
bzimport set Reference to bz15931.

That's mysql bug 4541 - http://bugs.mysql.com/bug.php?id=4541

You can workaround it by using latin1 instead of utf8 (you can force it on the key)

Mark as duplicate of bug 1322?

It'r run

*** This bug has been marked as a duplicate of bug 1322 ***