Creating database schema.
CREATE TABLE KeywordSelects (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NULL ,
Keyword integer NULL ,
Single integer NULL ,
Depth integer NOT NULL DEFAULT 0 ,
ObjectType varchar(32) NOT NULL ,
ObjectField varchar(32) NULL ,
ObjectValue varchar(255) NULL ,
Disabled TINYINT NOT NULL DEFAULT 0 ,
PRIMARY KEY (id),
INDEX (Keyword),
INDEX (ObjectType, ObjectField, ObjectValue)
)
DBD::mysql::st execute failed: Column ‘Keyword’ is used with UNIQUE or INDEX
but is not defined as NOT NULL at tools/initdb line 69, line 2.
Column ‘Keyword’ is used with UNIQUE or INDEX but is not defined as NOT NULL
at tools/initdb line 69, line 2.
Issuing rollback() for database handle being DESTROY’d without explicit
disconnect(), line 2.
make: *** [database] Error 255
First up, I suspect you’re using Mysql 3.22, which won’t work with RT2.
Second up, thanks for drawing that index to my attention. it’s not quite
right…but it should work for now.
-jOn Fri, Feb 23, 2001 at 03:47:55PM -0000, Ben Carter (Lists) wrote:
Hi all,
anyone help with the following error.
Should the Keyword column be NOT NULL??
Ben.
Creating database schema.
CREATE TABLE KeywordSelects (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NULL ,
Keyword integer NULL ,
Single integer NULL ,
Depth integer NOT NULL DEFAULT 0 ,
ObjectType varchar(32) NOT NULL ,
ObjectField varchar(32) NULL ,
ObjectValue varchar(255) NULL ,
Disabled TINYINT NOT NULL DEFAULT 0 ,
PRIMARY KEY (id),
INDEX (Keyword),
INDEX (ObjectType, ObjectField, ObjectValue)
)
DBD::mysql::st execute failed: Column ‘Keyword’ is used with UNIQUE or INDEX
but is not defined as NOT NULL at tools/initdb line 69, line 2.
Column ‘Keyword’ is used with UNIQUE or INDEX but is not defined as NOT NULL
at tools/initdb line 69, line 2.
Issuing rollback() for database handle being DESTROY’d without explicit
disconnect(), line 2.
make: *** [database] Error 255