MySQL tables problem


#1

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


#2

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


Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

After all, it’s not every day you meet up with an evil power
-M. Bulgakov