[rt-devel] MySQL tables problem

[Jesse]

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.

        -j


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??
> 
> 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, <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
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
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
                                               -M. Bulgakov