Architecture / Installation

Posted by nikotine 31 Oct 2004 15:40 GMT-0000 posts: 2

At this end of my install, I received a message like this

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

for any table

Message description
Command: CREATE TABLE tiki_newsreader_marks (
user varchar(200) NOT NULL default '',
serverId int(12) NOT NULL default '0',
groupName varchar(255) NOT NULL default '',
timestamp int(14) NOT NULL default '0',
PRIMARY KEY (user,serverId,groupName)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes

Command: CREATE TABLE tiki_page_footnotes (
user varchar(200) NOT NULL default '',
pageName varchar(250) NOT NULL default '',
data text,
PRIMARY KEY (user,pageName)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes

Command: CREATE TABLE tiki_searchindex(
searchword varchar(80) NOT NULL default '',
location varchar(80) NOT NULL default '',
page varchar(255) NOT NULL default '',
count int(11) NOT NULL default '1',
last_update int(11) NOT NULL default '0',
PRIMARY KEY (searchword,location,page),
KEY last_update (last_update)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes

Command: CREATE TABLE tiki_user_assigned_modules (
name varchar(200) NOT NULL default '',
position char(1) default NULL,
ord int(4) default NULL,
type char(1) default NULL,
user varchar(200) NOT NULL default '',
PRIMARY KEY (name,user)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes

Command: CREATE TABLE tiki_user_taken_quizzes (
user varchar(200) NOT NULL default '',
quizId varchar(255) NOT NULL default '',
PRIMARY KEY (user,quizId)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes

Command: CREATE TABLE tiki_user_votings (
user varchar(200) NOT NULL default '',
id varchar(255) NOT NULL default '',
optionId int(10) NOT NULL default 0,
PRIMARY KEY (user,id)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes

Command: CREATE TABLE tiki_user_watches (
user varchar(200) NOT NULL default '',
event varchar(40) NOT NULL default '',
object varchar(200) NOT NULL default '',
hash varchar(32) default NULL,
title varchar(250) default NULL,
type varchar(200) default NULL,
url varchar(250) default NULL,
email varchar(200) default NULL,
PRIMARY KEY (user,event,object)
) TYPE=MyISAM
Message: Specified key was too long; max key length is 1000 bytes