Installing the rt-1.3.70


#1

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,
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, chunk 265.
Issuing rollback() for database handle being DESTROY’d without explicit
disconnect
(), chunk 265.
make: *** [initdb.rtuser] Error 255

Serge P. Torop


#2

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

    -jesseOn 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,
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, chunk 265.
Issuing rollback() for database handle being DESTROY’d without explicit
disconnect
(), chunk 265.
make: *** [initdb.rtuser] Error 255


Serge P. Torop


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

jesse reed vincent – root@eruditorum.orgjesse@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@apocalypse.org