[rt-devel] MySQL tables problem
jesse at fsck.com
Fri Feb 23 12:45:24 EST 2001
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.
On 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??
> 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, <STDIN> line 2.
> Column 'Keyword' is used with UNIQUE or INDEX but is not defined as NOT NULL
> at tools/initdb line 69, <STDIN> line 2.
> Issuing rollback() for database handle being DESTROY'd without explicit
> disconnect(), <STDIN> line 2.
> make: *** [database] Error 255
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
jesse reed vincent -- root at eruditorum.org -- jesse at 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
More information about the Rt-devel