Loading...
 
Architecture / Installation

Architecture / Installation


At this end of install

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





posts: 2881 United Kingdom

What version of MySQL are you using?


Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.