[rt-users] Installing the rt-1.3.70

[Serge Torop]

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