[rt-users] Installing the rt-1.3.70

[Jesse]

You need to be running Mysql 3.23.x.   I suspect you are running 3.22

        -jesse


On Sat, Apr 28, 2001 at 04:13:14PM +0400, Serge Torop wrote:
> 
> Hello, all!
> 
> During installation I have the following message. Is this bug
> with mysql database schema?   "Keyword" must be "integer NOT NULL"?
> 
> ***
> Enter the mysql administrator's database password to create a new user for
> RT
> Enter password:
> 
> /usr/bin/perl   tools/initdb 'mysql' '/usr' 'rt.peterlink.ru' 'support'
> 'rt2' insert
> Now populating database schema.
> Enter the mysql password for support:
> 
> Creating database schema.
> DBD::mysql::st execute failed: Column 'Keyword' is used with UNIQUE or
> INDEX but is not defined as NOT NULL at tools/initdb line 160, <SCHEMA> 
> chunk 265.
> 
> Problem with statement:
>  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 int2 NOT NULL DEFAULT 0 ,
>   PRIMARY KEY (id),
>   INDEX (Keyword),
>   INDEX (ObjectType, ObjectField, ObjectValue)
> )
> 
> Column 'Keyword' is used with UNIQUE or INDEX but is not defined as NOT
> NULL at to
> ols/initdb line 162, <SCHEMA> chunk 265.
> Issuing rollback() for database handle being DESTROY'd without explicit
> disconnect
> (), <SCHEMA> chunk 265.
> make: *** [initdb.rtuser] Error 255
> 
> 
> -- 
> Serge P. Torop
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

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

that's security the same way that asking for directions to topeka and
being told that a seal is a mammal is informative
					-robin at apocalypse.org